Create a search on Project to filter values linked in another Project

Hi,

I need to create a Dashboard to perform the following action:

1. Find all JiraIds with a Label "ABCD"

2. Find all ZephyrIds linked to the above searched JiraIds in Project "TEST"

3. Get the execution status of the above tests searched for specific Version/Cycle

Practically I have a nested search applied here and I don't see anyway to apply this concept in Jira/Zephyr. Please let me know if anyone has experience in implementing similar requirement.