Unable to apply interactive filter condition

ARAVINDA11
Tera Contributor

3 weeks ago

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

 

0 Helpfuls
  • 1,207 Views
12 REPLIES 12

ARAVINDA11
Tera Contributor
In response to Teja R

3 weeks ago

What i need to return please brief

0 Helpfuls

Teja R
Kilo Sage
In response to ARAVINDA11

3 weeks ago

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

0 Helpfuls

ARAVINDA11
Tera Contributor
In response to Teja R

3 weeks ago

its working in cmdb_ci_server table for it leader 

0 Helpfuls

AndersBGS
Tera Patron

3 weeks ago

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/

0 Helpfuls

MariusAlinPopa
Tera Contributor

3 weeks ago

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

0 Helpfuls