As of Aptify 5.5.3, administrators are able to use the View Prompt Query service to create view prompt queries that can be used to create views that contain prompts with dynamic content. The view prompt queries contain the SQL necessary to specify the content type that is displayed in the prompt list when the view is run. Users specify a view prompt query when creating a drop down (SQL query) prompt view. See Creating a Drop Down (SQL Query) Prompt View for more information about creating and running these views.
There are no default view prompt queries available in Aptify. Administrators create the view prompt queries required to support the ability to create and run drop down (SQL query) views, |
Perform the following procedure to create a view prompt query:
For example, to get a list of names from the database to populate the prompt list, enter the following in the SQL field:
select firstlast from vwpersons |