Dashboard Discussion, Support, Examples, Help » Dashboard Creation

Dashboard Autorefresh

(2 posts)

Tags:

  1. admin
    Key Master

    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?

    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?

    Posted 7 months ago #
  2. admin
    Key Master

    For the refresh piece, can you verify the following properties for both the objects
    Edit the chart and look for property 'Include in Autrefresh', it should set to 'Y'

    similarly check the Qlet property.

    During autorefresh all the portlets that have 'Include in Autorefresh' as 'Y' will be refreshed except the ones that are meant for drill purpose.
    For e.g if you defined a Qlet which has param< , > 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.

    The Parent Qlet will be refreshed but not the child qlet.

    During autorefresh, the parameters are never refreshed unless you manually refresh them.

    I hope this explains, if not please feel free with any questions.

    Posted 7 months ago #

RSS feed for this topic

Reply

You must log in to post.