Show more than 10 rows in autocomplete database join

[adriannunez]

Hi guys
I have a databse join element rendered as auto-complete. The database column contains many rows starting with the same words and the auto-complete element renders only the 10 first items. How can I increase that limit?

 

[cheesegrits]

At the moment, that's hard coded to 10 in the javascript. I'd need to add a new global option, and/or an option in the join element settings, and the associated code to set that in the javascript.

If you'd like to take out a paid sub for a month, I'd be happy to add that.

-- hugh

 

[adriannunez]

Thanks, Hugh
I found that value at databsejoin.php line 2898, changed the value and worked, but it will be overwritten at next update. It would be great if it were an option in the element settings, so I'll pay a month.
Adrian

 

[adriannunez]

Done!

 

[cheesegrits]

Thanks! I'll get round to adding that feature this week. If you haven't heard back from me by Friday evening, bump this thread.

-- hugh

 

[adriannunez]

Friendly bump.

 

[cheesegrits]

OK, as of this commit there is both a global and a join element option for autocomplete rows.

https://github.com/Fabrik/fabrik/commit/6a29377c6a259a462dfd0bf7c65bcc8f26c94645

The global is now used as the default for all autocompletes, and the join element settings override it.

-- hugh

 

[adriannunez]

Thanks Hugh! It works perfectly.