Blank filter with SharePoint 2010 REST DataSource

[Steffen]

hi!

i'm displaying a SharePoint 2010 List in a Kendo Grid using the standard SharePoint 2010 REST Interface. The Grid instantly supports filtering, sorting etc. out of the box and works well with the SP REST Interface - awesome. The only problem is: how do I filter blank entries?

 

Thank you"

 

This is the Filter part of my Grid configuration:

 

01.filterable: {
02.            extra: false,
03.            messages: {
04.                info: "Datensätze filtern:",
05.                filter: "Filtern",
06.                clear: "Löschen",
07.                and: "und",
08.                or: "oder"
09.            },
10.            operators: {
11.                string: {
12.                    contains: "beinhaltet",
13.                    eq: "ist gleich",
14.                    neq: "ist nicht gleich",
15.                    blank: "ist leer"
16.                },
17.                date: {
18.                    eq: "ist gleich",
19.                    gt: "nach",
20.                    lt: "vor"
21.                },
22.            }
23.        }

This is the DataSource part of my Grid configuration:

01.dataSource: new kendo.data.DataSource({
02.            type: "odata",
03.            transport: {
04.                read: {
05.                    url: "http://myserver/demo_app/_vti_bin/listdata.svc/Daten$select=*,ErstelltVon/Name&$expand=ErstelltVon",
06.                    dataType: "json"
07.                }
08.            },
09.            sort: ({ field: "Erstellt", dir: "desc" }),
10.            pageSize: 5,
11.            resizable: true,
12.            serverSorting: true,
13.            serverFiltering: true,
14.            serverPaging: true,
15.            schema: {
16.                model: {
17.
18.                    fields: {
19.                        Vertragskonto: { type: "string" },
20.                        GPName: { type: "string" },
21.                        GPNummer: { type: "string" },
22.                        Erstellt: { type: "date" },
23.                        ErstelltVon: {
24.                            Name: {
25.                                type: "string"
26.                            }
27.                        },
28.                        WeitereVKs: { type: "string" },
29.                        DatumAktenabgabe: { type: "date" },
30.                        AktenabgabeAn: { type: "string" },
31.                        DatumAkteneingangFachbereich: { type: "date" },
32.                        Aktenrueckgabe: { type: "string" },
33.                        DatumAktenrueckgabe: { type: "date" },
34.                        DatumAkteneingang: { type: "date" },
35.                        Bemerkung: { type: "string" },
36.                        UemlbergabeVon: { type: "string" }
37.                    }
38.                }
39.            }
40.        }),

[Daniel]

Hello Steffen,

Filtering on blank entries is not currently supported by the grid. The feature was previously requested and you can vote for it and follow its progress on this page. A possible approach for now would be to use the dataSource filter method when a custom button is clicked. I created an example that demonstrates the scenario.

Regards,
Daniel
Telerik

 

 

[Steffen]

thanks Daniel, great workaround! that's service!