http://dashboard.infocaptor.com/ Dashboard Discussion, Support, Examples, Help: Forum: Dashboard Creation - Recent Posts en Tue, 06 Jan 2009 06:30:56 +0000 http://dashboard.infocaptor.com/topic/scrolling-text-in-dashboard#post-29 Tue, 23 Dec 2008 15:19:46 +0000 admin 29@http://dashboard.infocaptor.com/ <p>Hi,<br /> We don't have scrolling text object as a seperate option.<br /> Alternatively, on the dashboard, you could create Sticky notes and Image objects. <a href="http://www.infocaptor.com/dashboard/sticky-notes-data-entry-fields-and-logos-or-images-on-dashboard" rel="nofollow">http://www.infocaptor.com/dashboard/sticky-notes-data-entry-fields-and-logos-or-images-on-dashboard</a></p> <p>So in order to create a scrolling text, one alternative would be to create a GIF image with the scroll effect and then use this image as the source to create the image object on the dashboard. </p> <p>We will consider adding scrolling text as a separate option. </p> <p>Thank you for your suggestion<br /> Harish </p> http://dashboard.infocaptor.com/topic/scrolling-text-in-dashboard#post-28 Tue, 23 Dec 2008 04:57:07 +0000 m4rc0 28@http://dashboard.infocaptor.com/ <p>Is it possible to create a scrolling text in Dashboard area ? </p> http://dashboard.infocaptor.com/topic/dashboard-autorefresh#post-14 Thu, 10 Apr 2008 20:07:37 +0000 admin 14@http://dashboard.infocaptor.com/ <p>For the refresh piece, can you verify the following properties for both the objects<br /> Edit the chart and look for property 'Include in Autrefresh', it should set to 'Y'</p> <p>similarly check the Qlet property.</p> <p>During autorefresh all the portlets that have 'Include in Autorefresh' as 'Y' will be refreshed except the ones that are meant for drill purpose.<br /> For e.g if you defined a Qlet which has param&lt; , &gt; filter in the where clause will not be refreshed for the obvious reason that it will hinder the autorefresh process by prompting for parameters everytime.</p> <p>The Parent Qlet will be refreshed but not the child qlet.</p> <p>During autorefresh, the parameters are never refreshed unless you manually refresh them.</p> <p>I hope this explains, if not please feel free with any questions. </p> http://dashboard.infocaptor.com/topic/dashboard-autorefresh#post-13 Thu, 10 Apr 2008 20:07:04 +0000 admin 13@http://dashboard.infocaptor.com/ <p>What I observed when I enabled the Auto-refresh feature is that all QLETs and GLETS appear to be updated (re-painted). The information in Process Status and Process Status Chart are updated. However, the data in Task Status and Task Status Chart don't seem to be updated. I should point out that Task Status relies on Process to pass to it the process_id, start_time and end_time to get the correct info from the database. During auto-refresh, the Parameter control are not being changed, that means if the Process (Parameter) SQL is not re-run, the start_time and end_time will not be updated and the Task Status will not get the correct info using start_time and end_time from previous setting. My question is: During Auto-refresh, will all the SQL associated with the Parameter controls be executed? Does the cascading od events (Team to Process) cause any problem?</p> <p>BTW, I created another Dashboad with similar constructs but use drill-down from the Process Status to the Task Status and it works OK. This indicates that I the SQL is OK. Just that I may be misunderstanding the auto-refresh facility. Could you explain to me what goes on during auto-refresh? </p> http://dashboard.infocaptor.com/topic/launch-external-url-not-working#post-12 Thu, 10 Apr 2008 20:04:56 +0000 admin 12@http://dashboard.infocaptor.com/ <p>One question, are you using MySQL as the database? If yes then the problem is related to it.</p> <p>For e.g When we used MySQL to put a link column for <a href="http://www.yahoo.com" rel="nofollow">http://www.yahoo.com</a> then the database wraps the url within a single quote 'http://www.yahoo.com' and this is why the launch url is not activated. If this is the case we will create a workaround and send you a solution </p> http://dashboard.infocaptor.com/topic/launch-external-url-not-working#post-11 Thu, 10 Apr 2008 20:04:07 +0000 admin 11@http://dashboard.infocaptor.com/ <p>I am still having problem getting the URL to work. Do you have any advice for me? It has to be something I've done. I desparately need to invoke external URL since InfoCaptor is a passive tool and I need to carry out some action. The only way is to invoke an existing web-application with the required parameters byinvoking a URL. </p> <pre><code>The SQL copied for the edit window that corresponds to the captured screen is: select t.display_name as task_name, t.id as task_id, IF(t.user_defined_flag = 0, &#39;false&#39;, &#39;true&#39;) as user_defined, IF(t.optional_flag = 0, &#39;false&#39;, &#39;true&#39;) as optional, CONCAT(&#39;http://&#39;, t.system_query) as Link from task t, process p, process_task a where a.process_id = p.id and p.id = param&lt;Process Id, 0&gt; and a.task_id = t.id;</code></pre> 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> http://dashboard.infocaptor.com/topic/java-script-in-dashboard#post-9 Thu, 10 Apr 2008 19:57:37 +0000 admin 9@http://dashboard.infocaptor.com/ <p>How to use Java script to invoke any external Windows program using Parameter? I imagine it will be similar to invoking the browser. </p> <blockquote><p> Yes, use the same syntax and call the appropriate program file </p></blockquote> http://dashboard.infocaptor.com/topic/call-stored-procedures#post-8 Thu, 10 Apr 2008 19:55:46 +0000 admin 8@http://dashboard.infocaptor.com/ <p>Is is possible to call a stored procedure? How does it determine the number of columns returned? </p> <blockquote><p> This is not available for the Qlet. But we will provide a mechanism where you just enter the stored procedure and then internally it will get the SQL dynamically and execute the SQL </p></blockquote> http://dashboard.infocaptor.com/topic/custom-column-name-description#post-7 Thu, 10 Apr 2008 19:54:02 +0000 admin 7@http://dashboard.infocaptor.com/ <p>Is it possible to change the column description in the QLET? For example, if I specify DATE_FORMAT(start, "%M %e, %Y %T") in the select statement, the description displayed is "DATE_FORMAT(start, "%M %e, %Y %T")' and it does not look that good. </p> <blockquote><p> You can change the column name, right click on any column, Click on the Column Settings Tab, Enter the column name in the 'Display Column name' property </p></blockquote> http://dashboard.infocaptor.com/topic/display-html-page-export#post-6 Thu, 10 Apr 2008 19:52:44 +0000 admin 6@http://dashboard.infocaptor.com/ <p>I was thinking that bring up a browser makes the dashboard look non-integrated. Is it possible to display the html page on the html control within the dashboard? If this is not possible, is it possible to disply a button instead of the URL to invoke the html page? </p> <blockquote><p> Which html page are you refering to? Are you referring to the Export to HTML option? </p></blockquote> http://dashboard.infocaptor.com/topic/dashboard-drill-from-pie-chart#post-5 Thu, 10 Apr 2008 19:50:40 +0000 admin 5@http://dashboard.infocaptor.com/ <p>Is it possible to drill down from a Pie chart? </p> <p>Ans - Not available at this moment, Drilling from pie chart is currently worked upon </p> http://dashboard.infocaptor.com/topic/different-row-color-based-on-colum-value#post-3 Thu, 10 Apr 2008 19:46:56 +0000 admin 3@http://dashboard.infocaptor.com/ <p>I am currently evaluating infocaptor. I've created a dashboard for my application. I have a number of questions:<br /> 1) using Qlets, is it possible to make each row to be displayed in a different color based on the value of a particular column eg, a column of type ENUM? </p> <blockquote><p> Yes, here is an example <a href="http://www.infocaptor.com/user_help/exception_stop_light.htm?MenuState=HE3xVRUERFB" rel="nofollow">http://www.infocaptor.com/user_help/exception_stop_light.htm?MenuState=HE3xVRUERFB</a> </p></blockquote>