Inserting specific JQLs into the Jira issues or Jira Charts macro will time out

Issue Summary

Upon using specific JQLs in the Jira chart or the Jira issue macro, it fails due to the following errors:

Jira chart

java.net.SocketTimeoutException: Read timed out 

Jira macros

Received the following HTTP error code from the server:504

Steps to Reproduce

1. Edit or create a new page
2. There, insert the Jira Chart (or Jira) macro with options like the Two Dimensional one.
3. Add a "complex" JQL that would take 10+ seconds to render in Jira. For example:

issue in portfolioChildIssuesOf("ISSUE-KEY") OR issuetype in (Bug) AND status in ("To Do") OR labels in (<TEST>) 

1. Tap Preview/search or wait for the macro to attempt to load the content.

Expected Results

The results should be displayed on the macro's configuration.

Actual Results

The content is not displayed due to a timeout. Generally, results that depend on more than 10s will fail to load.

Workaround

The closest workaround is to use a simple JQL that could retrieve similar results.