קל לארגן דפים בעזרת אוספים
אפשר לשמור ולסווג תוכן על סמך ההעדפות שלך.
שפת השאילתות של Merchant Center מאפשרת לכם לסנן את מערך הנתונים שמוחזר באמצעות מספר אופרטורים שונים. כשמסננים ערכי מחרוזות, התלות באותיות רישיות שמוגדרת כברירת מחדל לכל אופרטור משחקת תפקיד חשוב בסינון התוצאות בצורה נכונה.
[null,null,["עדכון אחרון: 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'"]]
