Clarity Service Management

Expand all | Collapse all

Scoreboard Query - Change Order with CI

Jump to Best Answer
  • 1.  Scoreboard Query - Change Order with CI

    Posted 06-29-2015 01:07 PM

    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.



  • 2.  Re: Scoreboard Query - Change Order with CI

    Posted 06-29-2015 01:20 PM

    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



  • 3.  Re: Scoreboard Query - Change Order with CI
    Best Answer

    Posted 06-29-2015 02:52 PM

    hi,

    there is OOTB BREL attribute called "asset" so there is no customization needed,

    you can use:

    (asset.nr IN U'C08FD51611E870419076A0C2EDA664C0')

    OR

    (asset.nr.name like '%intel%')



  • 4.  Re: Scoreboard Query - Change Order with CI

    Posted 06-29-2015 03:04 PM

    Thank you!  That worked great!



  • 5.  Re: Scoreboard Query - Change Order with CI

    Posted 06-29-2015 03:21 PM

    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