Dynamic search and sc_select_where macro don't work together

Doing dynamic search and using macro sc_select_where(add) at the same time is not possible. An error comes up when search is applied. Look at the attached image.

It seems that the ‘where clause’ is not well formed in the query.

Tested in Google Chrome.


I solved this by adding a where clause in the SQL Statement like this: where 1=1, this way in the sc_select_where(add) macro I just add “AND conditions”