catalog item

[velkuruhari]

Hi All,

Good evening!

In a catalog item, i have mentioned variable type as a list collector, for that list table selected as custom table, this custom table i have created mentioned  location as new column  under choices I have added different locations , when user has to select multiple locations it should dispaly and consider. 

Here, could you please let me know what should be the reference qualifier and variable attribute.

Please do the needful , 

Thanks

Pavithra

[Carlos Petrucio · Accepted solution]

To configure your List Collector variable in a ServiceNow Catalog Item to display multiple selectable locations from a custom table, follow these steps:

 

1. Reference Qualifier

Since the List Collector is pulling values from a custom table, you need to use a Reference Qualifier to filter and display only relevant records.

• If you want to display all locations from your custom table:

  active=true

  (Assuming your table has an active field and you only want active records.)

• If you want to filter based on some condition (e.g., a specific category, type, or another field):

  category='XYZ'

  (Replace category with the actual field name and 'XYZ' with the appropriate value.)

• If you want to dynamically filter based on another field in the form:

  location_field_on_custom_table=$current.location_variable

2. Variable Attributes

For the List Collector variable, use these attributes:

Attribute Value Purpose

slushbucket	true	Enables selection of multiple values.
reference	your_custom_table	Ensures it pulls values from your custom table.
ref_ac_columns	column_name	Specifies which columns appear in auto-complete. (Replace with actual column name.)
ref_auto_completer	AJAXTableCompleter	Enables dynamic search and filtering.

 

If my answer helped you, remember to mark it as the correct answer and like it so that other users can find it and encourage us to continue answering.

Thank you !

- Carlos Petrucio

[Swapna Abburi · Accepted solution]

Hi @velkuruhari 

List collector type variable only shows records from selected table for multi selection. But your requirement is to fetch data from a field choice list in the custom table, i don't think its possible.

Either you need to create a custom table or use question_choice table as reference. 

[Sandeep Rajput]

@velkuruhari You can take inspiration from this article https://milestone.tech/servicenow-implementation/servicenow-tips-making-list-collectors-useful/ to address your use case.

[Carlos Petrucio · Accepted solution]

To configure your List Collector variable in a ServiceNow Catalog Item to display multiple selectable locations from a custom table, follow these steps:

 

1. Reference Qualifier

Since the List Collector is pulling values from a custom table, you need to use a Reference Qualifier to filter and display only relevant records.

• If you want to display all locations from your custom table:

  active=true

  (Assuming your table has an active field and you only want active records.)

• If you want to filter based on some condition (e.g., a specific category, type, or another field):

  category='XYZ'

  (Replace category with the actual field name and 'XYZ' with the appropriate value.)

• If you want to dynamically filter based on another field in the form:

  location_field_on_custom_table=$current.location_variable

2. Variable Attributes

For the List Collector variable, use these attributes:

Attribute Value Purpose

slushbucket	true	Enables selection of multiple values.
reference	your_custom_table	Ensures it pulls values from your custom table.
ref_ac_columns	column_name	Specifies which columns appear in auto-complete. (Replace with actual column name.)
ref_auto_completer	AJAXTableCompleter	Enables dynamic search and filtering.

 

If my answer helped you, remember to mark it as the correct answer and like it so that other users can find it and encourage us to continue answering.

Thank you !

- Carlos Petrucio

[Swapna Abburi · Accepted solution]

Hi @velkuruhari 

List collector type variable only shows records from selected table for multi selection. But your requirement is to fetch data from a field choice list in the custom table, i don't think its possible.

Either you need to create a custom table or use question_choice table as reference. 

[Ankur Bawiskar · Accepted solution]

@velkuruhari 

you are having list collector referring to custom table where user can select multiple locations

what's your next question?

Also why have you added choices under the field on your custom table since it's already a reference field?

If my response helped please mark it correct and close the thread so that it benefits future readers.