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?
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
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?

   Thanks,
   Cris
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

Reply

You must log in to post.