Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
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

JQL custom field value to be the same in two different projects

I need to use JQL to find a custom field value to be the same in two different project issues?

So project A issue drop down field value to = the value of project b issue drop down field value.

I thought i did this without script runner before. Need assistance.

2 answers

2 accepted

2 votes
Answer accepted

@Aaron Geister -

Try this out...

project in (xyz, abc) and <dropdown_field> in (common-value 1, common-value 2)

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.

But how can I compare that the value is = in both issues in the two different projects. I can query for the common value but I need to know they are the same on two different issues?

Here is what I got so far:

project in ("projectA","projectB") AND "Clients[Dropdown]" in (common-value 1, common-value 2, common-value 3) AND project = projectA AND issuetype = "issuetype" AND status = Completed AND status changed BEFORE 14d

 

My issue is that I need to populate a value to show that one issue will equal another issue value to be the same from project A to project B.,

1 vote
Answer accepted

Jira's JQL does not have "field 1 = field 2" operators, they're all "field 1 has <value>" type clauses.

To find out if two issues have the same value, you have to read through the results of "field = X" to find out if both issues are on the list.

But you can easily copy field values from one issue to another - have a look at the automation functions and maybe the marketplace for "copy field" functions.

No, I haven't looked yet. I thought I would have to use script runner but in the past I thought I was able to do this without an add-on like script runner. I use script runner in my instance but I am working with a client and trying to configure a Jira automation to capture data to link issues and notify.

I don't need to copy a field value, I just need to know if one fields value equal the same field value in two different issues in two different projects to link them together.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Service Management

Next level incident management in Jira Service Management

Hello Atlassian Community! We’re thrilled to announce some exciting changes to incident management in Jira Service Management Cloud, in order to give your teams extra muscle during incidents, and ...

1,557 views 20 12
Read article

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