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

Value of field substr of text in thread - if, then, else statement

edited Nov 1, 2018 4:59PM in Reporting & Analytics for B2C Service 4 comments

Summary

Issues with definition of a column of data with some conditions in it.

Content

I have a report that was pulling data out of the thread to define a column.  That info is now in a custom field.  To make sure future reporting accounts for both things so I don't have to put two columns on the report for the same data i changed the definition. This is all working using the definition below. If the new custom field is not empty, use that, if it's empty, use the thread text.

if(incidents.c$employee_id IS NOT NULL , incidents.c$employee_id, substr(to_char(threads.note),20+instr(to_char(threads.note),'Call/Cardmember ID:'),(instr(to_char(threads.note),'Booking Number:'))-(20+instr(to_char(threads.note),'Call/Cardmember ID:'))))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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