AnsweredAssumed Answered

How to run a query with 2 wild cards on a string without treating it as a variable?

Question asked by Brett_Zipkin on Feb 2, 2017
Latest reply on Feb 3, 2017 by Brett_Zipkin

I'm building a report data object that runs a SQL query against the database.  Part of that query requires my WHERE clause to have something akin to    field_name like '%datavalue%'  which normally is acceptable SQL syntax.  However, when dropped into the Query box of the Data Object, I get an error like this...

 

Error: The variable 'datavalue' has not been defined, the query may not execute properly.....

 

Catalog uses  the percent-name-percent format to identify a variable but I really want to use it as pure sql.   How do I get around this issue so I can run the query I intend to?

Outcomes