Looking for JQL or some other method to compare fields

Question

Ok, so we are trying to create a link between two issues with the same content in two projects that contain the data in differently named fields.

We expect to need a JQL query that can search for issues with the same data in both fields, but without knowing the content of those fields (which I do have, but that would be painful to run on all 600 of these issues). We are considering a listener with scriptrunner to complete this. (as opposed to an automation, which may actually be the best bet.) but the JQL is tricky.

We are super open to suggestions

We can get a list of issue that contain data in either field, obviously

project= xxx AND "field" is NOT EMPTY OR project= yyy AND "field2" is NOT EMPTY

Lacking is a way to compare the content of those fields.

Thanks for any help you can provide.

Bill Sheboy · Answer

Thanks for clarifying.  I haven't used scriptrunner for years, so I'd wait a bit to see what other responses you get from the community.

I added the scriptrunner tag to your question to see if that helps.

stsci · Answer

As a further update, we tried

issueFunction in issueFieldMatch("project = XXX" , "field1" ,"ABC-\*") OR issueFunction in issueFieldMatch ("project=yyy", "field2" , "ABC-\*")

which is a fine query but is really meant for comparing fields in the same project...it appears...

stsci · Answer

In truth we would be happy with just performing the search at this point, I can create the links with a scriptrunner script, I just need the query and CANNOT figure it out. This cannot be done with a spreadsheet compare as the data is being imported from another system through a connector.

It's a big one the first time, but after this it would only be newly created issues. (Intial 600 or so issues, after that maybe one or two issues per year? SO the query is most important.