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.

Show specific columns from table in list collector field by using ref_ac_columns for List Collector

Aishwarya_R
Tera Contributor

If you want to show some specific column values from the table in list collector field in catalog item or record producer, then use ref_ac_columns for List Collector as below:

In List Collector field, click on "Type Specifications" tab.
In 
Variable attributes  write:
ref_auto_completer=AJAXTableCompleter,ref_ac_columns=column_name1;column_name2;column_name3,ref_ac_columns_search=true

eg.

Aishwarya_R_0-1754984541452.png

output :

Aishwarya_R_1-1754984724230.png


Also , if you want to sort any column , then use ref_ac_order_by=column_name 
It sorts the values alphabetically.

If you find it helpful, then please mark it as helpful. Thank you.

 

0 REPLIES 0