filterable with foreign key

[Christian]

Hi,

I am having problems getting the grid filter for a foreign key column working with autocomplete.

"columns": [
    {
        "title": "Datum",
        "field": "Datum",
     }, {
        "field": "ArtikelId",
        "values": stammdatenService.getData("Artikel"),
        "editor": stammdatenService.artikelEditor,
        "filterable": {
            "ui": function(element) {
                element.kendoAutoComplete({ datasource: stammdatenService.getData('Artikel') });
            }
        },

// 3. GRID FEATURES
"pageable": true,
"sortable": true,
"scrollable": true,
"filterable": {
    extra: false,
    operators: {
        string: {
            contains: "Beinhaltet",
             startswith: "Beginnt mit",
            doesnotcontain: "Beinhaltet nicht",
        },
        date: {
            eq: "Ist gleich",
            le: "Bis",
            ge: "Ab",
        },
    }
},

 

 The filter is ​only showing a standard dropdown with data from stammdatenService.getData("Artikel").

How can I get a foreign key column get working with autocomplete filter?

 

Thank you!

 

[Boyan Dimitrov]

Hello Christian,

 

I am afraid that the foreign key columns does not allow to customize the filter UI.  Only the default one (DropDownList widget) could be used with the foreign key columns. 

 

Regards,
Boyan Dimitrov
Telerik