Database views for request item software request approvals

[BH14]

I've been working on creating a database view for software approval requests. 

I'm trying to specifically report on request item approvals (regardless of state) for Software Requests. 

Can someone help me if there something I need to fix with the database view that I've created in my PDI?

[BH14]

For some reason the image didn't show up - but providing an image of the database view I created. 

[Dr Atul G- LNG]

Hi @BH14 

Database views are used to join more than 1 table , so you are joining Sys Approval and Software request table?

What is your exact use case, what you want to achieve. Please share more details, look like you can achieve from reporting easily.

[BH14]

Hi Atul, 

Thanks for your response

We have a manager that is interested in reporting Software Request approvals (regardlesss of state). I can pull a report for all approvals, but it doesn't appear that there is a way to discern which catalog (specifically the software catalog) they are coming from. Any ideas? 

[Dr Atul G- LNG]

Hi @BH14 

Agree, I just tested in my PDI and we cant fetch Item name in report , you need to create DB view only. You can see OOTB db. view of Incident and SLA to see how this can be build.