T
teppo_55
Guest
Hello. I made a mistake “serverFiltering” works well. I had in my example filter, which brings all records from database. When I have // serverPaging: true, // pageSize: 10, // serverSorting: true, serverFiltering: true, filter: { field: "yn_nimike", operator: "lt", value: "01" }, This reads 18 records from database, which is correct. I am very sorry for this. Regards - teppo ---------------------------|-------------------- Teppo Määttänen____| TR-Tiimi Oy Consultant_________| Struerintie 1 teppo @ trtiimi.fi____| 30100 FORSSA int-358-50-5748 226 | www.trtiimi.fi ---------------------------|-------------------- From: teppo@trtiimi.fi Sent: Monday, April 04, 2016 9:23 AM To: TU.Mobile@community.progress.com Subject: Re: [Technical Users - Mobile] A very simple question of serverFiltering. Hello. I tested this case using example : this.jsdoDataSource = new kendo.data.DataSource({ type: "jsdo", // TO_DO - Enter your filtering and sorting options // serverPaging: true, // pageSize: 10, // serverSorting: true, serverFiltering: true, filter: { field: "yn_nimike", operator: "gt", value: "0" }, //sort: [ { field: "Name", dir: "desc" } ], As you can see - I have only set serverFiltering and filter. From promon I can read that all records are brought from database: Record Reads 126297 This is not correct, because I have defined "serverFiltering: true". It should read from database only records that satsfy the filter criteria: "filter: { field: "yn_nimike", operator: "gt", value: "0" }". You should correct this as soon as possible. Regards - teppo ---------------------------|-------------------- Teppo Määttänen____| TR-Tiimi Oy Consultant_________| Struerintie 1 teppo @ trtiimi.fi____| 30100 FORSSA int-358-50-5748 226 | www.trtiimi.fi ---------------------------|-------------------- From: egarcia Sent: Friday, April 01, 2016 2:08 PM To: TU.Mobile@community.progress.com Subject: RE: [Technical Users - Mobile] A very simple question of serverFiltering. Update from Progress Community egarcia The options serverPaging and serverFiltering work pretty much as the cases that you mentioned. You can use serverPaging = true by itself and you can use serverFiltering = true by itself as well. However, if you apply a filter when working with serverPaging = true, a client side filtering would only apply to the data that is available locally, i.e., the page. This result might not be what a user would expect. In most cases, when working with serverPaging = true, you would also want to use serverFiltering = true and serverSorting = true. I hope this helps. View online You received this notification because you subscribed to the forum. To unsubscribe from only this thread, go here . Flag this post as spam/abuse.
Continue reading...
Continue reading...