Database views

[tushar_ghadage]

Hi , 

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

thankss

[Bhuvan]

@tushar_ghadage 

Can you keep order for sc_req_item to 100 and update sysapproval_approver order to 200 and try again.

Also use underscore '_' for where clause rather than dot '.', refer below for sample

If this helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[tushar_ghadage]

also 

i want to join 3rd table as well called sc_task.

and show approver for the each sc_task as well 

will condition be the same ??

[Bhuvan]

@tushar_ghadage 

Yes, since approver is common field across the tables you should be able to make it work. Make sure to define the order sequentially and where clause correctly.

Below is a sample configuration for 3 tables in database view

If this helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[Bhuvan]

@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