TableData Widget

Use this widget to display data from a database.

Last published at: June 3rd, 2024

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