- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-18-2022 03:11 AM
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.
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-18-2022 06:24 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-18-2022 08:40 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-18-2022 08:43 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-18-2022 08:55 AM