Forum

This content is now out of date.

Visit Our Community

Joining condition between Yellowfin Tables

Hi,

How can we join Yellowfin Tables : Organisation , ReportInstance , Person and ReportBroadcast.

Hoping for your response soon..

Thanks,
Dhrati

Hi,

We are waiting for your response.

Thanks,
Dhrati
Hi there Dhrati,

I'm not sure what you're up to, but anyway, you can join the ReportInstance and ReportBroadcast tables by the reportID column, and then you can join the ReportInstance table to the Person table via ReportInstance.IPRequestor = Person.IPPerson and then you can join the Person table to the IPRltShp table via Person.ipperson = IPRltShp.IPChild and then you can join IPRltShp to the Organisation table via IPRltShp.IPParent = Organisation.IPOrg

Hope that helps your report,

Dave

Thanks for trying Yellowfin

Please complete the form below to request your copy of Yellowfin today.