Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Expresssion guidance - Syntax for OR

edited Mar 20, 2017 10:00PM in Reporting & Analytics for B2C Service 2 comments

Content

Hello,

I'm looking for some help or guidance on where I can find the syntax for writing more complex expressions for column definitions, making custom reports.   Unfortunately, I'm not use to the language or the syntax that Oracle Service Cloud uses and looking for any resource that can help. 

I'm attempting to write an expression with an OR clause and I can't seem to figure out what the correct syntax is for or.  (Incidentally I found & for AND on this community but nothing for OR).


Below is an example

 

if(date_trunc(chats.requested, days) < date_trunc(incidents.created, days) OR  if (date_trunc(chats.requested, days) IS NULL)  then date_trunc(incidents.created, days), else date_trunc(chats.requested, days)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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