Skip to main content
D
dwilliams1-Visitor
1-Visitor
March 2, 2012
Question

Escaping Wildcard Characters in Query Builder

  • March 2, 2012
  • 3 replies
  • 1158 views
Can anyone tell me how to escape wildcard characters in query builder?
I'm trying to build a query against any CAD with an underscore in the
name.



Thank you for your advice,

Dax Williams
Engineering E-Tools Administrator
GE Healthcare OEC

Surgery

3 replies

J
jzupfer1-Visitor
1-Visitor
March 7, 2012

Dax,


I was not able to find an answer to your question in our documentation, so we followed up with the primary developer for QueryBuilder, who provided the following information:


D
dwilliams1-VisitorAuthor
1-Visitor
March 7, 2012
Hi Jane,

I appreciate you looking into this with the developer. I've tried
using the escape characters you've mentioned but they don't appear to be
working in query builder. In the example screenshot, I'm trying to find
all EPMDocuments that have "_OLD" in the name. This query returns 0
results when I use the \ or [] characters. If I don't use the escape
characters, the query treats the underscore as a wildcard.







I can run the following SQL query outside of query builder and get the
data but i would like this report to be available for non-admins.



select NAME from epmdocumentmaster where UPPER(name) like '%\_OLD%'
escape '\';



Thank you for your time,

Dax


J
jzupfer1-Visitor
1-Visitor
March 8, 2012

Hi, Dax,



I spoke with the developer again, and, prior to his first response, he had tested the escape capability on SQLServer, where it worked as expected. This time, however, he tried it on Oracle, and he had the same experience as you. So, we’ve uncovered a bug, and I created an SPR with a 10.0 MOR targeted for the Oracle-specific fix.


Thanks for your patience, and for your help in identifying the problem.


Regards,


Jane

Terms & ConditionsAccessibility statement