how to fetch location details from one table to location reference field
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-01-2024 03:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-01-2024 04:13 AM
Hi @saanvitha
You can achieve it by Dot Walking
Imagine a table (e.g., Incident) with a location reference field. Dot walking lets you reach details from the referenced table (e.g., cmn_location) like this
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-01-2024 04:46 AM
Hi @saanvitha
we can use Dot walking as
user.location.country_field.getDisplayValue();//to get the value of the field
or
user.location.country_field.getValue();//to get the sys_id of the field
Thanks
dgarad
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-01-2024 04:57 AM
Hi @saanvitha ,
Could you please explain a bit more about your requirement, what exactly are you trying to achieve ?
Please mark this comment as Correct Answer/Helpful if it helped you.
Regards,
Swathi Sarang