Search Fields Bug - conflict with Name I am trying to set the Search Fields for a Reference field based on a Model and am getting some very buggy behavior. I have Skuid 7.36.1 installed but had the same problem with 7.31.
The problem arises when I try to search on fields that are references themselves. So In the case below if I have an Account field and want to search on the name of the Account and the name of the Account Owner (eg Owner.Name) it causes a problem.
If I open the search Popup and search for a value and then look at the model in the console it shows the SOQL such as:
SELECT Name,OwnerId,Owner.Name,Id FROM Account WHERE (((Name LIKE ‘%test%’))) LIMIT 21
when it should be more like:
SELECT Name,OwnerId,Owner.Name,Id FROM Account WHERE (((Owner.Name LIKE ‘%test%’) or (Name LIKE ‘%test%’)))
If I just set the Search Fields to Owner it uses SOQL like:
SELECT Name,OwnerId,Owner.Name,Id FROM Account WHERE (((Owner.Name LIKE ‘%test%’)))
But if I have both Account Name and Owner as Search Fields it only searches the Acc