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?
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.