I am using the following query to show projects that has links.
issueFunction in linkedIssuesOf("project = xxx")
What should i do to get the negate of this query, meaning, I want to list all jira issues which doesnt have a link to project xxx. I tried the following but scriptrunner doesnt like the syntax
NOT (issueFunction in linkedIssuesOf("project = xxx"))
!( issueFunction in linkedIssuesOf("project = xxx"))
Thank you for your question.
I can confirm that calling not in on issue function is invalid as the issueFunction in linkedIssuesOf() function is protected as this is required to invoke the enhanced search mechanism that the JQL provides.
This means that you need to leave the function call as it is and place the not keyword before the call is made in order to retrieve the inverse results from the search.
This means that your example query above should be structured to use the syntax shown below.
not issueFunction in linkedIssuesOf(<SubQueryHere>)
I can confirm that you can see more detailed information on how the Enhanced Search functions work inside of Jira Cloud in the documentation page located here.
You can also see more details on the differences between the cloud and server versions of the add-on in the documentation page located here
If this response has answered your question can you please mark it as accepted so that other users can see it is correct when searching for similar answers.
No, "not in" is perfectly valid (at least in Jira Server). But, so is "not issueFunction ..."
These two queries produce the exact same result set:
issueFunction not in linkedIssuesOf("project = BR")
not issueFunction in linkedIssuesOf("project = BR")
I can confirm that not in is valid inside of Jira Server but inside of Jira Cloud the ScriptRunner search functions work differently and must be run on the Enhanced Search page due to the fact that we run the queries in a sandbox environment due to the restricted nature of Jira Cloud.
The Enhanced Search functionality works as mentioned in my previous reply and does not support using issueFunction not in like you can do in Jira Server.
Get ready! Demo Den Episode 4 is coming your way on Tuesday, May 28, 2018 with a Continuous Integration and Delivery special demo. CircleCI Director of Solutions Engineering, Eddie Webb will show us ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events