One of the requirements for the dashboard I am building is that I am given a fixed set of SQL statements/stored procedures, in addition to other stuff that I put in the dashboard, that have to be executed and their result displayed. Obviously, one can create a QLET for each of them. But this means that there are many QLETs. Is it possible to have 1 QLET that displays different number of colums depending on what the SQL/stroed procedure returns?
You can do this by just using two Qlets.
Create one parent qlet, with unions
if using Oracle database then
select 'Table1' from dual
union
select 'Table2' from dual
union
select 'Table3' from dual
I think in MySQL you can just say
select 'Table1
union
select 'Table2'
union
select 'Table3'
Now this is done in the first Qlet (parent)
Next create a child Qlet with following query
select * from param<Table Name,x>
For the child Qlet, Set the 'Run on start' property to 'No'
Once the parent and child Qlet are done, create a drill from the parent to child. Check the attached pdf tutorial