How can you keep the priority order of a Jira Filter Macro in a pdf export?

[Jack Allen]

I have a bug reporting page set up in Confluence connected to Jira.  I have a column for priority that I can toggle to show highest to lowest which works fine when I'm on the Confluence page, but after ordering the tables on the page and exporting to pdf, the items are not in priority order.  Is there a way to maintain the ordering set on the confluence page so it reflects correctly in the report?

See below from the Confluence page and a Jira issue filter macro.  I've clicked the 'P' to order the priority, showing the highest at the top. (I've removed the summary and names of colleagues)

Below is a screen shot of the pdf export, which as you can see, removes the prioritisation ordering:

Is there a way to keep the priority ordering as intended so that it is shown correctly on my export?

[Jack Allen · Accepted solution]

Figured it out myself! You simply need to add 'Order by Priority DESC' at the end of the query.