Question

xpath constraint for datetime attribute

0

Hi all, I have a table. My microflow is inserting data to this table at a 10 seconds interval. the table has an attribute called ‘DateEntry’, I want to write a xpath constraint so that only records inserted within the ‘Last 3 minutes’ to be shown. How should i write the xpath constraint, please advise thank you

asked 2020-10-26

Aaron Shaw

1 answers

Nico Mouton · Accepted Answer · 2020-10-26

Hi Aaron,

I’m not sure if you can directly subtract 3 minutes within your XPath, but what you can do is to change your data source to microflow. In the microflow, create a date variable with the value addMinutes(‘[%CurrentDateTime%]’, -3) – let’s assume the variables name is CheckDate – and then retrieve from the database with the XPath [DateEntry > $CheckDate] and return the list.

The downside of this approach is that you will have to refresh your page to get the new data...