CRM On Demand - Administration (MOSC)

MOSC Banner

workflows not triggering for Null condition

edited Oct 31, 2013 5:29AM in CRM On Demand - Administration (MOSC) 3 commentsAnswered
Gurus,
I have a picklist -[<plData_Corruption_Type_ITAG>]  - with 3 values. I need to trigger an email when the value of the picklist is changed from null to any of the 3 values.
I have tried the following in a workflow :
1). IfNull(PRE('<plData_Corruption_Type_ITAG>'),'Null') <> IfNull([<ltStatus_Comments_ITAG>],'Null') AND [<plOrg_ITAG>]=LookupValue("OCC_CUST_LOV_SR_19", "SCD") AND PRE('<plData_Corruption_Type_ITAG>') <> [<plData_Corruption_Type_ITAG>]

2) [<plOrg_ITAG>]=LookupValue("OCC_CUST_LOV_SR_19", "SCD") AND  IfNull([<plData_Corruption_Type_ITAG>],'Null') <> 'Null'  AND PRE('<plData_Corruption_Type_ITAG>') <> [<plData_Corruption_Type_ITAG>]

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