This is a migrated thread and some comments may be shown as answers.

Blank filter with SharePoint 2010 REST DataSource

2 Answers 30 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Steffen
Top achievements
Rank 1
Steffen asked on 04 Jun 2015, 01:06 PM

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.        }),

2 Answers, 1 is accepted

Sort by
0
Accepted
Daniel
Telerik team
answered on 08 Jun 2015, 11:10 AM
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
 
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
 
0
Steffen
Top achievements
Rank 1
answered on 09 Jun 2015, 11:44 AM

thanks Daniel, great workaround! that's service!

 

 

Tags
Grid
Asked by
Steffen
Top achievements
Rank 1
Answers by
Daniel
Telerik team
Steffen
Top achievements
Rank 1
Share this question
or