Search Builder does not sent correct NOT queries to server side

sickman

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 ?

allan

What platform are you using on the server-side and what version please?

Thanks,
Allan

sickman

Dear Allan,

thank you for your response, I am using PHP Version 5.6.38, Apache 2.4.10, MySQL 5.5.6

allan

Many thanks! I'm seeing that here as well. We'll get that fixed and post back soon.

Allan

sickman

Thank you for the help !

sandy

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