Hello, how can we help you?

Recent Searches: SoftExpert Survey tasks - SoftExpert Survey views - Revising a survey template - Adding a question group

Fetching external data via dataset

 

Prerequisites

 

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.


Was this article helpful?