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 report with Answers Summary

edited Jun 1, 2020 5:59AM in Reporting & Analytics for B2C Service 6 comments

Summary

Creating a report joinning two tables with no common fields

Content

Hello!

I can´t find a way to add the title of an answer (answers.summary) into the incident's report because this two tables don't have any field that can be related to each other.

I've managed to get so far to alternate the data between incidents and answers. This is an example of what I've been trying, using the following tables:

  • Transactions (set as root)
    • INNER JOIN on Incidents AND Answers gives as a result "No elements to show on this view."
    • EXTERNAL JOIN on Incidents and INNER JOIN on Answers = No info from the incidents fields but shows Answers.summary data.
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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