Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

JQL Request - How to get issues from a project based on Custom Field values in another project ?

Hello Community,

I am contacting you today as I'm facing a technical problem and I am wondering what is the best way to deal with it.

Here is my usecase :

  • Users charge (Tempo Worklog) on Project A issues
  • These users are represented on a Custom Field "Team" as "Team1" value on a project B
    • I can't create Jira groups for these users so I need to manage them under Custom Field values

-> I would like to get all issues from Project A that users in "Team1" of Project B have logged work on.

This would give a JQL like this :
project = A AND worklogAuthor in (project = B AND Team = Team1)

Except that it doesn't exist natively on Jira.
I have started to develop a custom JQL but I wonder if there is not a technical solution less complex, and which would be easier to maintain.

If you have ever faced this kind of case, how did you do it ?
Maybe something is doable with a JQL ScriptRunner ?

Thank you in advance for any help :-)

Best regards.

1 answer

Hi @support for vo ,

In case the "Team1" that you are using in the custom field is a Tempo team (as you mention, you are using Tempo to log work), you can use the jql option 

worklogAuthor in team("Team1")

This will give you a list of issues that members of Team1 have at some time logged work on. 

Best regards,
Susane Götz
Tempo team 

Hello Suzanne,

Indeed, it would work if we had Teams created in Tempo but this is is not the case on our instance currently :-(

That's why I'm looking for a way to do a Join between 2 projects on a CF.
Thanks for your quick response anyway !

Best regards.

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events