Help With Database View (RITM-Approvals/SCTASK-Assignment Groups)

[DonnaSTLMartin]

I need to create a report that will show these things:

• RITM Number (Requested Item [sc_req_item])
• Item Name (i.e. O365 User License, Docking Station)
• RITM Approver (Approval [sysapproval_approver])
• SCTASK(s) linked to approved RITM (Catalog Task [sc_task])
• SCTASK(s) Assignment Group

I have tried, very unsuccessfully, to create a database view. Is what I’m trying to build possible? Any suggestions for what this would look like?

[Ankur Bawiskar]

@DonnaSTLMartin 

please share what did you try so far?

[Ankur Bawiskar · Accepted solution]

@DonnaSTLMartin 

try this add required view fields under view tables and add the required column in list via gear icon

Ensure the field you are using in where clause is present as view field for that view table

If my response helped please mark it correct and close the thread so that it benefits future readers.

[DonnaSTLMartin]

Ankur, you are awesome!  This is the perfect solution. Turns out I had an incorrect clause.

[Ankur Bawiskar]

@DonnaSTLMartin 

Glad to help.

Do share what your query looks like along with screenshots so that it helps other members.