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

 

View solution in original post

but it is showing no records to display 

find_real_file.png

Hi poornima,

try to change the "Left join" checkbox on the three records related with the three tables.
I know that it will interfere with the results, so this might be the case!!

Best Regards,

Filipe Cruz