I joined task_sla and sn_hr_core_Case table to create a report which shows the sla from hr case table

poornima batchu
Tera Expert

hii,  

   I have to create report for incidents and requested items whose SLAs is greater than 50% but in task_sla table SLA diled is not defined for this I have to bring out the SLA field from the hr case to table. I created a database view with task_sla table and hr case table but I am stuck with where clauses. anyone provide me a solution for this.

 

 

thank you.

1 ACCEPTED SOLUTION

Hi poornima,

If you want to add a third table, add it, set a prefix for it, put the order 300 and the add a similar condition like the one that was set for the hr case:

sla_task = new_table_prefix_sys_id

Hope this helps!

Please, don't forget to mark my answer as correct if it solves your issue or mark it as helpful if it is relevant for you!

Best Regards,

Filipe Cruz

 

View solution in original post

7 REPLIES 7

Filipe Cruz
Kilo Sage
Kilo Sage

Hello poornima batchu,

Here is the database definition to join task_sla with hr case table:

find_real_file.png

 

Please, don't forget to mark my answer as correct if it solves your issue or mark it as helpful if it is relevant for you!

Best Regards,

Filipe Cruz

thank you cruzz.

  cruz, 

 

do I have to use the same clause if I wanted to replace hr case table with incident or if I wanted add three tables .how the where clause should be.

Hi poornima,

If you want to add a third table, add it, set a prefix for it, put the order 300 and the add a similar condition like the one that was set for the hr case:

sla_task = new_table_prefix_sys_id

Hope this helps!

Please, don't forget to mark my answer as correct if it solves your issue or mark it as helpful if it is relevant for you!

Best Regards,

Filipe Cruz