reporting Table Join for request table and feedback table

[yelyah.nodrog]

I'm trying to create a report that gives me all of yesterdays resolved tickets that have had completed feedback on them, however I can only get the feedback table or the Request table.
From the request table it doesn't give me the option to join onto the feedback table (even though they share the Request ID field in both.)

I need both tables as I want to filter the report to only give me tickets resolved by a certain team. I have just got back from maternity leave so a little rusty, any help would be greatly appreciated.

H

[Steve Giller]

Are you using the SQL Schema Designer or An Entity for the Report?

If the latter, the Feedback Table is not available as part of the Request Entity, and vice versa.

[DRiley]

Hi @yelyah.nodrog , 

 I hope you're well.

I have a report that looks at feedback received maybe this definition will help? You'll ned to tweak the filter and columns included but sounds like it might have the join you need?

Dan

customer-feedback---feedback-received.report.txt

[yelyah.nodrog]

Ah! Perfect thanks Dan,

I figured I would need to do it as a SQL Schema but couldn't for the lift of me remember the table names,

I'm all good thank you adjusting to life with two littlies. Hope everything is good your end

H