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 pada setiap operator berperan penting dalam
dan menyaring hasil Anda.
Operator
Kepekaan Huruf Besar/Kecil
= atau !=
Peka huruf besar/kecil
(BUKAN) DI
Peka huruf besar/kecil
(BUKAN) SUKA
Peka huruf besar/kecil
BERISI (...)
Peka huruf besar/kecil
REGEXP_MATCH
Opsional Keduanya
Contoh
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'
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Informasi yang saya butuhkan tidak ada","missingTheInformationINeed","thumb-down"],["Terlalu rumit/langkahnya terlalu banyak","tooComplicatedTooManySteps","thumb-down"],["Sudah usang","outOfDate","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Masalah kode / contoh","samplesCodeIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],["Terakhir diperbarui pada 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"]]
