Populate filter builder filter values from db

[wwarriner]

1. SmartClient Version v10.0p_2015-03-14/Power Edition Deployment
(built 2015-03-14)

2. Browser IE 11.0.9 and Firefox 13.0

3. Is it possible to populate a filter builder text equals operator filter value field with a list of possible values (an option list ?) where these values are derived from a database table ? If so could you point me in the right direction...

Thanks

[Isomorphic]

Set listGridField.filterEditorType to ComboBoxItem and supply an optionDataSource via listGridField.filterEditorProperties.

[wwarriner]

Thanks for the reply, I think I'm still missing something.

You suggest I Set listGridField.filterEditorType to ComboBoxItem and supply an optionDataSource via listGridField.filterEditorProperties; however its not clear to me how the listGridField relates to a filterBuilder object.

My datasource is defined in a xml file (mysource.ds.xml) where the field names, types, validOperators, etc are defined. The datasource is set on the filterBuilder object. The xml definition drives the filterBuilder.

In the xml I can set field type to enum and provide a valueMap of values that will populate the filterBuilder value optionMenu for the associated field, I'm wanting to polupate the optionMenu from a Db table vs a valueMap.

Sorry again for my confusion, just not clear to me how a listGridField plays into this, Or perhaps I wasn't clear in my original question

Perhaps you could point me to a sample ...

Thanks Again

[Isomorphic]

Sorry, the instructions we provided were actually for a FilterEditor not a FilterBuider as you asked.

FilterBuilder.getValueFieldProperties() is an override point where you can return a customized FormItem to be used for editing a particular combination of field and operator.

[wwarriner]

Thanks for the quick response