Cisco Cisco Prime Home 6.3 Guia Do Programador
Cisco Prime Home – Integration Guide
OL-28557-01 v5.0.1
19
Combining Terms
Multiple terms can be combined in a single search. By default, terms are
combined using AND logic. This query searches for devices with serial numbers
starting with "1000" and OUIs starting with "10":
devices with sn:1000* oui:10*
In the above example, use of the "and" keyword is implied. The following query
devices with sn:1000* oui:10*
In the above example, use of the "and" keyword is implied. The following query
is semantically identical to the previous query (the only difference being that
the "and" keyword is explicitly used):
devices with sn:1000* and oui:10*
Terms can be combined using OR logic using the "or" keyword. This query
searches for devices with serial numbers starting with "1000" or "2000":
devices with sn:1000* or sn:2000*
In Clause
A single term can be checked for one of multiple choices using the "in" keyword.
This query searches for subscribers with names "sam" or "juni":
subscribers with name in ( sam juni )
Note that this is identical to combining terms using the "or" keyword. The above
query is identical to:
subscribers with name: sam or name: juni
Phrases
To search for a specific phrase, enclose the words in quotes. This query searches
for the subscriber named "juniper jones":
subscribers with name: "juniper jones"
Ranged Searches
CAQL supports ranged searches. For instance, the following searches for devices
with an inform count between 1 and 100:
devices with informCount: from 1 to 100
Open-ended ranges are also supported. For instance, the following searches for
devices with an inform count of at least 100:
devices with informCount: from 100
The following searches for devices with an inform count no greater than 10:
devices with informCount: to 10
Precedence and Grouping
The "and" keyword binds more tightly than the "or" keyword. Consider the
following query:
serialNumber:1000* and sam or juni