Database View Where Clause

[Yanal]

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

[Ankur Bawiskar · 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

[Yanal]

Brilliant, I just want to add that I made left join true on Catalog task and SLA so I can get all requests even if they do not have tasks in them

[Ankur Bawiskar]

Hi,

Okay on which table you made left join as true?

Also does it make sense showing all requests even if they don't have sc tasks in them

Regards
Ankur

[Yanal]

I made left join as true on both the SLA and Catalog task.

In my case I needed to show all requests for reporting purposes because Tasks are created after some approvals 😄