Cisco Cisco Prime Home 6.3 Developer's Guide
Cisco Prime Home – Integration Guide
OL-28557-01 v5.0.1
20
This will return documents that:
• Have a serial number that starts with "1000" and any field containing
"sam"
•
or, have any field containing "juni"
In other words, documents with fields containing "juni" will be returned even if
they do not have a serial number that starts with 1000.
To alter the binding, parenthesis must be use:
serialNumber:1000* and (sam or juni)
This will return documents that:
• Have a serial number that starts with with "1000"
• and, contain any fields with "sam" or "juni"
Not
To invert a search term, the "not" keyword is used. The following query will
return documents that do not contain "sam" in any field:
not sam
To restrict the query to return subscribers that do not contain "sam" in the
"name" field:
subscribers with name: not sam
The "not" keyword can be used with the "in" keyword as well. The following
query will return any subscribers that do not contain names "sam" or "juni":
subscribers with name: not in (sam juni)
Field Types
CAQL understands several types of data used in the ACS:
• Text
• Number
• Date
• IP address
CAQL interprets the data type of each term by the context of its usage, and then
its format. Single-term queries consisting of a value to be matched against any
document containing that term will only be interpreted as text or IP addresses.
Queries restricted to search a specific field will have those values parsed
according to their format as either text, numeric, date, or IP values. Data can be
"quoted" to force parsing as a string for matching against numbers in text fields,
e.g. serial numbers.
The format of each data type is explained in this section. Numbers are
expressed with 1 or more decimal characters ("0" - "9").
Numbers can be expressed with or without decimal points. Use of numbers
without decimal points has already been demonstrated. The following query