...
- Log in to Aptify with an account with administrative access.
- In the Web Services application, open the View Prompt Query service.
- Open a new View Prompt Query record.
- In the Name field, enter a name for the view prompt query.
- In the Service Data Object ID field, specify the service data object that contains the SQL to identify the desired content type.
- See Create A Creating a Service Data Object for more information about creating a new service data object.
For example, to get a list of names from the database to populate the prompt list, enter the following in the SQL field:
No Format nopanel true select firstlast from vwpersons
- In the Description field, enter a description of the view prompt query (optional).
- Save and close the View Prompt Query record.
...