サーバーサイドフィルタリング

完全修飾クエリは、OR 演算子とAND 演算子の両方をサポートしています。OR 演算子は、ディメンションまたは指標のフィルタリングでAND 演算子と組み合わされる場合にのみ、同じカラムで使用できます。 OR 演算子を異なるカラムでAND 演算子と組み合わせて使用した場合、予期しない結果が生じる可能性があります。 例えば、次のクエリは予期しない結果を返す可能性があります。

 SELECT * FROM [Acquisitions] WHERE [StartDate] = '2023-03-22' AND [EndDate] = '2023-03-22' AND [PagePath] LIKE '%as' OR [Country] LIKE 'US' 

 SELECT * FROM [Acquisitions] WHERE [StartDate] = '2023-03-22' AND [EndDate] = '2023-03-22' AND ([Country] LIKE 'US' OR [Country] LIKE '%In') 

 SELECT * FROM [Acquisitions] WHERE [StartDate] = '2023-03-22' AND [EndDate] = '2023-03-22' OR [PagePath] LIKE '%as' 

 SELECT * FROM [Acquisitions] WHERE [PagePath] LIKE '%as' OR  [PagePath] LIKE 'A' OR [Country] LIKE '%In' 

 SELECT * FROM [Acquisitions] WHERE [PagePath] LIKE '%as' AND [Country] LIKE '%In' 

 SELECT * FROM [Acquisitions] WHERE [PagePath] LIKE '%as' AND ([Country] LIKE 'India' OR [Country] LIKE '%US') 

 SELECT * FROM [Tech] WHERE [StartDate] = '2021-01-01' AND [EndDate] = '2021-05-18' AND [NewUsers] >= 26 AND [NewUsers] < 35 AND ([Browser] IN ('Chrome', 'Edge') OR [Browser] = 'Edge') 

 SELECT * FROM [TechDeviceModelReport] WHERE [Date] >= '2020-05-13' AND [Date] <= '2023-06-13' AND [DeviceModel] != '(not set)' AND [DeviceModel] != '(test)' AND ([NewUsers] = 15 OR [NewUsers] = 20) 

 SELECT * FROM [Tech] WHERE [StartDate] = '2017-01-01' AND [EndDate] = '2023-05-02' AND CONTAINS ([Browser], 'ed') OR CONTAINS ([Browser], 'ch')