Execute Stored Query

Execute Stored Query

HelpID: 460022023

Execute Stored Query allows a user to select from one of the pre-defined Stored Queries and run the query. No changes can be made to the query from this window.

Navigation: Tools >> Utilities >> System >> Execute Stored Query

Stored Query Name: The drop-down list shows the Query Names. A query appears in this list when:

  • The user has security access to the query
  • The query is assigned to the current company database, or All Companies, or Dynamics
  • The query has the Execute Only box marked

Description: displays the Stored Query description.

Execute Button: Click the EXECUTE button to run the query. If the query requires parameters, the Parameters window will open. If the query does not require parameters, the query is executed after clicking the button.

The Query will run when the DONE button is clicked on the Parameters window.

Cancel Button: A query that returns a large amount of data can take a long time to display. The Cancel Button will stop filling the window with results.

Excel Button: If the query is marked to Show Results, the Excel button will be enabled.