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
Incidents assigned to different users. — 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

Incidents assigned to different users.

Accepted answer
9
Views
2
Comments
edited Aug 10, 2018 3:56PM in Reporting & Analytics for B2C Service 2 comments

Content

I am trying to create a report that would show all Incidents from a specific Q (they don't need to stay in the same Q) that were assigned by specific people to other agents.

I got so far as to get all incidents that were assigned from specific Q by specific people, but am struggling how to filter out the ones that they assigned to themselves (either before reassigning, or to resolve). I just want to see the ones that they assigned to other agents.

I hope someone can help. I am attaching the definition in xml and pdf format of what I got so far - as you can see I even managed to get a column that shows No Value if they assigned to themselves, but I would like to be able to filter out these incidents (transactions.acct_id NOT EQUALS accounts2.full_name). Unfortunately, the accounts2.full_name does not allow usage as a filter.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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