Column Values Lookup Demos
There are a few places in the Adaptable Blotter when a list of distinct column values is displayed.
For instance when using a Column Filter, or in the Column Values section of the Query Builder, or in the Bulk Update function.
By default when showing list of available column values, the Adaptable Blotter will show the first 2,000 distinct values, but you can amend this by setting the maxColumnValueItemsDisplayed property in Query Options section of Adaptable Blotter Options.
Any values that exceed the count will be ignored. See the Max Items Displayed Demo.
There is a hierarchy for how the Adaptable Blotter will retrieve this options as follows: (Note: in all 3 options, the Adaptable Blotter will not show more values than that set in the maxColumnValueItemsDisplayed property)
- Server Lookups: You can provide the Adaptable Blotter dynamically (through client-server communication) with the list of values that can be displayed each time a list of distinct cell values is required.
You set this through the getColumnValues property in Query Options section of Adaptable Blotter Options. See the Server Lookups demo for more information.
- Permitted Column Values: You can provide the Adaptable Blotter at startup with a list of column names and a list of values which should be displayed when getting distinct values for that column.
You do this through UserInterface state section of Predefined Config. See the Permitted Values demo for more information.
- Dynamic Values: If no Server Lookups or Permitted Column Values have been set for that column, the Adaptable Blotter will dynamically retrieve all the distinct values for that column.