Unable to get multiple values in List Collector based on other list collector variable

HK5
Kilo Contributor

Hi,

I have 3 List collector type variables (i.e Organization, Host Groups, Hosts) on the form. I should be able to select multiple options for each variable.

find_real_file.png

Host Group list collector options should be available based on the selection of the organization variable. So currently when i select one option from organization i can see the host group option.

find_real_file.png

but when i select multiple values in organization variable then there is no data available in host group.

find_real_file.png

Here is the below Ref qualifier I'm using for Host Group variable in scoped application.

Reference Qual: javascript:'active=True^organization_depend='+current.variables.line_of_business_lob.getDisplayValue();

Thanks in Advance!

Krishna.

1 ACCEPTED SOLUTION

Brad Bowman
Kilo Patron
Kilo Patron

Hi Krishna,

List collector variables, like List fields, store a comma-separated list of sys_ids for selected records on the referenced/List table.  I don't believe that getDisplayValue() works with these variable or field types, especially when more than one value is selected.  Your Host group List Collector reference qualifier needs to expect sys_ids, and not display/string values.  You will also want to change your reference qualifier to accept one or many values from Organization by using IN instead of =, so try this as your Reference Qual, making sure the data is structured so that organizaton_depend contains a sys_id.

javascript:'active=True^organization_dependIN'+current.variables.line_of_business_lob;

View solution in original post

3 REPLIES 3

Brad Bowman
Kilo Patron
Kilo Patron

Hi Krishna,

List collector variables, like List fields, store a comma-separated list of sys_ids for selected records on the referenced/List table.  I don't believe that getDisplayValue() works with these variable or field types, especially when more than one value is selected.  Your Host group List Collector reference qualifier needs to expect sys_ids, and not display/string values.  You will also want to change your reference qualifier to accept one or many values from Organization by using IN instead of =, so try this as your Reference Qual, making sure the data is structured so that organizaton_depend contains a sys_id.

javascript:'active=True^organization_dependIN'+current.variables.line_of_business_lob;

HK5
Kilo Contributor

Thanks Brad It works!!

 

Regards,

Krishna

You are welcome.