I need to do 'JOIN' with an advanced seach in JQL

I need to do 'JOIN' with an advanced seach in JQL, because I want to get a filter on the advanced search (with fields of different projects that do not match in both) showing those tasks where two different projects have the same value in the custom field 'center TAS'. What function can I use?

  

Regards

1 answer

0 vote

JQL is not SQL, and there's no "join" type functions.  JQL simply finds issues that match criteria and has nothing to say about the output.

Your query needs to use something like (project = X and cf1 = Y) or (project = Z and cf1 = Y), but I'm not 100% sure what the actual problem is here.

Hi Nic,

I need to get a filter that show fields of two projects diferents, where field 1 only is in the project 1 and field 2 only is in the project 2, the unique relation between both projects is that some issues in project 1 is linked with some issues in project 2. I know that SQL I colud doing but with JQL I don't know. Some idea?

 

Thanks

I'm sorry, I don't understand that.  I get that you have two projects with different fields, but I'm lost from "unique relation"

As I said, JQL is for finding issues, and the query I gave should pull back the issues you seem to be interested in.  I'm not sure your "unique relation" is even stored in JIRA, so there's no way you can report on something that is not there.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Jira

Meet the AUG leaders of Northern Virginia

@Rachel Wright (Jira Genie), @Billy Poggi (AUG NOVA, DC), and @Dana Jansen (Confluence Queen) are just some of the folks that lead one of the world's most active Atlassian User Group (AUG)....

121 views 4 9
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you