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?