Feature request #7814

QgsExpression: LIKE operator should respect escaped _ and %

Added by Matthias Kuhn over 7 years ago. Updated about 2 years ago.

Status:Closed
Priority:Normal
Assignee:-
Category:Unknown
Pull Request or Patch supplied:No Resolution:fixed/implemented
Easy fix?:No Copied to github as #:16702

Description

QgsExpression LIKE / ILIKE / NOT LIKE / NOT ILIKE operators do currently not allow to escape _ and % operators.

Default escape string should be a backslash \\ or customizable with an ESCAPE statement appended to the LIKE (et al) operator specifying an escape character.

E.g.

LIKE "45!%" ESCAPE "!"
should match
"45%" but not "45% or more"

History

#1 Updated by Jürgen Fischer over 6 years ago

  • Tracker changed from Bug report to Feature request

#2 Updated by Giovanni Manghi over 3 years ago

  • Easy fix? set to No

#3 Updated by Jürgen Fischer about 3 years ago

  • Category set to Unknown

#4 Updated by Nyall Dawson about 2 years ago

  • Resolution set to fixed/implemented
  • Status changed from Open to Closed
  • Description updated (diff)

Fixed since ..?

Also available in: Atom PDF