Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Report including Incident created, status changed and previous status changed date columns — Cloud Customer Connect
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

Report including Incident created, status changed and previous status changed date columns

Received Response
35
Views
1
Comments
edited Jun 12, 2019 3:19PM in Reporting & Analytics for B2C Service 1 comment

Summary

Help required with Custom Script to enable date in status reporting requirement

Content

Hi,

1. I have built a report that uses the Incidents table to get the reference number and date created fields for every incident.

2. I have then joined the incidents table to the transactions table, added a filter to just look for transaction type of 'Created' and 'Status Changed' and added the field transactions.created to show the date/time when the transaction happened. This gives me multiple rows for each incident which is what I require (one for each status change).

3. I've then linked to the incident statuses table and added the inc_statuses.status_id field to show the name of the status change for the transaction.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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