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' 

 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')