Merchant Center Sorgu Dili, döndürülen veri kümesini filtrelemenize olanak tanır.
kullanabilirsiniz. Dize değerlerine göre filtre uygularken,
her operatörün varsayılan büyük/küçük harfe duyarlılığı, doğru
filtre uygulayabilirsiniz.
Operatörler
Büyük/Küçük Harf Duyarlılığı
= veya !=
Büyük/küçük harfe duyarlı
İÇİNDE (DEĞİL)
Büyük/küçük harfe duyarlı
(DEĞİL) BEĞENİ
Büyük/küçük harfe duyarlı
İÇERİR (...)
Büyük/küçük harfe duyarlı
REGEXP_MATCH
Her İkisi de İsteğe Bağlı
Örnek
SELECT segments.offer_id, metrics.clicks FROM MerchantPerformanceView WHERE segments.offer_id REGEXP_MATCH "(?i)AmazingOffer\d+" AND segments.date BETWEEN'2021-01-01'AND'2021-01-31'
[null,null,["Son güncelleme tarihi: 2024-09-20 UTC."],[[["The Merchant API is the new version of the Content API for Shopping and represents the future of the platform."],["Developers can learn more about the Merchant API and its benefits in the official announcement blog post."],["Merchant Center Query Language allows for data filtering with various operators, with differing case sensitivities for string values."],["The `REGEXP_MATCH` operator is case-sensitive by default, but offers case-insensitivity through the `(?i)` flag."]]],["The Merchant API beta, a new version of the Content API for Shopping, is introduced. The Merchant Center Query Language allows data filtering using operators. The operators `=`, `!=`, `(NOT) IN`, `(NOT) LIKE`, and `CONTAINS` are case-sensitive. `REGEXP_MATCH` is case-sensitive by default, but can be made case-insensitive with `(?i)` as defined in RE2 syntax. An example is provided showing filtering for `offer_id` with a case-insensitive regular expression.\n"]]
