How to set a WEBI document to autorefresh each n seconds

[Former Member]

Hi,

there are a lot we can acomplish using Javascript from within a WEBI document. But it will only work if your viewwing the document through the HTML client.

For this first blog post, I will show how to set a Document to autorefresh itself each n seconds.

What you have to do is :

- Create a Document and set it to refresh on open;

- Drag a blank cell over the report and set its text to

  <script>

  self.parent._askConfirmationBeforeClosingDoc=false;

  setInterval(function(){window.parent.parent.location.reload();},n*1000);

  </script>

where n is the number of secons to refresh,

Save the report.

Re-open , right click on the blank cell inserted , choose 'Format Cell' and under 'Read content as' choose HTML.

Save the report again.

That´s it, it will refresh each n seconds without manual intervention.

Cheers,

Rogerio

It works in both BO 3.1 and BO 4.x