Description:
Displays data from a database using a SQL query.
Inputs
- ID/Name - Name of widget generated by FlowWright (read-only field)
- Select Connection - Select database connection string (pre-defined)
- Query - Enter the SQL Query
- Hide - Select the checkbox to Hide (tick mark)
- Allow Paging - Select the checkbox to include paging on render (tick mark)
- Show search box - Select the checkbox to include the search feature on render (tick mark)
Design:
Example:
Let’s build and execute the “TableDataDef” example.
- Create a new form definition called “TableDataDef”
- Select the Open Designer checkbox and click the “Create” button
- Drag a TableData widget to the canvas
- Double-click on the TableData widget to configure the inputs as shown in the below graphic
- Click on the Select Connection field to choose the connection string (pre-defined)
- Click on the Query field to enter the SQL query
- Click on the Save button and Close the popup window
- Navigate to the UI menu and Preview the form. The rendered widget will appear as shown in the graphic below