- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-29-2021 01:45 PM
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.
Solved! Go to Solution.
- Labels:
-
Scoped App Development
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-29-2021 03:30 PM
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-29-2021 03:30 PM
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-29-2021 08:13 PM
Thanks Brad It works!!
Regards,
Krishna
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-30-2021 04:48 AM
You are welcome.