Need to join three tables to export a report

[si21]

Hi experts,

We need a report that should contain HR case number and the record producer question/ answers and the attachment table.

I was able to create database view joining HR case table and attachment table but on the report unable to view Questions in columns. How can I join question table and what should be where clause?

Please guide me

TIA

[Ankur Bawiskar]

@si21 

you can create database view and join HR Case, Question/Answer table and Attachment table like this

Then use this in reporting

question_answer table has Table SysId -> you can use this to join with HR case record sysId

Sys Attachment table has Table SysId -> you can use this to join with HR case record sysId

what did you start with and where are you stuck?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@si21 

something like this between HR case and question, attachment

It worked for me, I just submitted HR case with attachment via record producer

I hope I have answered your question and you can take it further from here.

You can report on that database view table in your reporting module

If my response helped please mark it correct and close the thread so that it benefits future readers.