Skip to main content
Version: v11.9.2

Scenario

Data Table is build using a single table from an imported Database. You might want to enable user selection for one column of the Data Table from values of a query result.

This document shows how a column for the editable Data Table can be bound to output from a Query and enabling user selection from that list.

Set up​

  1. WaveMaker app
  2. Import a Database (for this example we are considering an HR database with Employee and User table)
  3. Drag and drop Data Table (editable) using a table, say, Employee, as the data source.
  4. Create a Query for retrieving Dept id from the User table.
  5. Create a DB API variable for the above Query.

Procedure​

  1. Open the Advanced Settings of the Data Table and navigate to the Columns tab.
  2. Choose the required column and navigate to the Edit mode section.
  3. Choose the widget type as select from the drop-down.
  4. Set the Dataset is the variable that is created for the query service. Choose the data field and display field as per your requirement from the drop down.

Data Table Use Cases