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

 

3 REPLIES 3

tejarekanda
Tera Guru

Hi @ARAVINDA11 ,
Can you share the ScreenShot of that Script Include.And also try that in the Background Script and verify that the sys_ids are coming properly.

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