I am in charge of two projects as a manager (1 / CocoNet Tool, 2 / ChowDry Tool). There are 8 people per project. Everyone develops the tool under the same conditions as an IT team because a lot of security and cloud environment, we have servers, virtual machines and all our infrastructure. The demand is that we have a lot of problems. Thanks to Jira, this tool offers us a better organization.
a / what are the possible requests to cohabit the two projects at the same time?
b / What request to display the "CocoNet project" in their "solved" status, and the "ChowDry" project in the "submitted" state?
--> something mix between solved and submitted like :
-----> project = CocoNet project AND status is solved OR project = ChowDry AND status is submitted (that query is not working for sure)
c / the words 'OR' and 'AND' are not easily usable, so how to properly resolve the uses of these words in a project from a use to two (2) projects.
a) I do not understand what you mean when you say "cohabit the two projects". Do you mean a person can use a project?
b) Your search is almost correct, just a case of turning into proper JQL:
( project = "CocoNet project" AND status = solved ) OR ( project = ChowDry AND status = submitted )
c) I'm not sure what you mean by "the words are not easily usable", because they could not be more simple. And means "the two clauses either side must match" and Or means "at least one of the clauses either side must match"
Here my answers :
a/ Yes it's a request to display both the projects at the same time , and show us the result for this two requests.
b/ not really good query because it show me only the both with or without project name;
Example : when it show me Projet : CocoNet, but no result for the other Project.
And other example : it show me Chowndry results in one ticket but not in the good status.
i'm looking for a query that it can show me results only on like that :
on each coconet project ticket that they are more than 8k+ issues, i 'm looking for some that they have Chowdry associated with (because it's a Dev Team project), and where that project 2, has the status closed.
-- maybe like that :
( project = "CocoNet project" AND status = submitted ) OR ( project = ChowDry AND status != rejected, solved)
maybe i have to add another thing like : AND parent link xxx (but i don't have name or ticket number for the dev base (the Chowndry).
thank you for your help
It just sounds like you have not added "project" in as a column to the results display?
Your new JQL will work fine with a very minor change to the syntax:
( project = "CocoNet project" AND status = submitted ) OR ( project = ChowDry AND status not in (rejected, solved))
if the answers match specifically what you are asking will depend on how the data really should be structured. Jira is so flexible one could mean X but the other could understand Y, lot of implementation are also biased by someone's experience, or, better said best practise.
I'll try it for your question 1):
Given the assumption you know how to query using JQL but find it not useful to see all resulsts in one set you could create a dashboard with two filter gadgets, using two distinct filters - they will show you a result of filter queries for your projects.
For question 2) it is pretty much only about having the correct goal in mind, then JQL is (mostly) easy to form. As for the association to a different project, like you said, it could be you need to use issue links in your query.
Unfortunately, by reading the first and the second requirement I did not get to the bottom of what is really needed.
You always can start small, save the query and extend. With queries you always can try - they don't disturb/damage anything.
I just need a JQL command (for the online version of JIRA that I have) allowing me like in the example:
project in (1, 2) AND status is Submitted for Project 1 AND Closed for Project 2
and on the picture you can see others queries example, but i don't know if it's match correctly following my question
The query in proposal 1 does not look right to me, neither do some of the above you posted.
It would need to look like this:
project = project AND status = Submitted OR project = otherproject AND status = Closed ORDER BY key ASC
When you want to filter for issues in a project having status Submitted but for status Closed in another.
maybe i found it and it's better to see with my which more words we can add on this query
where you can obtain issues linked by any other base
it's in relation to all issues returned by another base (parent issue or child) :
project = project1 AND status = accepted AND issue in linkedIssuesFromQuery("project = project2 AND status in (solved, closed) ")
what about this function ?
which other proposition ?
I think we are still struggling to work out what your question is, so we're not able to be clear on the exact JQL you need.
What you've given in this last comment is, well, not going to work because there's no such thing as "linkedissuesfromquery()"
But I would then start to guess that what you mean is:
Issues in project 1 that
If that is right, then try
project = project1 AND status = accepted AND
issueFunction in linkedIssuesOf("project = project2 AND status in (solved, closed) ")
There's more functions you might want to check out at Scriptrunner enhanced search
I really do not understand that, but there are questions I need to answer before I can get you any further:
Ok, you don't have Scriptrunner - that's understood now, so can you tell me:
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