New CRM SDK Feature - New Query Operators

19 April 2015
Daniel Cai

CRM query system has been further enhanced in CRM Online 2015 Update 1 release to support more datetime filtering operators.

Additional Older-than Operators

Older-than operators allow you to perform filtering against CRM date/time fields by returning the records that are older than the provided criteria. CRM Online 2015 Update 1 release added a few more older-than operators in addition to the olderthan-x-months operator which was available before this release.

Operator Allowed Values Supported Version
olderthan-x-minutes 1-1440 v7.1+
olderthan-x-hours 1-2000 v7.1+
olderthan-x-days 1-500 v7.1+
olderthan-x-weeks 1-100 v7.1+
olderthan-x-months 1-100 v3.0+
olderthan-x-weeks 1-100 v7.1+
olderthan-x-years 1-100 v7.1+

Note that olderthan-x-months may have been around even before v3.0.

Those new operators can be seen in CRM Advanced Find window.

2015-04 New Query Operators

For further details about how to use those operators, please refer to CRM SDK documentation page: Date and time query operators in FetchXML.

Hope this helps.

Daniel Cai | KingswaySoft

Read the full New SDK Capabilities Blog Series: