Is it possible to change the autocomplete return count?

(4 posts) (3 voices)
  • Started 6 years ago by SteveD
  • Latest reply from myDBR Team


No tags yet.

  1. SteveD, Member

    Is there any method to change the number of autocomplete values listed when using an autocomplete parameter?

    As an example I have a report that list metal alloys, and if I type FE in the autocomplete box for the report I have a choice of 20 results. however if I run the autocomplete query directly using the following SQL Statement:
    SELECT Code FROM Example.dbo.tblStockFamily WHERE Code Like 'fe%' ORDER BY Code
    This would return in excess of 200 rows.

    Now obviously I may not want the full 200+ rows to return, but is there an option to increase the default of 20?

    Posted 6 years ago #
  2. myDBR Team, Key Master

    For now the maximum number of rows displayed is fixed. We can see if that could be configurable. User can always type more characters to narrow the query down.

    myDBR Team

    Posted 6 years ago #
  3. cris, Member

    I just ran into this limitation as well, with a short product name that won't display because there are too many other matches in the list. Was a configurable option added?


    Posted 11 months ago #
  4. myDBR Team, Key Master

    You can adjust the maximum number of rows shown (20 being default) in /user/defaults.php:

     $mydbr_defaults['autocomplete_max_rows'] = 40;

    myDBR Team

    Posted 11 months ago #


You must log in to post.