Use Queries to populate data

· The user takes enter Query if the values to be entered are quite more and the user may find it difficult to enter each of them manually.

· List of values appears once the user wishes to add a particular value under a certain column.

Step 1: Define Query

· User can define the Query while defining the User Defined Table.

· Since we have already defined the table, we just edit it to enter the Query. Click on the Edit icon.

· Find the Generate option at the end of the Item row. Enter the Query that provides a list of Items when the user wishes to add any Item in the table. Save it.

· Save the changes in the Used Defined Tables.

· Since the Menu Design and User Authorization is already done. We directly check how Query works on UDF TABLE. Refer Example

· Clear Cache before adding Items in the UDF TABLE.

Step 2: Add Row/Data in User Defined Table

· Go to Menu Bar --> User Tables --> Sample Table Name. Click on Add icon to add some value under Item Column.

· Click on the search icon beside the item to see the list of Items.

· Select any Item among the list of Items.

· Other fields can also be filled and click Add.

· User can see newly added Items in the Table.