AnsweredAssumed Answered

Dynamic datasource group by

Question asked by Glupe Registracije on Mar 21, 2018
Latest reply on Apr 4, 2018 by Glupe Registracije

Hi,

 

for current dashboard we use SQL Queries (sql over sqljndi) to select out data and present them in a table.

For example our two selects look like:

select session_id, count(*) from table group by session_id

select issue_id, count(*) from table group by issue_id

 

Is there a way to have group by as parameter? If we use a simple parameter and select components (with options: session_id, issue_id) for choosing a group by field, but can we somehow use that parameter to change datasource in the following way?

 

select ${fldGroupBy}, count(*) from table group by ${fldGroupBy}

 

Can we use parameter for dynamically changing select in such way?

 

Regards

Outcomes