What is the syntax to compare Dates from two entities with XPath? Here are two simple entities and attributes: Entity #1 – Order Name OrderDate Qty Price Entity #2 – Report Name StartDate EndDate Within a DataView of a Report, I want to create an XPath Data Source for a List View on the Order entity. I want to filter the orders where the OrderDate falls between the StartDate and EndDate of the Report. I will be using this to let the user select which orders they want to include in the report. How do I do this? Peace, Keith
Likely your Report entity has no association to the Order entity, because logically there is not any relation between the two.
Rather then creating a XPath datasource, create a microflow datasource and in that microflow retrieve Order using $Report's dates like this: