Question

114
Views
Close popover
Jav Shamsuddin (JavS9029)
StepChange Debt Charity

StepChange Debt Charity
GB
JavS9029 Member since 2017 4 posts
StepChange Debt Charity
Posted: February 21, 2020
Last activity: February 21, 2020
Closed

Query runner - how to escape characters

we are using a postgres back end on 7.3 , I have a sample query used in query runner  which I can't get to work - 

select pxTimeCreated, pyMessageKey from pegadata.hst_sometable_work and pyMessageKey LIKE '[ABC%'

the error i get is: ** Unclosed character class near index 6 '[FCC%' ^

I have tried using the character wild card i.e.

and pyMessageKey LIKE '_ABC%'

- but this returns no results.

The following works but  can't use this due to performance reasons  

and pyMessageKey LIKE '%ABC%' 

 

so how do I escape the character '[' in a sql query execute in the query runner ??

(This is part of a query to assist in trouble shooting - so want to run the query via query runner - not a report of any kind ) 

 

 

 

Pega Platform 7.3.1 Enterprise Application Development Dev/Designer Studio Financial Services System Architect
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.