AI-generated Key Takeaways
-
Statements are used to capture the WHERE, ORDER BY, and LIMIT clauses of a PQL query to retrieve objects of a predefined domain type.
-
Statements support bind variables, which act as substitutes for literals and can be considered input parameters to a PQL query.
-
Statements also support the use of the LIKE keyword for wildcard string matching in queries.
-
Bind variables require their values to be set using an object of type Value, such as NumberValue, TextValue, or BooleanValue.
-
The
query
field holds the PQL query string, while thevalues
field holds key-value pairs for bind variables and their corresponding literal values.
Captures the WHERE
, ORDER BY
and LIMIT
clauses of a
PQL query. Statements are typically used to retrieve objects of a predefined
domain type, which makes SELECT clause unnecessary.
An example query text might be "WHERE status = 'ACTIVE' ORDER BY id
LIMIT 30"
.
Statements support bind variables. These are substitutes for literals and can be thought of as input parameters to a PQL query.
An example of such a query might be "WHERE id = :idValue"
.
Statements also support use of the LIKE keyword. This provides wildcard string matching.
An example of such a query might be "WHERE name LIKE '%searchString%'"
.
- Namespace
-
https://www.google.com/apis/ads/publisher/v202502
Field |
|
---|---|
|
Holds the query in PQL syntax. The syntax is:
|
|
Holds keys and values for bind variables and their values. The key is the name of the bind variable. The value is the literal value of the variable.
In the example |