Bug in Widget condition filter for price range - Error filtering template: Unknown condition operator

[magefast]

Exist error/bug in conditions filter. Not working conditions for price (or other numeric type) - less than, more than, etc.

As I understand - problem is - when saved type of filter like - '>=', '>', '<=', '<' - converted to HTML entities. (https://dev.w3.org/html5/html-author/charref)

Preconditions

1. Magento version - 2.2.2
2. PHP Version 7.0.22-0ubuntu0.16.04.1 , default_charset - UTF-8

Steps to reproduce

1. Create widget for Homepage, product list, conditions - product price from 1$
2. Check Homepage, you will see - Error filtering template: Unknown condition operator

Expected result

1. Will show list of products with filter in conditions.

How to fix

in file app/code/Magento/Rule/Model/Condition/Sql/Builder.php need update array - protected $_conditionOperatorMap

add followings:

        '>=' => ':field >= ?',
        '>'  => ':field > ?',
        '&lt;=' => ':field <= ?',
        '&lt;'  => ':field < ?',

and final protected $_conditionOperatorMap like -

protected $_conditionOperatorMap = [
        '=='    => ':field = ?',
        '!='    => ':field <> ?',
        '>='    => ':field >= ?',
        '>'     => ':field > ?',
        '<='    => ':field <= ?',
        '<'     => ':field < ?',
        '{}'    => ':field IN (?)',
        '!{}'   => ':field NOT IN (?)',
        '()'    => ':field IN (?)',
        '!()'   => ':field NOT IN (?)',
        '&gt;=' => ':field >= ?',
        '&gt;'  => ':field > ?',
        '&lt;=' => ':field <= ?',
        '&lt;'  => ':field < ?',
    ];

Resume

Maybe this settings of PHP, but installed standard PHP version without extra settings.

Thanks

[magento-engcom-team]

@magefast, thank you for your report. We've acknowledged the issue and added to our backlog.

[sydekumf]

Hey there, the same problem also occurs for Magento 2.1, the serialized value looks like this: s:1:">"; which of course can not be deserialized. Any idea when this will be fixed? :wink:

[axovel]

Any updates on this ? I am also getting the same issue

[Mobecls]

In this situation, I just changed the '& gt;' on '>' in the widget code.

[magento-engcom-team]

Hi @vasilii-b. Thank you for working on this issue. Looks like this issue is already verified and confirmed. But if your want to validate it one more time, please, go though the following instruction:

• [x] 1. Add/Edit Component: XXXXX label(s) to the ticket, indicating the components it may be related to.

• [x] 2. Verify that the issue is reproducible on 2.3-develop branch

  Details

  - Add the comment @magento-engcom-team give me 2.3-develop instance to deploy test instance on Magento infrastructure.
  - If the issue is reproducible on 2.3-develop branch, please, add the label Reproduced on 2.3.x.
  - If the issue is not reproducible, add your comment that issue is not reproducible and close the issue and stop verification process here!

• [ ] 3. Verify that the issue is reproducible on 2.2-develop branch.

  Details

  - Add the comment @magento-engcom-team give me 2.2-develop instance to deploy test instance on Magento infrastructure.
  - If the issue is reproducible on 2.2-develop branch, please add the label Reproduced on 2.2.x

• [ ] 4. If the issue is not relevant or is not reproducible any more, feel free to close it.

[vasilii-b]

Hi @magefast , Unfortunately I wasn't able to reproduce the issue on the 2.3-develop branch. Can you please re-check if issue still exists and reopen it if so ? Thank you!