Cisco Cisco Prime Home 6.3 Developer's Guide

 

OL-28558-01   v5.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 

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