Permitted Values Demo (User Inferface State)

When AdapTable wants to provide a list of values for a column (e.g. in a column filter, or when building a query or in Bulk Update) it will first get the list from Server Lookups if that has been set.

If not then it will look for any Permitted Columns values for that column. These are set through the PermittedValuesColumns property in the User Interface section of Predefined Config.

In this example we have set Permitted Column Values for Contact and Employee Columns so that only the restricted set of values we have listed are displayed in their Column Filters (and in Query Builder).

Note: if there are no Permitted Values, then AdapTable wtill dynamically build a list of distinct values for the column.

AdapTable Help Resources: