Koleksiyonlar ile düzeninizi koruyun
İçeriği tercihlerinize göre kaydedin ve kategorilere ayırın.
Merchant Center Sorgu Dili, döndürülen veri kümesini çeşitli operatörlerle filtrelemenize olanak tanır. Dize değerlerine göre filtreleme yaparken her operatörün varsayılan büyük/küçük harf duyarlılığı, sonuçlarınızı doğru şekilde filtrelemede önemli bir rol oynar.
[null,null,["Son güncelleme tarihi: 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'"]]
