I need to create a new scoreboard node that will filter all active Change Orders that have a specific CI attached. Has anyone been able to successfully create this query? We are on version 12.7 of Service Desk.
there is OOTB BREL attribute called "asset" so there is no customization needed,
you can use:
(asset.nr IN U'C08FD51611E870419076A0C2EDA664C0')
(asset.nr.name like '%intel%')
You will need to create trigger and spel code that will fill custom attribute when ci is added and clear when ci removed, i think cdtj will provide example for you. Other solution would be to make additional custom srel field to nr and do the query on this field
Thank you! That worked great!
Today for some reason I have decided that it is not possible to write queries on BREL. Shame on me.
Today is a bad day for science