Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Bahasa Kueri Merchant Center memungkinkan Anda memfilter set data yang ditampilkan dengan sejumlah operator yang berbeda. Saat memfilter nilai string, kepekaan huruf besar/kecil default setiap operator memainkan peran penting dalam memfilter hasil Anda dengan benar.
[null,null,["Terakhir diperbarui pada 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'"]]
