The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)
I am trying to locate all projects that are not using any sort of defined Issue Security Scheme? Is this possible using JQL or must this be a DB query?
1 answer
Comments for this post are closed
Community moderators have prevented the ability to post new answers.
Atlassian Team members are employees working across the company in a wide variety of roles.
May 22, 2015 edited
Hey there,
You can run the following query on JIRA DB:
select pname from project
where pname not in
(
select pj.pname from nodeassociation na
inner join issuesecurityscheme iss on iss.id = na.sink_node_id
inner join project pj on pj.id = na.source_node_id
and na.source_node_entity = 'Project'
where na.sink_node_entity = 'IssueSecurityScheme'
);
-- Arthur Gonçalves
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.