cancel
Showing results for 
Search instead for 
Did you mean: 

Query runs automatically on workbook open

Former Member
0 Kudos

Hi,

Generally when we open the workbook, query runs automatically with the last accessed selections or it pops up the variable screen and runs the query. Is there any way like query can be shown as a button, and runs when the user clicks on the button? It is just like planning folder wherein we have multiple layouts shown as buttons. If two queries are inserted in the workbook, on workbook open, it runs both the queries, means it is locking both the queries data even though user will plan on one query at first and the second query next. Please let me know if any one has done that.

Thanks,

Bindu

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

In the workbook settings, there is an option 'refresh workbook on open'. Uncheck that.

To create a button to re-run the query, use the command which sets a query to a data provider - put that behind the button.

Former Member
0 Kudos

Also, while rerunning the query using a button if you need to call the variable screen also for that query, you need to add another command - which calls the variable screen (show_variable_dialog or something similar).

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Bindu,

an easy solution could be run query in non-planning mode (you have a tick in query definition) and then add a button to change query to planning mode in the workbbok (there are standard function available in workbooks) This button can be for only one query or multiple queries in workbook.

Regards,

Enrique