hi, in our Jira we have connected some Security tooling that gives an overview of found Vulnerabilities in the Issue.
I am struggling to work out how can i import this, my ultimate goal is to have a report of issues Resolved but Vulns still “Open”
i tried to find some sort of Custom field ID in dev tools but it doesnt seem to exist
in Jira i can use a JQL query for instance like
project in ("PROJ1, "PROJ2") AND statusCategory != Done AND vulnerability[status] = CLOSED ORDER BY due ASC, created DESC
and get valid list of issues
i tried importing “Security” as measures and trying to use co-pilot to create a calculated measure like this for instance but it does not seem to work
NonZero(Count(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
[Measures].[Issue labels] MATCHES ".*security-vulnerability.*" AND
NOT IsEmpty([Measures].[Issue resolution date]) AND
[Measures].[Vulnerability status] = "OPEN"
)
))
is this possible ?
thanks
DC