How to create Database view between Catalog Task and Asset Table

[SourabhAkiwate]

Hello All,

I have requirement that create report on, which assets has been assigned to user who is Requested for from catalog task table.

Could you please help me out to create report through script or through Database view ?

Thank you,

Sourabh A

[Robert H · Accepted solution]

Hello @SourabhAkiwate ,

As others have pointed out, there is no "Requested for" field on the Catalog Task table. I am going to assume you mean the "Requested for" of the RITM.

This is how your Database View would need to be configured to achieve that:

It will give you something like this:

Or, if you really need that report to be based on the Catalog Tasks, you would need to join all three tables, like this:

Regards,

Robert

[Shivalika]

Hello @SourabhAkiwate 

Create a Data base view and Join tables sc_task and alm_asset. 

In the where clause - add below line 

alm_asset.assigned_to = sc_task.requested_for

NOTE - replace alm_asset with trh prefix you choose for asset and sc_task with suffix you choose for task. 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY