Relationship Query script
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-27-2025 07:22 PM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-27-2025 10:39 PM
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 .
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-27-2025 10:59 PM
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.