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

完全修飾クエリでは、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')