Use datetime in retrieve activity

4
If i have a DateTime attribute in my retieved object(Retrieve from Database), is it possible to use an xpath constraint to retieve a object just by time, be it <,> or =? formatTime(ObjectDate) is not supported here. I currently use a split after the retrieve but is there a way to do it in the retrieve?
asked
1 answers
5

As of version 2.5.3 we have added functions that allow you to extract a certain part, e.g. the hours, from a DateTime value in an XPath constraint.

Here is an example that retrieves all objects that have the StartTime attribute set to 8am:

[hours-from-dateTime(StartTime) = 8 and
    minutes-from-dateTime(StartTime) = 0]

For the full list of functions, see this documentation page.

answered