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

@tushar_ghadage 

 

I am not sure why the question was changed as edited version is unrelated to original question.

 

Please create a new thread for new question so that it can help you and others to find right solution for the question.

 

Thanks,

Bhuvan

Ankur Bawiskar
Tera Patron

@tushar_ghadage 

what's your actual business requirement?

share that along with screenshots.

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

Hi @Ankur Bawiskar , 

I need to show the approver column for the RITM records and catalog task records as well 

for the RITM it is working but when I added the third table in database view its not showing me any data. 

below I am trying to add the approver column for the catalog task as well along with the ritm records for this I have created below queries : 

Screenshot (487).png

above is the condition I am using it for joining 3 tables 

here but when I try to run it I am not getting any data for the report 

as shown below 

Screenshot (489).png

am I missing something in the clause ?? 

thankss