It's possible to bring a combination of tasks from 2 Projects

[Dyonata Laitener Ramos]

Guys I have this scenario right now.

I have a IDEA project that has Iniciative and Features issue tickets

I have a PAYC project that has as their parent links the IDEA tickets.

What I'm trying to bring in one query is all the tasks on the PAYC project and their parents on the IDEA project, could you help me to do that on JQL?

[John Funk]

Hi Dyonata - Welcome to the Atlassian Community!

Not sure that I am completely following your need, but you can start wit this for your filter:

project in (IDEA, PAYC)  ORDER BY rank asc

[Trudy P Claspill]

Does the IDEA project contain issue that are not parents of issues in the PAYC project?

Do all issues in the PAYC project have a parent specified, and is that parent always an issue in the IDEA project.

How have you established the parent/child link? Are you using generic issue linking functionality, or custom fields, or ...?

I think that Jira does not have built in capabilities to provide the output that you want from a single JQL query, but to be sure I need more details on what issues you are trying to get and if there are issues in either or both of the projects that you would want excluded.

[Dyonata Laitener Ramos]

The epics on PAYC always have a parent on IDEA, but not every IDEA tickets has PAYC childs.