Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
Level
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to compare two projects in Jira Edited

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

5 answers

0 votes

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

Anybody to give me some queries tips please ?

0 votes
Daniel Ebers Community Leader Mar 09, 2021

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.

queries.jpg
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 Community Leader Mar 10, 2021

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.

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.

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

  • 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 

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.

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?

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

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

Events near you