CRM On Demand - Administration (MOSC)

MOSC Banner

JoinFieldValue in workflow

edited May 15, 2013 9:18AM in CRM On Demand - Administration (MOSC) 9 commentsAnswered ✓
 Hi,
I have a scenario where I have to stop user from saving a record from a certain sales stage and onwards if the Customer Account Type is of partner. I have written this expression but its not working for some reason, it triggers at every stage....trigger event is "Befor Modified record saved".

Can somebody validate if this expression is right,

([<IndexedPick0>] <> LookupValue("OCC_INDEX_CUST_LOV_OPTY_0", "ABC") OR [<IndexedPick0>] IS NULL) OR ([<IndexedPick0>] = LookupValue("OCC_INDEX_CUST_LOV_OPTY_0", "ABC") AND (PRE('<SalesStage>') <> 'Qualification' AND PRE('<SalesStage>') <> 'Development' AND PRE('<SalesStage>') <> 'Confirmed' AND PRE('<SalesStage>') AND 'Bid/Proposal Preparation' AND PRE('<SalesStage>') <> 'Decision Pending')) AND (JoinFieldValue('<Account>',[<IndexedShortText1>],'<AccountType>') = 'Partner')

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