We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

Unable to apply interactive filter condition

ARAVINDA11
Tera Contributor

HI TEAM,

 

I have a field called IT Leader in cmdb ci table the it leader field refers to sys_user table and condition applied as below 

ARAVINDA11_0-1779816398578.png

 

and for a dashboard interactive filter if i tried applying same condition for same field it is not displaying group user list help me how to achieve this 

 

ARAVINDA11_1-1779816482633.png

 

12 REPLIES 12

What i need to return please brief

In the script include return "users" instead of users.toString()

its working in cmdb_ci_server table for it leader 

AndersBGS
Tera Patron

Hi @ARAVINDA11 

 

your business requirement is not clear - what is it that you would like to do?

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

MariusAlinPopa
Tera Contributor

Hi @ARAVINDA11 ,

 

Your script include returns a sys_id array, but your dashboard condition checks the value of the User ID field.

Just remove .User ID in your condition.

 

Instead of:

IT Leader.User ID - is one of - script include return

Replace with:

IT Leader - is one of - script include return

Or target the sys_id directly:

IT Leader.sys_id - is one of - script include return

 

Let me know if it works, 

Marius