Problem query result with "search query plugin 1.4.0"

[GBob1789]

Hello
I do a new issue because this one : Octopoos/SEBLOD#322 is closed

the problem is still there with the 1.51.

but I must add some explanations: the problem only appears when one of the fields is empty. If there is a value in each field it works well.
In version 1.30 the final query was ... like '%%' and like '%%' ... if my field was empty, which returned all the result. Since version 1.40 the final request is: ... and () ... and (). This generates an SQL error.

forum : https://www.seblod.com/community/forums/fields-plug-ins/problem-query-result-with-search-query-plugin-1-4-0

Best regards
G.Bob

[klas]

Confirmed - matching is not fixed with 1.5.1:

From this
WHERE [MATCH]menutype||$uri->get('component_type_select_multiple')[/MATCH]
I get WHERE (((menutype LIKE '%17%'))) when value is selected - also notice 3 (((

When there is no value selected I get en error as it is WHERE ().

Also matching seems to be taken from sql search field, not from field beeing searched on (not sure whether this iabug or feature..)