Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Database views

tushar_ghadage
Tera Contributor

Hi , 

Can anyone guide me on problem migration utility what its for and why its used ??

 

thankss

1 ACCEPTED SOLUTION

@tushar_ghadage 

My thoughts

-> Since you said it didn't show data when you click Try it -> then do you have data in your tables (RITMs have approval records and those RITMs have SC Task with them)

-> It all depends whether you want to join sc_task or not => based on customer requirement

I shared solution already for this couple of years ago and it worked fine

-> Try to re-order the View tables as per below

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

AnkurBawiskar_0-1759298684336.png

 

AnkurBawiskar_1-1759298700286.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

15 REPLIES 15

Sure thanks for the help