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

Go to solution
DonnaSTLMartin
Tera Expert

‎10-25-2023 06:56 AM

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?

0 Helpfuls
  • 901 Views
1 ACCEPTED SOLUTION

Go to solution
Ankur Bawiskar
Tera Patron
Tera Patron

‎10-25-2023 07:27 AM

@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

AnkurBawiskar_0-1698244050997.png

 

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

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

6 REPLIES 6

Go to solution
Vamsi43
Tera Contributor
In response to Ankur Bawiskar

‎08-06-2024 10:45 PM

hello @Ankur Bawiskar 

 

my requirement looks similar but

I need to create a report that will show RITM Number (Requested Item [sc_req_item]) with no approvals and no tasks.

 

Thanks

0 Helpfuls

Go to solution
abhilash_4344
Tera Contributor
In response to Ankur Bawiskar

‎12-19-2024 10:10 AM

Hello @Ankur Bawiskar 
With this we are able to create a database view . Once we are creating a report on this table, we are getting the same records(RITM) multiple times.
Could you please let me know what can be issue here and how to resolve this?

Thanks 

0 Helpfuls