Uneven beahaviour of Query Refresh Button

[Former Member]

Hi,

I am using query refresh button in my dashboard.

My problem is:

I have created the required query. No 'trigger cell'  or  'Refresh before components are loaded' in the query property.

Everything is managed by the query refresh button. I have given the trigger cell (when the value changes) and the dynamic visibility for the button.

But the problem is that the call is triggered whenever there is a change in the trigger cell, even if the query refresh button is invisible.

I tried the same with a simple dashboard with one query and one query refresh button and a push button( to make the qr button forcefully invisible). Then also the same error occurs ie, the call is triggered whenever there is a change in the trigger cell, no matter whether the qr button is visible or not.

Please help me.

Thanks in advance

- Sandeep

[former_member184839]

Hi Sandeep,

Do you want the query to be refreshed only when the connection refresh button is clicked , or you want it to trigger even when the value changes .Can you make it more clear? In the sense,what exactly is scenario, and what is that you want to achieve.

Thanks,

Sara G

[Former Member]

Hi Sara,

     The requirement is that the call is to be triggered only when the qr button is visible and the trigger cell value changes.(only when both conditions are satisfied) ie,the call should not be triggered when the button is invisible even if the trigger cell changes.

  Thanks in advance

- Sandeep

[Former Member]

Hi Sandeep,

The requirement is unusual, maybe you can follow a different approach. Instead of a refresh button, perhaps a push button which writes the necessary prompts to your trigger cell can do the trick. Whenever the visible push button is pushed, the values are changed and the prompts are triggered.

To meet your requirement in your way, I can only think of writing an if statement in to your trigger cell.

Something like:

=If( the refresh button visibility cell = true) then (triggercell & prompt values) else (static value)

This if statement has one drawback; whenever the refresh button becomes visible, it will refresh. I can't see a way to avoid that.

Hope it helps.

[Former Member]

Thanks Emre.

The end user doesn't want to have a push buttton( an extra interaction).

If I qoute you "whenever the refresh button becomes visible, it will refresh".

But for me it refresh even if the button is not visible.

I want to avoid the refresh when the button is not visible.

Thanks in advance

Sandeep