#3132 (ok 3.5.0) Page through rows returned from a view

3.4.9
fixed
1
2013-06-11
2010-10-22
Ollie Pike
No

When you browse the rows of a table, you are able to page through the results with the arrow buttons. However when viewing the rows returned from a view, that capability is missing. You can only look at the first x (default is 30 I think?) number of rows.

Discussion

  • Jonathan Sachs

    Jonathan Sachs - 2011-05-29

    I came here to report the same thing, but I consider it a bug. I can think of s no reason why browse should not treat views the same as tables.

     
  • Marc Delisle

    Marc Delisle - 2012-01-02

    To be able to page, we need to know the row count. From Documentation.html:
    $cfg['MaxExactCountViews'] integer
    For VIEWs, since obtaining the exact count could have an impact on performance, this value is the maximum to be displayed, using a SELECT COUNT ... LIMIT. The default value of 0 bypasses any row counting.
    ---------
    It's difficult to set a correct default value for this parameter, so it's set at 0. Maybe we could set it to 20000 like we do for $cfg['MaxExactCount'].

     
  • Marc Delisle

    Marc Delisle - 2012-01-02
    • assigned_to: nobody --> lem9
     
  • Marc Delisle

    Marc Delisle - 2012-01-05

    Moved to bugs; fixed in version 3.5.0 by setting a default value of 100000 in $cfg['MaxExactCountViews'].

     
  • Marc Delisle

    Marc Delisle - 2012-01-05
    • labels: 509121 --> Displaying results
     
  • Marc Delisle

    Marc Delisle - 2012-01-05
    • milestone: --> 3.4.9
    • priority: 5 --> 1
    • summary: Page through rows returned from a view --> (ok 3.5.0) Page through rows returned from a view
    • status: open --> open-fixed
     
  • Marc Delisle

    Marc Delisle - 2012-04-07
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed