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

[HK5]

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.

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.

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

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.

[Brad Bowman · Accepted solution]

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]

Thanks Brad It works!!

Regards,

Krishna

[Brad Bowman]

You are welcome.