Relationship Query script

SystemsGo
Tera Contributor

Hi Experts,

 

I've created a table called (u_asset_entilement) to display on the incident to entitle asset to user from incident table as attached screen shot.

Is there any way to only display the assets belongs to the company which is the same as the company of incident form?

I've created a relationship Query script, but seems not correct.

 

How to user relationship query script to narrow down the asset list?

 

In another hand, is there any other way to implement this requirement besides the relationship query script?

SystemsGo_2-1745806917670.png

 

SystemsGo_1-1745806705309.png

 

 

 

 

11 REPLIES 11

Dominik1988
Tera Expert

I added asset field (reference from alm_asset)  on incident and in settings of this field (in form designer) I set up "Dependent" to company and it is working . 

Hi Dominik,

 

Thank you so much for your reply.

 

I think the asset should be not one record or multi records. 

Hopefully, the should be a list, so that agent who take response for this incident can assign assets to different users form the incident form. So I created a new table u_asset_entitlement to implement this requirement.

There are 2 fields in that table - asset(reference alm_asset), user (reference sys_user).

When agent click asset like below screen shot, only display assets belongs to the company.

SystemsGo_1-1745819859450.png