Column field not selectable as reference field in an interactive filter reference when column is from type "List"

[Florian May]

Hello,

we want to use a column from the type "List" as a reference field within an interactive filter reference but the field is not selectable.

Steps to reproduce:

- Add a new column e.g. "Users Test" with "Type = List" and "Reference Specification = User (sys_user)" to a table e.g. "cmdb_ci_business_app"

- Create a new interactive Filter in application "Reports" with "Reference= sys_user"

- Try to add an interactive filter reference with "Reference table = cmdb_ci_business_app" and "reference field = Users Test"

Like displayed in the attachment the field is available but not selectable. Changing the column type to "Reference" instead of "List" ist not an option. Any ideas?

Thanks

[Ankur Bawiskar · Accepted solution]

Hi,

As per documentation List type of field is not supported

https://docs.servicenow.com/bundle/geneva-performance-analytics-and-reporting/page/administer/homepa...

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Florian May]

Hi Ankur,

thank you so much for your feedback! 🙂

BR

Florian