Using both the query builder and manual editing
2 min
Use the query builder to start an expression, look up field syntax, and select predetermined values. Then, edit the expression directly as needed.
Procedure
- Select fields and criteria.
- Click All to combine multiple criteria with a logical AND or Any to combine multiple criteria with OR. You can manually edit individual logical operators in the expression field.
- In the expression field, edit the expression directly.
- For example, you can add parentheses, change logical operators, or manually edit field names or values.
- The automatic syntax check displays a status icon next to the expression field. A green icon indicates that the syntax is correct, and a red icon if incorrect.
- When the syntax is correct, click Search to display the matching devices and their owners.
Once you manually edit the expression, the query builder is covered with a gray box to indicate it no longer represents the current state of the expression. Click the Reset link to remove your manual edits and continue using the query builder.
Example: Find all iOS or Android devices that use AT&T as their service operator.
Figure: Service operator in Query Builder
Build the expression to match the above example.
Procedure
- Click Advanced Search to open the query builder.
- Select Platform in the first field, select Equals for the operator, then select iOS as the platform.
- Click the plus icon to add another row for criteria.
- Select Platform, Equals, and Android as the field, operator, and platform value, respectively.
- Click the plus icon to add a third row for criteria.
- Select Home Operator Name for the field and Equals for the operator. Notice that the value field adjusts automatically to display service operator values by country.
- Accept the first value field and select AT&T in the second value field.
Manually edit the expression.
- Replace the first AND with OR. The syntax is checked automatically as you type. Note a red icon indicating incorrect syntax while you edit the expression.
- Add parentheses around the phrase to read: ("common.platform" = "iOS" OR "common.platform" = "Android") AND “common.home_operator_name” = “ATT&T” Note a green icon indicating correct syntax has replaced the red icon. Your advanced search will look the same as the original image (see below).
To revert to the original expression without your manual edits, click the Reset link to the right of the expression.
- Click Search to display the matching devices and their owners.