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

Use Another Table for Primary Key on Report

edited Aug 10, 2020 12:44PM in Reporting & Analytics for B2C Service 2 comments

Content

Hi all,

I hope the below makes sense. I am trying to have a report run in our incident workspace that will show any other recent incidents raised recently under the same interested party contact.

The difficulty I am having is the report will always fill the c_id field from the incidents -> contact -> c_id
I need it to get the value from incidents -> interested_parties -> contacts2 -> c_id when the tab is opened and the report runs from the workspace.

I don't think the interested parties add in is standard across the OSC product, but it's a way of attaching other contacts to incidents whom it relates to. I have attached some screenshots. The first shows the report I have built, taking the contact ID from the incident contact. The second shows the interested party assigned to the incident whose contact ID i need to go into that field. I had to redact all my information but you can get what it is from the headers.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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