ComboBox - Filter on Multiple Columns?

[Eric]

How can I instruct the combo box filter to operate on multiple columns (in effect a composite search)?

Simple example :
Lets say I have a combo box with currencies.   The options looks someting like    " <Code> - <Name>  (<symbol>)". I want the "contains" filter to operate on name, code, and symbol.  Data looks something like :

   Currencies =  [
           {"Name": "Argentine Peso", "Code": "ARS", "Symbol": "$" },
           {"Name": "Armendian Dram", "Code": "AMD", "Symbol": "AMD"},
           {"Name": "Aruba Florin", "Code": "AWG", "Symbol": "ƒ"},
           {"Name": "Australian Dollar", "Code": "AUD", "Symbol": "$"}
      ]

My Kendo declaration looks something like :

                <select  name="Currency_RecordID"
                            kendo-combo-box   
                            k-data-source        = "DataModel.Currencies"
                            k-rebind            = "DataModel.Currencies"
                            k-placeholder        = "Labels.PleaseSelect"
                            k-data-text-field    = "'Name'"
                            k-data-value-field    = "'RecordID'"
                            k-value                = "LineModel.Currency.RecordID"
                            k-model                = "'LineModel'"
                            k-model-property    = "'Currency'"
                            k-filter            = "'contains'"
                            k-auto-bind            = "true"
                            k-min-length        = "1"
                            k-template            = "'#= Code # - #=Name# (#=Symbol#)'"
                            k-openOnFocus        = "'irrelevant'"
                            k-limitPredefined    = "'just quote me'"
                        >
                </select>



Is there a way to go about this ?

[Kiril Nikolov]

Hello Eric,

Filtering by multiple fields is not part of the built-in functionality of the Kendo UI Combobox.  You can filter the dataSource by multiple filters, but this could be done using the dataSource API and the query method, as in this example:

http://jsbin.com/cevide/1/edit

Regards,
Kiril Nikolov
Telerik

 

 

[Mario Antonio]

Do you have a combobox and 2 columns filter example with dataSource API?

Thanks

[Veselin Tsvetanov]

Hi Mario Antonio,

Here is an example of using the MultiColumnComboBox widget and filtering by multiple columns values:

https://demos.telerik.com/kendo-ui/multicolumncombobox/index

Please, note that we do not have a server-side filtering example where the remote endpoint is configured to work with two columns values.