How to join tables for reporting in HRSD?

[DeniseLeighton]

Hello, Can you direct me to a knowledge article on joining of two tables for reporting in HRSD. 

[task_sla]  [sn_hr_core_case]

Currently on Yokahama. 

Thank you

[Tanushree Maiti · Accepted solution]

Hi @DeniseLeighton 

Create a Database View to join table [task_sla]  [sn_hr_core_case] . then report from this .

1. Navigate to System Definition > Database Views.
2. Click New.
3. Name: hr_case_task_sla  //name it as you want
4. Label: HR Case TASK SLA.
5. Save the record.
6. In the View Tables related list, click New. 

Table                              Order            Variable prefix                  Where Clause

task_sla                        100                     sla
sn_hr_core_case        200                   hrcase                        sla_task = hrcase_sys_id

[Tanushree Maiti · Accepted solution]

Hi @DeniseLeighton 

Create a Database View to join table [task_sla]  [sn_hr_core_case] . then report from this .

1. Navigate to System Definition > Database Views.
2. Click New.
3. Name: hr_case_task_sla  //name it as you want
4. Label: HR Case TASK SLA.
5. Save the record.
6. In the View Tables related list, click New. 

Table                              Order            Variable prefix                  Where Clause

task_sla                        100                     sla
sn_hr_core_case        200                   hrcase                        sla_task = hrcase_sys_id

[Ankur Bawiskar · Accepted solution]

@DeniseLeighton 

out of the box there is a database view joining task_sla and incident

Similarly do for sn_hr_core_case and task_sla

both sn_hr_core_case and incident extend task table

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏