We make heavy use of page properties report for summarizing issue related information on a helpful problem management dashboard that guides our operation. The structure is:
- A root page, with a page properties report macro searching for pages the a problem tag.
- A set of subpages, each describing a problem. Those pages are labeled with the problem tag.
As expected those subpages contain a table inside a page properties macro, and those are the values we display at the report. One of those fields, has as its value a Jira Item Macro - set to display only a counter of the issues found by a given JQL (ex: 70 issues).
Here is my problem: i can display that value easily at the Page Properties Report, but i can't order the table by it. The page properties display the value AS-IS and since it isn't entirely a number (composed of <issue count> <pluralized "issue">) i can understand why ordering by this field does not work. Does any one know a way to make this work (other macros, or configurations i could use)?