CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Pass parameters via weblink to retreive both upper case & lower case records in a report

edited Aug 18, 2014 10:07AM in CRM On Demand - Reports and Dashboards (MOSC) 4 commentsAnswered ✓

Hi Gurus,
I have a web link pointing to a report and have the following parameters:

"&Options=rfd&Action=Navigate&p0=1&p1=like&p2="- Custom Object 1 Custom Attributes".TEXT_41&p3=1+%25%%%stFailed_Serial_Number%%%"

The field stFailed_Serial_Number contains both upper & lower alpha numeric characters. for example the characters can be either ABC123456789 or abc123456789.
if i give &p3=1+%25%%%stFailed_Serial_Number%%% or &p3=%%stFailed_Serial_Number%%%.. it would just give me just one record based on the case it was entered.

How do i display records in both upper & lower cases if the parameter passed is in upper case or lower case.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center