how to get parent table fields in child table business rule.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-06-2023 12:14 AM
I'm working on sc_task business I want to get sc_req_item table cat_item field value sc_req_item is parent table of sc_task.
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-06-2023 12:24 AM - edited 12-06-2023 12:29 AM
You can dot walk like this.
var cat_item = current.request_item.cat_item + '';
This will get you sys_id of the cat_item.
If you want the name, you can dot walk like,
var cat_item_name = current.request_item.cat_item.name;
Please mark my answer helpful and accept as a solution if it helped 👍✔️
Thanks,
Anvesh
Anvesh