Why do custom queries on Last Modified fields return no data?

0 Likes

Problem:

Why do custom queries on Last Modified fields return no data?

Resolution:

ANSWER
----------------------------------
There is a known issue in SCIM 4.0.1 which results in "no data" being returned when the = operator is used to query the DateLastMod field. The issue arises because the search appends a timestamp of 00:00:00 to the date, meaning only entries created at that exact time would be returned.
This issue was not present in earlier versions and has been fixed in SCIM 4.1.0.

It is possible to workaround this issue and query a specific date by using syntax such as:

Main Fields | DateLastMod > 04/20/2006
Main Fields | DateLastMod 


This will query from 04/20/2006 00:00:00 to 04/21/2006 00:00:00.

Old KB# 23668
Comment List
Anonymous
Related Discussions
Recommended