I’m running into an issue where I need to build a query that displays a CI, one that is part of multiple Change processes. This means that a CI might be associated with more than one Change ID. Logically, I’m getting two results per CI when I query on the CI Title (which I need to launch the ticket in Webdesk). I’m getting one that displays correctly the initial completed change process, and another that shows “No Value” which, when launched, displays the other Change process.
Changing query criteria to display based on status does not fix the issue.
Can you think of a way to select which change process to display when selecting a CI? I need to be able to display both on my dashboard.
See screenshot for an example of what I mean. The CI displays as "No Value" when displayed in a query