Editing or creating a Lookup table

Using the Lookup Table console, you can edit an existing Lookup table or create a new Lookup table.

About this task

To edit an existing Lookup table or create a new lookup table, click <Lookup table name> link. The Lookup Table details page opens.

Procedure

Add or update the following in the Lookup Table details page.
Lookup table name Displays the Lookup table name.
Lookup spec Displays the Lookup table spec name.
Note: For Lookup spec, use String enum as the attribute instead of the Lookup Table attribute.
View version Select the version of the Lookup Table entries that you want to view.
Lookup table entries section
Save Click to save the updates that are done in the Lookup Table details page.
Revert Click to undo the updates that were done in the Lookup Table details page.
Refresh Click to refresh and reflect the updates that are done in the Lookup Table details page.
Add Click to add a Lookup table entry. Specify the value in the id column, and click Save.
Clone Click to clone an existing Lookup table entry. Specify the value in the id column, and click Save.
Import Click to bulk update the Lookup table entries. Select the updated Grid Data Export Report - YYYYMMDD_HHMMSS.xlsx file from your computer.
Export Click to download a list of Lookup table entries in the Grid Data Export Report - YYYYMMDD_HHMMSS.xlsx format.
Delete Select a Lookup table entry, and click Delete. The Delete confirmation pop-up window opens. To delete the Lookup table, click Yes.
Action Displayed only if the entry preview script is configured for a Lookup table.
Select all Click to select all the Lookup tables.
Click to locate a Lookup table entry containing the specified search keyword.
Click to filter a column by a value. Select an operator, specify the filter value, and click Filter.
Following are the operators that you can specify.
  • Starts with
  • Ends with
  • Contains
  • Equal
  • Empty
  • Does not begin with
  • Does not end with
  • Does not contain
  • Not equal
  • Is not empty
  • Like
Important:
  • Is not empty operator - Add a percentage symbol %as a prefix, suffix, or both to use the filter.
  • Like operator - There is a known Syncfusion limitation where the data is filtered in the application if the string is empty (""), but not when the string has a value as "null".