Description:
This widget queries the database and displays 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 to the canvas and arrange 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. Select 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. Select the Actions - Create Form Instance menu option. Generate a new Form Instance, then select the check box to edit this Form Instance.
- The Form is rendered for the user as shown below. Enter a value and click the Search button. The “LookupViewData” displays the search result in a table. Click the Submit button to complete.
Definition Sample:
You may download 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.