Server Lookups Demo
By default when showing a list of filter values (or a list of distinct column values when building a query) the Adaptable Blotter will create the distinct list based on what is currently in the DataSet.
However sometimes you might want to provide the Adaptable Blotter with a list of allowed values for lookups or filtering. You do this through the getColumnValues property of Query Options.
This property allows you to provide a method which will get the distinct values you want to show from the Server and return to the Blotter. If the return list is empty then we will show the list from the grid as normal.
This example provides custom value list for the 'Cust. Ref' and 'Contact' columns. When you filter on these columns or use them in a query only a subset of values are shown; other columns display distinct values normally.
Adaptable Blotter Help Resources: User Guide