Results 1 to 3 of 3

Thread: Combination of Grid with filtered column(s) + paging toolbar + exporter

  1. #1
    Sencha Premium User
    Join Date
    Jun 2011
    Location
    Perth, Western Australia
    Posts
    182
    Answers
    10

    Default Answered: Combination of Grid with filtered column(s) + paging toolbar + exporter

    With a large dataset in a grid with a pagingtoolbar, the column filter obviously only filters those records visible in the current page ...
    by setting "remoteFilter: true" on the grid's store you get a remotely filtered set of data matching the filtered columns ...
    But ... an Export to XLS or PDF will only include those filtered records on the one visible page.

    Is there a standard method to get around this issue? What are others doing?

    e.g. have a "Show All" checkbox on the toolbar to override the page size that becomes enabled when someone applies a filter .. ?


    Thanks in advance

  2. I have found a solution.

    Here it is if anyone needs it:

    I have added a checkbox on the paging toolbar... with a label: "Show all records (Ignore paging)"
    on the change event I set a localStorage value:
    localStorage.setItem('limit', checkBoxValue == true ? 0 : 25);

    I check this localStorage item at the top of an override of the doRequest method in Ajax.js.
    And ... if the value is 0, I delete operation._limit; delete operation._page; delete operation._start

    On the show of each grid panel which has a paging toolbar, I reset the localStorage item value to 25 & always start with the checkbox unchecked.


  3. #2
    Sencha Premium User
    Join Date
    Jun 2011
    Location
    Perth, Western Australia
    Posts
    182
    Answers
    10

    Default

    I have found a solution.

    Here it is if anyone needs it:

    I have added a checkbox on the paging toolbar... with a label: "Show all records (Ignore paging)"
    on the change event I set a localStorage value:
    localStorage.setItem('limit', checkBoxValue == true ? 0 : 25);

    I check this localStorage item at the top of an override of the doRequest method in Ajax.js.
    And ... if the value is 0, I delete operation._limit; delete operation._page; delete operation._start

    On the show of each grid panel which has a paging toolbar, I reset the localStorage item value to 25 & always start with the checkbox unchecked.


  4. #3
    Sencha User
    Join Date
    Feb 2013
    Location
    California
    Posts
    11,985
    Answers
    506

    Default

    Great to hear that you got this working, and thanks for sharing the solution with the community!

Similar Threads

  1. GXT 3.1 Filtered Grid Column
    By whizkidz in forum Sencha GXT Q&A
    Replies: 0
    Last Post: 11 Jun 2014, 1:24 AM
  2. [CLOSED] Remotely filtered paging grid does not reset offset on filter activation
    By florian.trossbach in forum Sencha GXT Bugs
    Replies: 4
    Last Post: 4 Feb 2014, 1:26 AM
  3. Replies: 3
    Last Post: 3 Dec 2011, 10:09 AM
  4. Column Width Ignored in Grid *WITHOUT* Paging Toolbar (bbar)
    By froggman2k in forum Ext 2.x: Help & Discussion
    Replies: 0
    Last Post: 20 Jan 2009, 10:19 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •