nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Aaron Geister

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.

Accepted answers

Joseph Chung Yin

@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.

Nic Brough -Adaptavist-

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.

All comments

Joseph Chung Yin

@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.

Aaron Geister

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?

Aaron Geister

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.,

Nic Brough -Adaptavist-

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.

Aaron Geister

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.

Dimitrios Moschovitis

Did you have any luck with that?

Aaron Geister

No I never had luck with this.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-service-management