Clarity

Expand all | Collapse all

Emulate NOT EQUALS in XOG Filter

  • 1.  Emulate NOT EQUALS in XOG Filter

    Posted 05-04-2017 06:02 PM

    Hello,

     

    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?



  • 2.  Re: Emulate NOT EQUALS in XOG Filter

    Posted 05-04-2017 11:16 PM

    Hi Rizvi,

     

    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.

     

    XOG filters

     

    Will keep you posted if I get any option(s) to do it.

     

     

    Note:

    Please refer below community post where there is good information on filter criteria

    XOG Filters discussion   

     

     

    Regards,

    Srikanth G