1 Reply Latest reply on May 23, 2016 6:27 AM by Paul Hyman

    Is it possible to create a query to show Change and Request incidents

    gwilliams Rookie

      I am trying to create a query or something to put on my dashboard that will show Analysts all changes or requests created for a particular Configuration Item.  

      I have queries for Change and request separately but I need to link them together into one query. 

       

      Can this be accomplished?

      Greg

        • 1. Re: Is it possible to create a query to show Change and Request incidents
          Paul Hyman Expert

          Hi Greg

           

          As CI is at the child level it can be more difficult.

          You could create a one to one link of CI on the process object and then set a calculation on it to be the same as the child.

          Then you could create the query on the process object and see all the change, problem, incident, request and a copy of the CI from the child.

           

          The calculation would need to be a "before save" but if you need the old data updated you would need to set as a "schedule calculation" and run a bulk action first then change it to "before save" afterwards

           

          Thanks

          Paul