I have set "Auto-complete how" to "Starts with" which worked great until I made the group repeatable which then caused it to work in the "Contains" way.
I tracked the problem down to this line (around 209) in databasejoin.php:
I fixed the problem by replacing it with this which was a slightly modified version of the code at around line 2526:
Now the Auto-complete works as expected in the repeatable group.
I hope this fix can make it into Fabrik.
I tracked the problem down to this line (around 209) in databasejoin.php:
Code:
$this->_autocomplete_where = $label . ' LIKE ' . $db->quote('%' . JRequest::getVar('value') . '%');
Code:
// $$$ hugh (and Joe) - added 'autocomplete_how', currently just "starts_with" or "contains"
// default to "contains" for backward compat.
$params = $this->getParams();
if ($params->get('dbjoin_autocomplete_how', 'contains') == 'contains')
{
$this->_autocomplete_where = $label . ' LIKE ' . $db->quote('%' . JRequest::getVar('value') . '%');
}
else
{
$this->_autocomplete_where = $label . ' LIKE ' . $db->quote(JRequest::getVar('value') . '%');
}
I hope this fix can make it into Fabrik.