Search Builder does not sent correct NOT queries to server side

Search Builder does not sent correct NOT queries to server side

sickmansickman 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

  • allanallan Posts: 61,972Questions: 1Answers: 10,160 Site admin

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

    Thanks,
    Allan

  • sickmansickman Posts: 5Questions: 2Answers: 0

    Dear Allan,

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

  • allanallan Posts: 61,972Questions: 1Answers: 10,160 Site admin
    Answer ✓

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

    Allan

  • sickmansickman Posts: 5Questions: 2Answers: 0

    Thank you for the help !

  • sandysandy Posts: 913Questions: 0Answers: 236

    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

Sign In or Register to comment.