Critical Limitation: Jira Rovo fails to navigate Cross-Project Hierarchies and Nested JQL (Initiativ

[sidnei_barcelos]

I am experiencing a significant blocker with Jira Rovo when generating reports that require cross-project hierarchical analysis. Our structure is defined in Jira Plans: Initiatives (EN Project) -> Epics (Multiple Projects) -> Tasks (Multiple Projects).

The issue is twofold:

1. Context Blindness: When Rovo searches for children of an Initiative, it often fails to "see" Epics or Tasks that reside in different Jira projects ( from EN to AB20 or ABC), even though they are correctly linked in the Parent field.

2. JQL Nesting Failure: Rovo struggles to resolve nested JQL functions like childIssuesOf(childIssuesOf(...)). It frequently returns empty results or "syntax errors" when the logic requires jumping two levels down in the hierarchy across multiple boards.

This prevents the Agent from automating weekly metrics, as it cannot consolidate the delivery status of tasks that are technically disconnected from the Initiative's project.

The Prompt used (for reference):

"You are a Jira metrics analyst. Generate the 'Weekly Refactoring Report'.

Hierarchy: Initiative (EN project) → Epic (various projects) → Task (various projects).

Logic required:

1. Identify all Epics where parent is an Initiative in project = EN.

2. For those Epics, identify all Tasks completed in the last 7 days, regardless of the Task's project.

3. Group the completed Tasks by their respective Epic and Initiative.

JQL attempted by the agent: issuekey in childIssuesOf("project = EN AND issuetype = Iniciativa") and subsequent nested calls.

Current Result: The agent returns 0 results or claims it cannot find the issues, despite them being visible in Jira Plans and standard JQL searches."