Use ID behind text value of column in grid as filter

[Roland]

Hello Telerik,

I'm currently trying to get some columns in a KendoUI Grid to display a value OTHER than the value I want to pass in the "read" function to use in filtering the servery side query.  Right now all the other columns are using the actual displayed value to pass back to the filtering query on the backend.  So we're frequently using strings like "John Doe, Jane Doe" instead of a lstUserIDs "1,2" because we can't seem to get filtering functions to pass the id values instead of display values.  Here's a sample of the actual case in question.  I wasn't able to determine from the serverside demo in the docs how this might be accomplished, or even if it could.  

With the column configured as below, I end up with an error "VM8499:3 Uncaught ReferenceError: asset_class_nm is not defined".  Changing the inner field to "asset_class_nm" works, but then I again have a text list of the names instead of the list of internal bigint IDs that I'd like.  Thanks!

,{
                    field: "asset_class_nm",
                    title: "Asset Class",
                    attributes: {
                        style: "text-align: left;"
                    },
                    filterable: {
                        dataSource: {
                                transport: {
                                    read: {
                                        url: "srv_get_asset_classes.cfm",
                                        dataType:"json",
                                        data: {
                                            field: "asset_class_id"
                                        }
                                    }
                                }
                        },
                        multi: true
                    }
                }

[Alex Hajigeorgieva]

Hello, Roland,

The Kendo UI Grid with multi check filtering has an itemTemplate that can be used to pass a different value as the filter value, for example:

itemTemplate:function(e) {
    return "<div><label><input type='checkbox' name='" + e.field + "' value='#= data.ProductID #'/></label><span>#= data.ProductName|| data.all #</span></div>"
},

Using an itemTemplate as above results in a filter as pictured below - the filter field is still the same as the bound column field - ProductName but the value is the ProductID:




I hope this is what you want to achieve, please correct me in case I have misunderstood.

Regards,
Alex Hajigeorgieva
Progress Telerik

[Roland]

Thanks, Alex.

This is exactly what I was looking for, and I was actually coming here to respond to the post and give the exact information you just did.  I was working with another developer yesterday and we figured this out.  Thank you very much for letting us know this is correct!

[Alex Hajigeorgieva]

Hello, Roland,

I am pleased to hear that you have found your way around the documentation, it is an ongoing effort to improve its structure and content and any feedback you may wish to share is most welcome.

In case, you have further questions, please feel free to get back to me.

Kind Regards,
Alex Hajigeorgieva
Progress Telerik

[samk]

Is itemTemplate available when multi check is false(Or for simple drop down)? 

[Alex Hajigeorgieva]

Hi,

The Kendo UI Grid supports custom filterable UI in the FilterMenu with the help of the columns.filterable.ui property:

API Reference: https://docs.telerik.com/kendo-ui/api/javascript/ui/grid/configuration/columns.filterable.ui 
Official demo: https://demos.telerik.com/kendo-ui/grid/filter-menu-customization

Kind Regards,
Alex Hajigeorgieva
Progress Telerik