Dashboards – action triggers on page load

[dcrossey]

Hi Nick,

You could try passing in a boolean viewstate triggerEnabled to your virtual datasource, which has a default value as false when the page loads to prevent it clearing.

Something like:

 

function (x, triggerEnabled, callback){ if(!triggerEnabled) { callback(x) // i.e. just return x without modifying } else { callback ({ // i.e. your custom clear logic }); } }

 

Set the viewstate to true when you actually want to clear the viewstates.

You can also map an output viewstate to reset the triggerEnabled viewstate to false after execution.

Hope this helps!

Cheers,

David

[dcrossey]

Hi Nick,

Using the following as an example:

 

When I come to the dashboard, the text viewstate is present. There is a virtual query however it does not wipe this viewstate.

When I press clear, it activates the viewstate and clears the text.

 

If I refresh the screen, the default text “Hello World” is present:

 

or if I click reset text it will add “Hello World (again):

 

Button Actions

 

Virtual query

 

Result

 

Output mapping

 

 

Unfortunately I’m not able to attach json (example dashboard) on the Community portal yet, however I’ll drop you an email to see if it helps solve your issue.

Kind regards,

David

—

Virtual Query

 

function (source, enabled, callback) { 
   var result = { meta: { k:11, v:11 }, columns: [ "k", "v" ], rows: [] }; 
   if(enabled) { console.log('Clearing viewstates'); 
       result.rows = [ {k:'text', v:null}, {k:'triggerEnabled', v:false} ]; } 
   else { console.log('Returning current'); 
       result.rows= [ {k:'text', v:source}, {k:'triggerEnabled', v:enabled} ]; } 
   callback(result); }

 

 

[nick_mospan]

Hi David,

Thanks for reply. However I don’t think this solution will work as the fact of setting triggerEnabled to true will trigger the query, giving similar side effect.

[dcrossey]

Hi Nick,

I’ve updated the skeleton to make it a little clearer. When the page first loads, this virtual query will run but will not clear your parameters if you return the input without modifying.

It should only run the clear logic when you set the triggerEnabled to true (intentionally).

[nick_mospan]

How do I set triggerEnabled from an action (e.g. click on a cell in a data grid)? Isnt that the same problem as setting the original view state to null?

[nick_mospan]

Thanks David, I got it working now. I was confused at first as there’s no way to set a view state to a value in an action for a DataGrid, it can only copy from a cell. I adapted your solution and used the Row Id column instead of ‘true’, so in my case triggerEnabled is a string, not a boolean.