CRM On Demand - Administration (MOSC)

MOSC Banner

CASE filter

I'm trying to put a CASE filter on a field to return and either/or response..

My goal: When the "opened time" is checked to see if a call was responded to with in a 24 -48 hour period vs anything beyond 48 hours the desired results are not being returned..

I believe I'm getting hung up on what verbiage to use (contains?) in the case statement.  I need to verify and assign this to the proper person.

Here's what I have currently: CASE SLA."RespTime, WHEN RespTime ,= 1 AND RespTime <= 2 THEN 'Yes' ELSE 'No'

Any suggestions would be appreciated.

 

Thanks

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