1. #1
    Sencha - Support Team scottmartin's Avatar
    Join Date
    Jul 2010
    Location
    Houston, Tx
    Posts
    8,912
    Vote Rating
    443
    scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future

      0  

    Default Buffered live search grid for ExtJS3.x

    Buffered live search grid for ExtJS3.x


    Is there a buffered live search grid available for ExtJS3
    same as what is available in ExtJS4
    http://dev.sencha.com/deploy/ext-4.0.2a/examples/grid/live-search-grid.html

    I
    need to load all records into a buffered view and allow users to search (not filter).

    I see there is LiveGrid:
    http://www.ext-livegrid.com/

    I do no see any mention of a search.

    Regards,
    Scott.

  2. #2
    Sencha User Mycoding's Avatar
    Join Date
    May 2010
    Location
    Russia, Volgograd
    Posts
    460
    Vote Rating
    0
    Mycoding is on a distinguished road

      0  

    Default


    I am not sure is it possible but still.
    Try to change pagesize from 25 to what you need.
    About buffering I think it is only in sample you show.

    Actually in ExtJS 3.x it is not possible to do infinit grid, but it is possible in ExtJS 4.x
    http://www.sencha.com/blog/infinite-...g-in-ext-js-4/

  3. #3
    Ext JS Premium Member
    Join Date
    Jul 2009
    Posts
    239
    Vote Rating
    2
    stephen.friedrich will become famous soon enough

      0  

    Default


    We are using Thorsten Suckow's LiveGrid extension with ExtJS 3:
    http://www.ext-livegrid.com/
    I think it is even better than ExtJS 4's version.
    ExtJS 4 plugins:
    varheaders - short/normal/long column header
    clearbutton - mouseover clear button in text field
    Blog: fit4dev
    ExtJS User Group Hamburg

  4. #4
    Sencha - Support Team scottmartin's Avatar
    Join Date
    Jul 2010
    Location
    Houston, Tx
    Posts
    8,912
    Vote Rating
    443
    scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future

      0  

    Default


    @ stephen

    How do you handle searches? I understand that the data is buffered, so I am not sure how this would be handled.

    Here is the situation with our customer:

    They want to be able to scroll through all of the employees in a single grid
    (we currently paginate)

    They would like to be able to select a letter and have to grid advance to that letter, like a rolodex, instead of having to scroll down to that location manually.

    Regards,
    Scott.

  5. #5
    Ext JS Premium Member
    Join Date
    Jul 2009
    Posts
    239
    Vote Rating
    2
    stephen.friedrich will become famous soon enough

      0  

    Default


    That's tricky, but we implemented a similar feature (for clickable links in between rows).
    You need to do the core of this on the server:
    When the user selects "D" then do an ajax request and ask the server what the index of the first "D" row is.
    The server does a database query with current sort order to get that index.
    Then back on the client ask the grid to scroll to that index (which will automatically trigger the necessary load requests).

    As an optimization you could first check if the "D" row is already in the local part of the store and avoid the ajax request and db query.
    ExtJS 4 plugins:
    varheaders - short/normal/long column header
    clearbutton - mouseover clear button in text field
    Blog: fit4dev
    ExtJS User Group Hamburg

  6. #6
    Sencha - Support Team scottmartin's Avatar
    Join Date
    Jul 2010
    Location
    Houston, Tx
    Posts
    8,912
    Vote Rating
    443
    scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future

      0  

    Default


    So I should get the 'index' using something like:

    Code:
    SET @R = 0;
    SELECT @R := @R+1 AS rank, last_name, first_name 
    FROM bms_employees 
    ORDER BY last_name
    And then return the rank to live-grid to auto-scroll down to the correct location?

    Regards,
    Scott.

  7. #7
    Ext JS Premium Member
    Join Date
    Jul 2009
    Posts
    239
    Vote Rating
    2
    stephen.friedrich will become famous soon enough

      0  

    Default


    I am using Oracle DB's convoluted rownum constrict with nested selects.
    No idea if your suggestion will work on your DB (MySQL?)

    What I would for your case try is:
    select count(*) from bms_employees where lower(last_name) < 'd';
    ExtJS 4 plugins:
    varheaders - short/normal/long column header
    clearbutton - mouseover clear button in text field
    Blog: fit4dev
    ExtJS User Group Hamburg

  8. #8
    Sencha - Support Team scottmartin's Avatar
    Join Date
    Jul 2010
    Location
    Houston, Tx
    Posts
    8,912
    Vote Rating
    443
    scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future

      0  

    Default


    Yes, Mysql.

    Your solution is a bit cleaner .. thanks.

    Regards,
    Scott.

  9. #9
    Sencha - Support Team scottmartin's Avatar
    Join Date
    Jul 2010
    Location
    Houston, Tx
    Posts
    8,912
    Vote Rating
    443
    scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future scottmartin has a brilliant future

      0  

    Default


    @ stephen
    Do you happen to know how to scroll down/up to the desired row?
    I use selectRow(row) to select, but how does one scroll to that record to bring it into view?

    I tried focusCell (row,0) with no luck.
    Is there a method or would I set rowIndex and update display?

    Jumping around the code, as I am unable to find any docs.

    Regards,
    Scott.

  10. #10
    Ext JS Premium Member
    Join Date
    Jul 2009
    Posts
    239
    Vote Rating
    2
    stephen.friedrich will become famous soon enough

      0  

    Default


    Ah, good point - I had to look in the code to see that we have been using GridViews undocumented method "ensureVisible":
    ensureVisible : function(row, col, hscroll){...

    You may need to defer the call like this:
    this.view.ensureVisible.defer(1, this.view, [index, 0, false]);
    ExtJS 4 plugins:
    varheaders - short/normal/long column header
    clearbutton - mouseover clear button in text field
    Blog: fit4dev
    ExtJS User Group Hamburg

Thread Participants: 2

Turkiyenin en sevilen filmlerinin yer aldigi xnxx internet sitemiz olan ve porn sex tarzi bir site olan mobil porno izle sitemiz gercekten dillere destan bir durumda herkesin sevdigi bir site olarak tarihe gececege benziyor. Sitenin en belirgin ozelliklerinden birisi de Turkiyede gercekten kaliteli ve muntazam, duzenli porno izle siteleri olmamasidir. Bu yuzden iste. Ayrica en net goruntu kalitesine sahip adresinde yayinlanmaktadir. Mesela diğer sitelerimizden bahsedecek olursak, en iyi hd porno video arşivine sahip bir siteyiz. "The Best anal porn videos and slut anus, big asses movies set..." hd porno faketaxi