Creating a Drop Down (SQL Query) Prompt View

As of Aptify 5.5.3, all Aptify users can create prompt views where the contents of the drop down prompt is set dynamically using view prompt queries that contain the SQL necessary to populate the list with the desired data. 

Follow these steps to create a drop down (SQL query) prompt view:

1. Open the View Properties dialog for a new or existing view.
   • For new views in the Desktop client, right-click a service and select Create View from the pop-up menu.
   • For new views in the web interface, open a service and select More Actions > Create View.
   • For existing views in the Desktop client, right-click within the view and select View Properties from the pop-up menu.
   • For existing views in the web interface, open the view and click the Properties button in the view toolbar. 
     
     
2. Enter a Name and Description (for new views).
3. Select the Filters tab.

4. Add a Service, Field, and Operator in the first line of the Filters statement.

   You cannot use the In List, Is Blank, Is Not Blank operators with a Prompt view.

5. Click the Prompt Wizard button.
6. In the Prompt Wizard dialog, select the Drop Down (SQL Query) prompt type and click Next.
7. In the Select SQL Query field, enter the name of the desired view prompt query.
8. If you want a caption to appear in the dialog for your prompts, enter a caption in the Enter a prompt caption field.
   • The default caption defaults to a combination of the filter's Field and Operator (such as Name Exactly Matches). This caption appears in the prompt view when the view is run.
     
     
     
     
9. Click Finish to close the Prompt wizard.
10. In the Create View screen, click OK to close the screen and run the view.
    • A tab for this view is created.
      
      
11. In the tab for this view, go to the prompt caption drop down list box and select a value from the list or manually enter a value to view.
12. Click GO to display the results for your selection. 
13. To select a new value, repeat steps 12 and 13.