I am trying to use the XOG Object API to read a list of Project objects that are filtered by various queries. In order to get a list of projects that contain "ktlo" in their name, I can use the following in the Query section of my XOG request:
<Query> <Filter name="active" criteria="EQUALS">true</Filter> <Filter name="name" criteria="EQUALS">%ktlo%</Filter> </Query>
How would I do the inverse? That is, return a list of projects that DO NOT have "ktlo" in the project name. Is this possible using the Object API or would I have to write a custom NSQL query and use the Query API instead?
Have tried few things but could not get the inverse results what you are looking for.
Also, I looked through the XOG Documentation and the possible filtering options are EQUALS, OR, BEFORE, AFTER, and BETWEEN.
Will keep you posted if I get any option(s) to do it.
Please refer below community post where there is good information on filter criteria
XOG Filters discussion