Database views

[tushar_ghadage]

Hi , 

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

thankss

[Ankur Bawiskar]

@tushar_ghadage 

Things to check

1) Add RITM field as view field under sc_task table

2) Add "Approval for" as view field under sysapproval_approver table

Did it show records when you clicked Try it?

If yes then it should show data in the Reporting

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

[tushar_ghadage]

No it did not show the data (using try it) after adding the condition 

also one question

is it good practice to create new database view foe the catalog task .. only

[tushar_ghadage]

Hi @Ankur Bawiskar , 

can you please validate the above comment .. 

thank you 

[Ankur Bawiskar · 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) 

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

[Ankur Bawiskar]

@tushar_ghadage 

Would you mind closing your earlier questions by marking appropriate response as correct?

Members have invested their time and efforts in helping you.