Query language

The query language allows you to enter sophisticated object selection criteria, apply various conditions to the field values, and combine them using boolean operators.

How to form a query

Enter your query in the search bar at the bottom of any Direct Commander tab.

A simple search term consists of three parts:

= Field Operator Value```

For example, the query:

```no-highlight
= text ~ lesson 

shows all ads containing the word lesson in the Text column.

Start entering your search term following the = symbol. You can choose field and operator names from the popups.

When entering field names and values, please keep in mind:

• The input is not case sensitive.

• If the field name or value consists of multiple words separated by spaces, enclose it in quotation marks:

  = "Title 1" = "Singing lessons"
  

• If you need to find a substring that itself contains quotation marks, use the \ character:

  = "Title 1" = "\"Singing lessons\""
  

• If you want to specify multiple values, use square brackets:

  = "Title 1" = ["learn"; "singing"]
  

  or

  = "Title 1" = [learn singing]
  

• For fields that may include a fixed number of values (Placements, Moderation, Status, Priority, and others), always use the ~ and !~ operators with square brackets, even when querying a single value.

  

If the search term was not correctly formulated, the icon in the input field will change to and an error message will appear.

Requests containing multiple conditions

You can use the & (boolean AND) and | (boolean OR) operators to make combined queries.

Search term operations are executed strictly from left to right, but the order can be changed by using round brackets. Operations enclosed in brackets take priority over the standard order of operations.

Example 1

= Keyword ~ vocal | Keyword ~ coach

This query returns keywords containing the words vocal or coach.

Example 2

= Keyword ~ vocal | Keyword ~ coach & Bid > 1

This search term will return keywords that meet two conditions simultaneously:

1. Contains the word vocal or coach.
2. Has a search bid greater than 1.

Example 3

= Keyword ~ vocal | (Keyword ~ coach & Bid > 1)

This search term will return keywords that meet at least one of the two conditions:

1. Contains the word vocal.
2. Contains the word coach and has a search bid greater than 1.

Query language operators