How to compare two projects in Jira

[Gold]

PRESENTATION :
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.


QUESTIONS:
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.

Thank you

[Gold]

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 ?

[Nic Brough -Adaptavist-]

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

• are accepted
• have a link to an issue in project 2 that is solved or closed

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 

[Gold]

No i don't have that function on my Jira Cloud interface

i tried this :
project = project1 AND status = Accepted AND issuekey in linkedIssuesFromQuery("")

but project2 isn't recognize. So i don't know which command i can put to have good results like yours.

[Nic Brough -Adaptavist-]

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:

1. You're trying a query that doesn't mention project2 and then saying you are getting an error message saying it is not recognising project2 - how are you doing that?  What are you really doing?  (Because the error message you are reporting could not be generated by the query you are typing in)
2. Why do you keep harking back to linkedIssuesFromQuery()?  That is not a function, even if you had Scriptrunner
3. Could you explain the question you are trying to ask of Jira.  Is the definition of the question I guessed at in my previous answer what you want?

[Gold]

Hi,

I just need a JQL command (for the online version of JIRA that I have) allowing me like in the example:

Proposal 1:

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 

thank you 

[Daniel Ebers]

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.

[Gold]

hello

good thing for that query so i found something like this also :

project = project1 AND Status in (Accepted, Analysed) OR project = project2 AND status in (Closed, Rejected)

what do you think about ?

But it's not the real deal that i was looking for on my first asking.

[Daniel Ebers]

Hi @Gold

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.

[Gold]

Anybody to give me some queries tips please ?

[Nic Brough -Adaptavist-]

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"

[Gold]

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

[Nic Brough -Adaptavist-]

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))