http://dashboard.infocaptor.com/ Dashboard Discussion, Support, Examples, Help Tag: multiple sql en Tue, 06 Jan 2009 10:33:22 +0000 http://dashboard.infocaptor.com/topic/multiple-queries-in-one-qlet-query-portlet#post-10 Thu, 10 Apr 2008 20:00:36 +0000 admin 10@http://dashboard.infocaptor.com/ <p>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?<br /> <pre><code>You can do this by just using two Qlets. Create one parent qlet, with unions if using Oracle database then select &#39;Table1&#39; from dual union select &#39;Table2&#39; from dual union select &#39;Table3&#39; from dual I think in MySQL you can just say select &#39;Table1 union select &#39;Table2&#39; union select &#39;Table3&#39; Now this is done in the first Qlet (parent) Next create a child Qlet with following query select * from param&lt;Table Name,x&gt; For the child Qlet, Set the &#39;Run on start&#39; property to &#39;No&#39; Once the parent and child Qlet are done, create a drill from the parent to child. Check the attached pdf tutorial</code></pre>