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%'".
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 "WHERE status = :bindStatus ORDER BY id LIMIT 30",
the bind variable, represented by :bindStatus is named bindStatus, which would also be the parameter map key. The bind variable's
value would be represented by a parameter map value of type
TextValue. The final result, for example, would be an entry of
"bindStatus" => StringParam("ACTIVE").
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-08-20 UTC."],[[["The Statement object defines the `WHERE`, `ORDER BY`, and `LIMIT` clauses for retrieving specific data in Google Ad Manager using PQL."],["It supports bind variables as placeholders for literal values, allowing for dynamic queries."],["You can use the `LIKE` keyword for wildcard string matching within the `WHERE` clause, enhancing search flexibility."],["The `query` field contains the PQL syntax, while the `values` field stores bind variable keys and their corresponding values."]]],["The provided content details various services and a `Statement` structure used for querying. Services include managing ads, audiences, content, creatives, inventory, orders, and reports, among others. The `Statement` object facilitates PQL (Publisher Query Language) queries, defining `WHERE`, `ORDER BY`, and `LIMIT` clauses. It supports bind variables for dynamic values and the `LIKE` keyword for wildcard matching, using `query` and `values` to set these elements. `Values` are used to add the key and the value to the query.\n"]]
