search

yogeshsd / query2report

Query2Report is a simple open source business intelligence platform that allows users to build report/dashboard for business analytics or enterprise reporting
https://sourceforge.net/projects/query2report/
GNU General Public License v3.0
51 stars 23 forks source link

Parameter not usable twice in query #7

Closed alopezalos closed 5 years ago

alopezalos commented 5 years ago

Might you please verify that a parameter can be used more than once in a query? Attached example bellow.

(select 'a) Total CDS new registered users: '||count(distinct(userid)) as users_info from users_cds where date_trunc('day',data_created) >= {date:date_from} and date_trunc('day',data_created) <= {date:date_to}) UNION (select 'b) Total CDS active users: '||count(distinct(username)) as users_info from brokerrequest_his where date_trunc('day',receivedat) >= {date:date_from} and date_trunc('day',receivedat) <= {date:date_to});

yogeshsd commented 5 years ago

The issue is fixed in the latest release