Need to filter reference field with CMDB table

rajibosss11
Tera Contributor

4 weeks ago

Hi Team,

I have an Incident form with a Subcategory field containing the following options: Hardware, Application, and Database.

Below the Subcategory field, we have a Configuration Item reference field (referencing the cmdb_ci table). I would like to apply dynamic filtering so that:

  • When the Subcategory is set to Hardware, the Configuration Item field should only show records from the cmdb_ci table where the class is Computer.

  • When the Subcategory is set to Application, it should only show records where the class is Application.

  • Similarly, for Database, it should only show records where the class is Database.

and in configuration item we have already some reference qualifier

Could you please guide me on how to achieve this?

Preview file
141 KB
0 Helpfuls
  • 1,007 Views
6 REPLIES 6

RaghavSh
Kilo Patron
In response to rajibosss11

3 weeks ago - last edited 3 weeks ago 

remove & and colon after javascript and put :

 

It should be like this


Raghav
MVP 2023
0 Helpfuls

Bert_c1
Kilo Patron

3 weeks ago

Post the script include "CustomAffectedCIFilter" so folks can see the logic used.

0 Helpfuls