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
Move row data into 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

Move row data into columns

Accepted answer
26
Views
5
Comments
edited Jul 4, 2018 2:06PM in Reporting & Analytics for B2C Service 5 comments

Content

Hi,

I am trying to use the Incident Audit Log as the basis for an incident status progress report and would like to only have one row in the report per incident ref showing the dates/time a status changed occured as columns within that row. At present each status change creates a row in the "transaction" table and so my report has multiple rows per incident ref.

What I would like to achieve is a row with these fields from the Incidents table:

ref_no  |  product_id  |  date_created

And then add to it 3 columns based on Transactions table data where "trans_type = Changed Status" - it is this that is currently giving me rows that I don't want!

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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