CORRECTION /// Re: [Technical Users - Mobile] A very simple

Posted by teppo_55 on 04-Apr-2016 02:12

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
---------------------------|--------------------
 
Sent: Monday, April 04, 2016 9:23 AM
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
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.

All Replies

Posted by egarcia on 04-Apr-2016 16:35

Hello Teppo,

Thank you for confirming that the answer presented on the other thread solved the issue.

I am including the link here as a way to reference to it:

   community.progress.com/.../24019

Best regards,

Edsel

This thread is closed