- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-31-2023 09:11 AM
Hi All,
Basically, we have two fields 'Subject Person', Employee Records, So here 2nd field refers to the Case table, so here(in 2nd field) i want to display the records of other Record producer(HR cases) related this particular subject person ?
Please help me to achieve this
Thanks
Ramu
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-31-2023 10:02 AM - edited 10-31-2023 10:02 AM
Well, that seems to be deviation from original ask. You can close this thread and open a new one for further conditional check.
Also, you can try
javascript: 'subject_person='+current.subject_personvariable+'^hr_service=1233';
where hr_service is a field with 1233 as sys_id you can add your condition accordingly
Also, as it seems : is getting replaced with :

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-01-2023 02:10 AM
Are you sure the sys_id you passed is the sys_id of record from HR Service table and not that of Record producer?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-01-2023 02:12 AM
Yes, i have passed the sys_id of HR service only
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-31-2023 09:27 AM
HI @Ramu6 ,
I trust you are doing great.
Here’s a step-by-step guide on how to achieve this:
-
Go to the Table where the Reference Field is located:
- Navigate to the table that contains the reference field you want to modify.
-
Modify the Reference Field:
- Open the dictionary entry of the reference field.
- In the 'Attributes' section, you will add a dynamic reference qualifier.
-
Add a Dynamic Reference Qualifier:
- You can use a JavaScript code as a reference qualifier to dynamically filter the HR cases.
- Below is the JavaScript code you can use as a reference qualifier:
javascript:'subject_person=' + current.variables.subject_person;
Was this answer helpful?
Please consider marking it correct or helpful.
Your feedback helps us improve!
Thank you!
Regards,
Amit Gujrathi
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-01-2023 05:24 AM
Hi All,
Please help me on this
Thanks
Ramu