Bug DatabaseJoin AutoComplete

[bonghetti]

I have found that using a databasejoin field, where I use the data-where function (where {thistable}.community = '{a_iscrive_meet___table_raw}' order by {thistable}.name asc does not work correctly in AutoComplete mode. If I remove the function, search for names correctly, if I insert it I always get the COM_FABRIK_NO_AUTOCOMPLETE_RECORDS message. in drop-down list mode it always works correctly

 

[troester]

Did you set "or concat label"?
There's an issue which may be related
https://fabrikar.com/forums/index.p...cords-on-list-based-on-required-filter.54192/

 

[bonghetti]

yes, the problem is similar to the one reported by Dimoss in the other post, but with Fabrik 4 his alternative solution also doesn't work. By eliminating the need for concat through a mysql view, the autocomplete if a Data-Where is present still does not work correctly (does not find any records), while it works if the drop-down list is activated

 

[bonghetti]

I wanted to know if the indicated problem will be classified among the bugs with a possible solution. Thank you in advance

 

[bonghetti]

In the various tests carried out it seems certain that there is a connection with the data-where so when a condition is inserted the auto-complete no longer works correctly