Set xpath for data grid

0
Hi,   I would like to set the xpath for data grid to show the data that submitted only for that day. I have done something like this : [CreatedAt = CreatedAt and Status = 'Submitted']
asked
3 answers
8

You can try this out 

[day-from-dateTime(CreatedAt) = day-from-dateTime('[%CurrentDateTime%]')]
[month-from-dateTime(CreatedAt) = month-from-dateTime('[%CurrentDateTime%]')]
[year-from-dateTime(CreatedAt) = year-from-dateTime('[%CurrentDateTime%]')]
[Status = 'Submitted']


XPath query will fetch the record based on day, month, and year. So, it doesn’t require the range and it will retrieve the current day records.

answered
6

Please try below one

[day-from-dateTime(CreatedAt) = day-from-dateTime('[%CurrentDateTime%]')][Status = 'Submitted']

answered
2

You can do something like this:

[CreatedAt >= '[%BeginOfCurrentDay%]'][ CreatedAt <= '[%EndOfCurrentDay%]'][Status = 'Submitted']

 This will filter out the records created between the start and end of the current day.

Hope this helps.

answered