Zadbaj o dobrą organizację dzięki kolekcji
Zapisuj i kategoryzuj treści zgodnie ze swoimi preferencjami.
Język zapytań Merchant Center umożliwia filtrowanie zwracanego zbioru danych za pomocą różnych operatorów. Podczas filtrowania wartości tekstowych domyślne rozróżnianie wielkości liter w przypadku każdego operatora odgrywa ważną rolę w prawidłowym filtrowaniu wyników.
[null,null,["Ostatnia aktualizacja: 2025-08-13 UTC."],[[["\u003cp\u003eThe Merchant API is the new version of the Content API for Shopping and represents the future of the platform.\u003c/p\u003e\n"],["\u003cp\u003eDevelopers can learn more about the Merchant API and its benefits in the official announcement blog post.\u003c/p\u003e\n"],["\u003cp\u003eMerchant Center Query Language allows for data filtering with various operators, with differing case sensitivities for string values.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003eREGEXP_MATCH\u003c/code\u003e operator is case-sensitive by default, but offers case-insensitivity through the \u003ccode\u003e(?i)\u003c/code\u003e flag.\u003c/p\u003e\n"]]],["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"],null,["# Case sensitivity\n\nThe Merchant Center Query Language lets you filter the returned data set\nwith a number of different operators. When filtering on string values, the\ndefault case sensitivity of each operator plays an important part in correctly\nfiltering your results.\n\n| Operators | Case Sensitivity |\n|----------------|------------------|\n| = or != | Case sensitive |\n| (NOT) IN | Case sensitive |\n| (NOT) LIKE | Case sensitive |\n| CONTAINS (...) | Case sensitive |\n| REGEXP_MATCH | Optionally Both |\n\n| **Key Point:** `REGEXP_MATCH` and `NOT REGEXP_MATCH` are case-sensitive by default, but you can include `(?i)` as described in the [RE2 syntax](https://github.com/google/re2/wiki/Syntax) to make them case-insensitive.\n\nExample\n-------\n\n SELECT\n segments.offer_id,\n metrics.clicks\n FROM MerchantPerformanceView\n WHERE segments.offer_id REGEXP_MATCH \"(?i)AmazingOffer\\d+\"\n AND segments.date BETWEEN '2021-01-01' AND '2021-01-31'"]]
