Multi-filter shows nothing except "Select All" after update to Q2

[Aaron]

My application has a ton of grids with a ton of columns so we've got a bunch of slick code to essentially generate most of the grid settings based upon schema objects. Yesterday I began working on the Excel-like multi-filtering. I was working with the Q1 and got it working nicely except for 2 things. Filtering "null" wasn't working at all, and filtering dates wasn't working. Today I sat down to fix those 2 problems and realized I had just barely missed the Q2 release. Wondering if these issues were fixed I find I can't even get far enough to find out.

column.filterable = column.filterable || {};
column.filterable.multi = true;
column.filterable.dataSource = {
    type: "aspnetmvc-ajax",
    transport: {
        read: {
            url: excelFilterUrlBase + "/" + field.charAt(0).toUpperCase() + field.slice(1), // Evaluates to something like 'api/Employees/LastName'
            data: primaryDataSource.transport.read.data,
            type: "GET",
            dataType: "json"
        }
    },
    schema: {
        data: "data",
        total: "total",
        model: (function (fieldName, field) {
            var modelObject = {
                id: fieldName,
                fields: {}
            };
            modelObject.fields[fieldName] = {
                type: field.type
            }
            return modelObject;
        })(field, fields[field]) // Evaluates to a proper model object having the correct 'type'
    },
    filter: primaryDataSource.filter
}

 

When I run this code and then click on the column menu dropdown, I see in the network traffic that it properly calls my service method, and gets back the appropriate JSON response object:

{
data: [
{
lastName: "Aaron"
},
{
lastName: "Abbas"
},
{
lastName: "Abbott"
},
{
lastName: "Adams"
},
{
lastName: "Adhikari"
},
{
lastName: "Agarwal"
},
{
lastName: "Aggarwal"
},
{
lastName: "Aguilar Schall"
},
//...
],
total: 908,
aggregateResults: null,
errors: null
}

 

However, In my grid, I only see the "Select All" checkbox. There aren't any other options.

 

This was working in Q1. What changed?

[Aaron]

To narrow this down there's a couple other things I've tried.

I've tried removing the "schema" object and changing my services layer to return a simple array of strings, as well as trying a simple array of objects with the fieldname as the key. No luck.

Also worth noting that I'm also using the filter row.

 Additionally, there are no errors being thrown in the console.

 

And since probably the first thing anybody is going to think is that something's up with my closures, this is what I see when I use angular to inspect the variables at runtime:

 

filterable: {
    cell: {
        operator: "contains",
        showOperators: true,
        suggestionOperator: "contains"
    },
    dataSource: {
        filter: [],
        schema: {
            data: "data",
            model: {
                fields: {
                    lastName: {
                        type: "string"
                    },
                    id: "lastName"
                }
            },
            total: "total"
        },
        transport: {
            read: {
                dataType: "json",
                type: "GET",
                url: "/api/Employee/Field/LastName"
            }
        },
        type: "aspnetmvc-ajax"
    },
    multi: true
}

[Aaron]

So I'm passing the filter object that the entire datasource is instantiated from in order to only show values that actually exist. My server-side code applies that filter to the data set before using reflection to pull the appropriate distinct property values.

What's missing that makes this whole thing not work?

serverFiltering: true

[Georgi Krustev]

Hello Aaron,

I prepared a simple Dojo demo in my attempt to replicate the issue locally, but to no avail. Probably I am missing something. Would it be possible to modify it and show us the erroneous behavior?

• http://dojo.telerik.com/eneYO

As a side note, the MultiCheck widget will not be visible when filter row is enabled.

Regards,
Georgi Krustev
Telerik

 

 

[Aaron]

Adding

serverFiltering: true

 fixed the issue. I was unable to replicate the issue in the demo. Probably because I'm using the asp.net wrappers and returning a DataSourceResult containing the options.