The Zurich release has arrived! Interested in new features and functionalities? Click here for more

List Collector Reference Field is dependent on another reference field + Need Reference Qualifier

mark141230
Tera Expert

Hello ServiceNow Expert,

 

Need your assistance please, I have this requirement where I have a list collector field in the catalog item form that is dependent to another reference field.

 

Example:

       Profile Name field (List Collector) will only display choices associated to the Application (Reference Field) being           selected by the user.

 

I used this reference qualifier but it only works on Lookup Select Box

 

Reference Qualifier:              javascript:'u_managed_application='+current.variables.application+'^u_active=true'

variable attributes:                ref_qual_elements=application

 

how you can help me guys.

Thanks in advance!

       

1 ACCEPTED SOLUTION

@mark141230 If possible, please share the snapshot of table structure of u_rba_matrix table.

View solution in original post

7 REPLIES 7

Sandeep Rajput
Tera Patron
Tera Patron

@mark141230 Do you have u_managed_application and u_active fields defined on the table being referenced via the list collector?

Actually the u_managed_application is a table where "Application" Reference field is pointing right now.

Then the list collector "Profile Name" is pointing to u_rba_matrix. The u_rba_matrix do have a field name "Application Name" which is reference to "u_managed_application".

@mark141230 what is the column name for field Application Name defined on u_rba_matrix, if it is u_application_name then you can update your reference qualifier as follows.

 

 javascript: 'u_application_name='+current.variables.application+'^u_active=true'

Hope this helps.

Hi Sandeep,

 

I tried changing the qualifier based on your suggestion but still now working.

Here is my config

 

mark141230_0-1698089588959.png