Fetching external data via dataset
Prerequisites
- Access to the File > Form (FO005) menu.
- Previously created form or responsive form.
- Previously created dataset.
- Previously created data source.
Introduction
When designing a form, we can create lists of values that fetch external data via dataset using SQL commands.
To illustrate, we will use the travel request form we have created.
In the form, we will configure the "Purchase requester" field of the "Ticket purchase request" section to fetch the list of possible requesters using a dataset.
Configuring a dataset list of values in a web form
Configuring a dataset list of values in a responsive form
• The data source is registered in SoftExpert Administration through the Configuration > Data source (AD047) menu.
• In the data source configurations, the Parameters panel will be enabled only if there is a parameter defined for a condition (WHERE) of the query (Query/SQL) of the selected dataset. For example, if a dataset that lists users by department is selected, and the department will be passed by parameter, the source of the department parameter must be defined, which may be a form field, a variable, or a fixed value.
• If the persistence parameters are not configured correctly, the system will display an error message and will not allow the data source configurations to be saved.
• The configuration for using a Web Service data source can be found in the How to use a Web Service data source article.
Conclusion
All done! Now you know how to configure a list using a dataset.