FireDAC Components for Google Analytics

Build 23.0.8804

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8804