Community
Q&A
Jira
Questions
Show Results of one project by filtering by values of two projects

Show Results of one project by filtering by values of two projects

So here is the deal:

I have one project for all our Tickets (JSM) and a second one where the status and equipment of all employees is tracked.

Lets call them project "TASKS" and project "EMP"

One status shows when somebody is on vacation.

I now want to do the following and wanted to ask, if there is any possibility.

I want to create a JQL that shows all tickets of the colleague who is on vacation in the project TASKS depending on if he is on status "Vacation" in the project "EMP".

is this possible without linking the tickets?

Deployment Type DATA CENTER, NOT CLOUD!

Lukas

1 answer

1 accepted

2 votes

Answer accepted

Hello and Welcome to Atlassian Community @Lukas Langer

Native without Scriptrunner and Advanced JQL nope thats limitation Show Results of one project by filtering by values...

You need some redisign, for Example Create Group on Vacation and then MembersOf

How is the employee represented on the EMP issue?

Workaround depends on your needs.

Best,

Arek🤠

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hy Arek!

Every Employee is represented by a ticket, a Task.
The team is the epic he belongs to.

I thought, that there is no native way.

In this case I will just create an automation, that links the TASKS-Ticket to the EMP-Employee-Ticket.

And the I will check, if the linked ticket is in status "Vacation".

When the TASKS-Ticket is finished the link will be deleted.

Thank you!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • Arkadiusz Wroblewski likes this

There's no need for thanks. We're here to help each other🤠. Yes, that's one of the way to solve this.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

We're moving! The community forums are migrating to a new platform on September 22. Learn more

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

Show Results of one project by filtering by values of two projects

1 answer

1 accepted

Suggest an answer

Was this helpful?

Thanks!

DEPLOYMENT TYPE

TAGS

Community showcase

Atlassian Community Events