I need to be able to run a query: Select Stories/Defects from Project B where “assigned” in (List of people from Project A)

Question

How can I get a query in Jira which will return the project members?

The purpose of this query:

I am running Project A, which has some team members.

There is another project – project B, which has stories/defects assigned to some of my team members

I need to be able to run a query:

Select Stories/Defects from Project B where “assigned” in (List of people from Project A)

Nic Brough -Adaptavist- · Answer

That's the problem, there is no function to say "user in role in project X".

(You can do "project where user is in role", but that desn't help you)

syam prasad ram · Answer

we don't have group, but we have the project roles, i want retrieve the issues are assigned to list of team members from project A which are in Project B also.

Nic Brough -Adaptavist- · Answer

Not quite as you've asked, because searches are for finding issues, not people.

But you can get "issues from B where assignee is in a list".  The difficulty in your specification is that you have not said how you identify "people from project A", which you can only really do in JIRA by saying membersOf(group) - not project.