Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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