Using AND OR in CUPI Query

Version 1
    This document was generated from CDN thread

    Created by: Mayank Sharma on 17-01-2011 02:36:59 PM
    Is it possible to use "AND" or "OR" in a CUPI query?
     
    https://<IP>/vmrest/users?query=(LastName is Doe AND DtmfAccessId is 9999)
    Update: I think I found the answer.
    The documentation says:
    Queries can specify more than one column only if all columns belong to a single compound index. (Note: the ability to specify more than one column is not yet implemented; at this time, only single criteria queries are allowed.)

    Thanks,
    Max

    Subject: RE: Using AND OR in CUPI Query
    Replied by: David Wanagel on 19-01-2011 08:58:20 AM
    Right now AND is supported on a limited number of fields, the example for a query like the one below is:
     
    /vmrest/users?query=(lastname is Doe)(dtmfaccessid is 9999)
     
    -Dave

    Subject: RE: Using AND OR in CUPI Query
    Replied by: Mayank Sharma on 19-01-2011 11:14:05 AM
    Thanks David. That helped.