Reference field need to populate based on Subject person and HR service in HR case creation page.

[shivadayal4]

On HR case creation page, there is custom reference field - 'Request subcategory' which refer to custom tables 'Global Request subcategories' table, which stores subcategory mapped based on Subject person's country and the associated HR service's Record producer. 

In case creation form on selection of subject person and Hr service, this subcategory field should dynamically populate only those filtered record that matched the selected country and record producer.

I have written client script to get the value of subject person and HR service from case creation form and script include to get the multiple sys id of subcategories from global request subcategories table. but unable to set those sysid in request subcategory reference field.

And when i am trying to take input in reference qualifier instead of client script, then it's not getting the current selected Hr service and subject person.

Please support here.

@Ankur Bawiskar - Can you support in this.

[Ankur Bawiskar]

@shivadayal4 

I don't think reference qualifier will work on that page as that's not a form where current object is accessible.

it's built using UI builder so you will have to deep dive in that.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[shivadayal4]

Hello @Ankur Bawiskar ,

If Reference Qualifier will not work, then Can you guide me from client script.

If I am returning query from script include as 

u_record_producer_name=+producer+^u_countryLIKE+country+

Then any way from client script to set this in reference variable as query, so that issue will resolve.

Or any other way to solve this issue.

Thanks

[shivadayal4]

Hello,

Is this possible through by below method -

--------------------------------

f I am returning query from script include as 

u_record_producer_name=+producer+^u_countryLIKE+country+

Can we use this in client script to set this in reference variable as query, so that issue will resolve.

Or any other way to solve this issue.

--------------------------

Please update on this,

Thanks