This action executes the query and shows its result to the user. Its flow differs for simple and parameterized queries.
For simple (non-parameterized) query:
1. Query is executed
2. Query result is shown to the user using Edit Properties UI Procedure. If query result contains some editable fields, user can edit them and save changes. All changed data will be saved back to the contexts from which it originally came.
For parameterized query:
1. User is prompted to enter query parameters
2. Parameters entered on step 1 are used to produce final query text according to the text of parameterized query
3. Query is executed
4. Query result is shown to the user using Edit Properties UI Procedure. If query result contains some editable fields, user can edit them and save changes. All changed data will be saved back to the contexts from which it originally came.
|
If query is Parameterized or Disable Editable Result flag is enabled in query properties, query result is shown using Edit Data UI Procedure instead of Edit Properties. |
If some errors occur during query execution or parameterization, they are shown to the user using Show Error UI Procedure.
Action Name: |
execute |
Non-Interactive Mode: |
Not Supported |
Permissions: |
Accessible at Observer permission level |
Execution Parameters: |
Query Result Window Location |