CORRECTION /// Re: [Technical Users - Mobile] A very simple question of serverFiltering. - Forum - Mobile - Progress Community

CORRECTION /// Re: [Technical Users - Mobile] A very simple question of serverFiltering.

 Forum

CORRECTION /// Re: [Technical Users - Mobile] A very simple question of serverFiltering.

  • 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.

  • 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