search

teccod / Logi-Atscale-Tableau-Issues

Issues for intersystems products
0 stars 0 forks source link

Parammetr import SQL #23

Open njektt opened 2 years ago

njektt commented 2 years ago

Incorrect work of SQL query in Parameters. The connection type used is "InterSystems IRIS". When trying to create a Parameter with a query then request works correctly.

SELECT COUNT(ZPM_Analytics.Event.ID) FROM ZPM_Analytics.Event WHERE DateDiff('m', TS, @CurrentDate) = 2 AND Action = 'install'

If use query

SELECT COUNT(distinct ZPM_Analytics.Event.IP) FROM ZPM_Analytics.Event WHERE DateDiff('m', TS, @CurrentDate) = 2 AND Action = 'install'

That request returns nothing.

image