Question

XPATH constraint date

0

Currently i have a listview of all objects. I want to filter out most of these objects based on a date. I only want to show results based on the latest date found in the listview and the 6 days prior to that date. E.g. The latest date in the list view is ‘10-12-2019’. So now I want to see all results between ‘10-06-2019’ and ‘10-12-2019’ OR How can i show all object where the date is equal to the latest date found in the list view?

asked 2019-10-08

Jannes Houben

1 answers

Tim v Steenbergen · Answer 1 · 2019-10-08

If you have a microflow as the datasource of the listview¸ then you can limit the retrieve to 7 records and sort it by date descending.

Your second option “How can I show all objects where the date is equal to the latest date found in the list view?”

If it is ok to do this via microflow: first get LatestDate by doing a retrieve with Range “First” and Sort by date descending. Then do a retrieve with XPath constraint “[Date = $LatestDate]”.