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.

View solution in original post

15 REPLIES 15

Sure thanks for the help