How to display HR cases of particular Subject person's only on the Reference field ?

Ramu6
Tera Contributor

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

1 ACCEPTED SOLUTION

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 : 

View solution in original post

13 REPLIES 13

Are you sure the sys_id you passed is the sys_id of record from HR Service table and not that of Record producer?

@Jaspal Singh 

Yes, i have passed the sys_id of HR service only

Amit Gujarathi
Giga Sage
Giga Sage

HI @Ramu6 ,
I trust you are doing great.

Here’s a step-by-step guide on how to achieve this:

  1. Go to the Table where the Reference Field is located:

    • Navigate to the table that contains the reference field you want to modify.
  2. Modify the Reference Field:

    • Open the dictionary entry of the reference field.
    • In the 'Attributes' section, you will add a dynamic reference qualifier.
  3. 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



Ramu6
Tera Contributor

Hi All,

Please help me on this

 

Thanks

Ramu