Logical AND/OR Operators

In this article

    The filter component in the query string may contain any number of comparison expressions. You can unite multiple comparison expressions with AND and OR logical operators.

    Logical Operator

    Query Syntax Character

    Description

    AND

    ; (Semicolon)

    All conditions specified in the filter parameter must be true.

    OR

    , (Comma)

    Any of the conditions specified in the filter parameter must be true

    For example, using the query below, you can get a list of jobs of the Backup type that are created for VMs on the Hyper-V platform:

    Request:

    GET https://localhost:9398/api/query?type=job&filter=jobtype==backup;platform==hyperv

     

    Response:

    200 OK

     

    Response Body:

    <QueryResult xmlns="http://www.veeam.com/ent/v1.0">
     <Refs>
       <Ref Type="JobReference" Href="https://localhost:9398/api/jobs/de14a4c9-3fb9-419b-b622-c6e3ebda28cb" Name="Exchange Backup" UID="urn:veeam:Job:de14a4c9-3fb9-419b-b622-c6e3ebda28cb">
         <Links>
           <Link Rel="Up" Type="BackupServerReference" Href="https://localhost:9398/api/backupServers/15942270-fb56-4dcc-96e9-5f80e4725a15" Name="localhost" />
           <Link Rel="Alternate" Type="Job" Href="https://localhost:9398/api/jobs/de14a4c9-3fb9-419b-b622-c6e3ebda28cb?format=Entity" Name="Exchange Backup" />
           <Link Rel="Down" Type="BackupJobSessionReferenceList" Href="https://localhost:9398/api/jobs/de14a4c9-3fb9-419b-b622-c6e3ebda28cb/backupSessions" />
         </Links>
       </Ref>
       <Ref Type="JobReference" Href="https://localhost:9398/api/jobs/dce85686-59c8-42c4-8766-f1c00a5b8067" Name="SQL" UID="urn:veeam:Job:dce85686-59c8-42c4-8766-f1c00a5b8067">
         <Links>
           <Link Rel="Up" Type="BackupServerReference" Href="https://localhost:9398/api/backupServers/15942270-fb56-4dcc-96e9-5f80e4725a15" Name="localhost" />
           <Link Rel="Alternate" Type="Job" Href="https://localhost:9398/api/jobs/dce85686-59c8-42c4-8766-f1c00a5b8067?format=Entity" Name="SQL" />
           <Link Rel="Down" Type="BackupJobSessionReferenceList" Href="https://localhost:9398/api/jobs/dce85686-59c8-42c4-8766-f1c00a5b8067/backupSessions" />
         </Links>
       </Ref>
     </Refs>
     <PagingInfo PagesCount="1" PageSize="100" PageNum="1">
       <Links>
         <Link Rel="First" Href="https://localhost:9398/api/query?type=job&filter=jobtype==backup%3bplatform==hyperv&pageSize=100&page=1" />
         <Link Rel="Last" Href="https://localhost:9398/api/query?type=job&filter=jobtype==backup%3bplatform==hyperv&pageSize=100&page=1" />
       </Links>
     </PagingInfo>
    </QueryResult>