We have just upgraded to latest Spark 12.1.7 from 12.0.4 and found that our client-side table searches (in v2 pages) returns no results no matter what you type in the search box. This used to work fine in the older version we had. Have managed to reproduce the issue in the page below, seems to be a bug when you have model conditions with condition grouping logic combined with a client-side table search on the model. If you look at the underlying model’s SOQL the client side search is incorrectly (and unnecessarily?) altering the SOQL making it invalid (if you remove the model’s condition grouping logic it works):
SELECT RecordTypeId,Name,Id FROM Account WHERE (CreatedDate != null)AND(2) ORDER BY Id LIMIT 21We make use of the client-side searches in a few places so we've lost functionality with this upgrade.
FYI, we have a similar issue in an older v1 page but haven’t been able to replicate it and switched it to server-side search which was an acceptable work-around. Haven’t been able to isolate the cause but would prefer to have this v2 bug fixed please.
Thanks,
Stephen
Page XML: