[mysql 5.5] search request with bool not works

[napley]

The generate request to search on checkbox field with a bool value is different between mysql 5.7 and 5.5.

With Mysql 5.7 :

[▼
"evenements"
"%true%"
"online_event"
"published"
"start"
]

With Mysql 5.5 :

[▼
"evenements"
"["%true%"]"
"online_event"
"published"
"start"
]

Details

Question	Answer
Relevant Bolt Version	4.1.10
Install type	Composer install
BC Break	no
PHP version	7.4
Web server	Nginx
For UX/UI issues	Firefox 84

Reproduction

A setContent request with search on a checkbox :

{% setcontent events = 'evenements' where { online_event: '%false%' } limit 6 orderby '-start' %}

[napley]

I made this c81d328 but I think its not very clean

[I-Valchev]

Hi @napley ,

Can you try this:

{% setcontent events = 'evenements' where { online_event: false } limit 6 orderby '-start' %}

[napley]

Hi,

With {% setcontent events = 'evenements' where { online_event: true } limit 6 orderby '-start' %} it works

but with {% setcontent events = 'evenements' where { online_event: false } limit 6 orderby '-start' %} I have this error:

An exception has been thrown during the rendering of a template ("No matching value found for """).

[I-Valchev]

@napley right, I am also getting the same error. This is a bug indeed

[I-Valchev]

hi @napley , I found how this can be solved. To do so, you need to edit the QueryParameterParser.php by adding the following four lines right under line 91:

        $this->addValueMatcher("()", [
            'value' => '$1',
            'operator' => 'eq',
        ]);

I will be creating a PR to fix this, in the meantime you can manually override this for your local project.

[I-Valchev]

@napley can you please confirm what your bolt version is? I can only reproduce this on the master branch (which is for 4.2) but you mention above it breaks on 4.1.10?

[napley]

@I-Valchev It works with this fix for the version 4.1.10 👍

[I-Valchev]

Big thank you for confirming 👍