You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Trouble with LIKE operator in filter expression.

Accepted answer
61
Views
4
Comments
edited Oct 2, 2015 3:06PM in Reporting & Analytics for B2C Service 4 comments

Content

I'm experiencing something which I can only describe as odd.. I'm attempting to use a variable in conjunction with a LIKE operator in a report filter.

 

Expression: upper(CO$Result.Text)
Operator: like
Value Type: Expression
Value: upper(concat('%', $keyword, '%'))

 

This did not work. I tried setting the Value manually to '%TEST%', and yet still no results were returned. If I set the Value Type from Expression to Constant, then enter %TEST%, it works -- results are returned. However, I cannot devise any use case scenario in where it works with a LIKE operator and the the Value Type is set to Expression. Am I missing something here? Running Oracle Service Cloud August 2014 SP6..

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!