我需要擴展 AWQL 報告查詢。查詢當前是"SELECT Id, AveragePosition, CpcBid, KeywordMatchType, Labels, AdGroupId, AccountDescriptiveName, Criteria " + " FROM KEYWORDS_PERFORMANCE_REPORT " + " WHERE Status IN [ENABLED] " + " DURING " + reportingPeriod.value;我需要在 WHERE 子句中添加更多條件。具體來說,我有一個對象列表,每個對象都有一個Set<String>for 標簽和一個對平均位置的要求。我試過:AND ((Labels CONTAINS_ANY ['object_1_label1'] AND CpcBid>2.0) OR (Labels CONTAINS_ANY ['object_2_label_1','object_2_label_2'] AND CpcBid<=3.0)...)Google 在 where 子句中報告錯誤。有任何想法嗎?
添加回答
舉報
0/150
提交
取消