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

Replacing a text from a result of Case When

Received Response
44
Views
2
Comments
edited Dec 13, 2022 7:01AM in Taleo Enterprise 2 comments

Content

I am converting a formula from BO to OBI but unfortunately I am encountering an error. Below is the BO formula:

Replace(Replace(Replace(If(Match([Event];"Status changed to*") And ([Application Tracking CSW Status])<>"Rejected") Or Match([Event];"Revert*") Then ("Event date: "+[Application Tracking Event or Transaction Date]) ElseIf([Event]="Correspondence sent") Then [Application Tracking Correspondence Template Used (7.5 Legacy Data)] ElseIf(Match([Event];"Service*")) Then Replace(Replace([Application Tracking Details];"{service}";[Application Tracking Passport Services Name]);"{provider}"; [Application Tracking Passport Services Provider]) ElseIf([Application Current CSW Step]<>"New" And [Application Current CSW Status]="Rejected") Or IsNull([Application Tracking Details]) Then [Application Tracking Motives] Else [Application Tracking Details];"Question: ";("Question: "+[Application Tracking Q&A Question (Before Update)]));"{1}";"_");"{SEPARATOR}";"

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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