Hello everyone!
I need help with the where clause for this database view
I want All requested items, catalog tasks connected to the requested items and the SLA connected to the catalog task!
how can I achieve this ?
screenshot is also attached!
thanks a bunch
1 ACCEPTED SOLUTION
Hi,
please update the below:
1) change the order of the view tables
2) use where clause as per screenshot
3) ensure you add below fields for view fields in respective view tables
Screenshots below:
RITM View Table Fields:
Catalog Task View Fields:
Task SLA View Fields:
When you do try it; add these columns using gear icon:
Output:
Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur
