Server Side Filtering
Server Side Filtering
Fully Qualified queries supports both OR and And operator together. OR operator is only supported with same columns if it is used together with AND for filtering dimensions or metrics. For Example, the below query might give unexpected result:
SELECT * FROM [Acquisitions] WHERE [StartDate] = '2023-03-22' And [EndDate] = '2023-03-22' And [PagePath] LIKE '%as' OR [Country] LIKE 'US'Given below are few valid queries:
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')