Search Builder does not sent correct NOT queries to server side
Search Builder does not sent correct NOT queries to server side
sickman
Posts: 5Questions: 2Answers: 0
I use Search Builder with Editor to query on server side which works basically perfect with the exception of "Does Not start With" and "Does Not Contain", "Does Not End With" conditions. The queries send in all cases are e.g.:
SELECT COUNT( id ) as cnt FROM maintable WHERE (1=1) with bindings:[]
instead of using NOT oder NOT LIKE in WHERE clause ...
any ideas ?
This question has an accepted answers - jump to answer
Answers
What platform are you using on the server-side and what version please?
Thanks,
Allan
Dear Allan,
thank you for your response, I am using PHP Version 5.6.38, Apache 2.4.10, MySQL 5.5.6
Many thanks! I'm seeing that here as well. We'll get that fixed and post back soon.
Allan
Thank you for the help !
Hi @sickman ,
I've made a fix for this. This will be available in the next Editor release which we hope will be in the next few weeks. Until then you can access the fix from the GitHub Repo.
Thanks,
Sandy