Skip to main content

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 21
We 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:


                                 

Stephen, thank you for creating a repro page, that’s great! We are looking into the issue.


Hi Stephen, wanted to update you that we reported the issue to our development team. During my investigation I found that three settings must be true to see the issue:

  1. The Table’s search is set to client-side.

  2. The Model’s Grouping Logic is NOT empty.

  3. At least one of the conditions is set to “Filterable default on”.


Thanks Luzie for the updates, good to hear it’s being worked on. That’s right about the settings we have a few tables like these that have grouping logic and filters on as there is a lot of data to filter down into a client-side search.


Reply