Description:
This widget queries the database and shows the data in a table.
Inputs
- FormID - Name of widget generated by FlowWright (read-only field)
- Database Connection - Choose the connection string (previously configured)
- SQL Query - Enter a SQL Query
- Hide - Select the checkbox to Hide (tick mark)
- Save - Save the input values
- Delete - Remove this form widget from the designer page
- Close - Close the input popup window
Design:
Example:
Let’s build and execute the “LookupViewDataDef” example.
- Create a new Form Definition called “LookupViewDataDef.”
- Drag the “BootstrapGrid, Label, LookupViewData, and Submit” controls onto the canvas and position them as shown below.
- Double-click the “LookupViewData” control to configure the “Settings” properties. A pop-up window appears for configuration. Enter a name for the control. Enter the SQL Select query as shown below. Select the DB connection from the drop-down list. Check the “Hide” checkbox to hide this widget at runtime. Click the Save button.
- Double-click the “LookupViewData” control to configure the “Styling” properties. Enter the RGBA values for the background color. Enter the pixel values for the minimum height and width. Click the Save button.
- Save the Form Definition. Choose Actions > Create Form Instance. Generate a new Form Instance, then check the box to edit this Form Instance.
- The Form is displayed for the user as shown below. Enter a value and click the Search button. The “LookupViewData” shows the search results in a table. Click the Submit button to finish.
Definition Sample:
You may download and extract the sample definition(s) from the link provided and later import them (drag-and-drop) into your FlowWright Process Definition (XML file) or Form Definition (HTML file) page.
Note: Please verify and complete the process steps for any missing configurations, such as file path references and database connections, after the import. Then, save the definition to confirm the changes.
Click here to download the sample file.