Search strings matching _ and % in LIKE conditions

Fix versions

Priority

Description

A customer found that we didn't escape _. It is causing issues with their property matching.

When using "~":

  • % should be a wildcard,

  • _ should not be a wildcard.

When using ==:

  • Neither % or _ should be wildcard, both should be escaped in our LIKE condition.

Activity

Show:
Resolved

Details

Assignee

Reporter

Requirement Yogi

Created February 17, 2020 at 9:27 AM
Updated December 21, 2021 at 11:37 AM
Resolved February 17, 2020 at 10:36 AM