How do you sort each collection in a set of collections that is returned by a report?
I am using the reporting plugin to return all of the pages within a space that have a particular label. I am using the space-reporter to return the labels, and then filtering on the label that I want to give a collection of content, and then displaying the results.
I want to sort the returned content by modification date using the date-sort macro, but I cannot work out how to do this inside the report structure.
Here is my code as it stands:
{report-block}
{space-reporter:space=myspace}
{text-sort:space:name}
{space-reporter}
{report-body}
{report-table}
{local-reporter:space:labels in content}
{text-filter:label:title|include=mylabel}
{local-reporter}
{report-column:title=label = mylabel}
{report-on:label:content|separator=newline}{report-info:content:title|link=true}
* Created by {report-info:content:creator} on {report-info:content:creation date|format = dd MMM yyyy}
* Last Modified by {report-info:content:modifier}{report-info:content:modification date|format = dd MMM yyyy}
* Excerpt: {report-info:content:excerpt}
{report-on}
{report-column}
{report-table}
{report-body}
{report-block}
I would greatly appreciate any help with this.
Thank you.
I want to sort the returned content by modification date using the date-sort macro, but I cannot work out how to do this inside the report structure.
Here is my code as it stands:
{report-block}
{space-reporter:space=myspace}
{text-sort:space:name}
{space-reporter}
{report-body}
{report-table}
{local-reporter:space:labels in content}
{text-filter:label:title|include=mylabel}
{local-reporter}
{report-column:title=label = mylabel}
{report-on:label:content|separator=newline}{report-info:content:title|link=true}
* Created by {report-info:content:creator} on {report-info:content:creation date|format = dd MMM yyyy}
* Last Modified by {report-info:content:modifier}{report-info:content:modification date|format = dd MMM yyyy}
* Excerpt: {report-info:content:excerpt}
{report-on}
{report-column}
{report-table}
{report-body}
{report-block}
I would greatly appreciate any help with this.
Thank you.
1
person has this question
I have this question, too!
Tell me when someone answers.
The more people who ask this question, the more it gets noticed.
The more people who ask this question, the more it gets noticed.
-
Inappropriate?If you're using Confluence 3, a simpler way to do this is with the 'value' supplier. Something like this:
{report-table}
{local-reporter:value:label mylabel > label:content}
{content-filter:@self|space=myspace|type=page}
{local-reporter}
{report-column:title=Page}{report-info:page:title|link=true}{report-column}
{report-column:title=Created by}{report-info:content:creator|link=true} on {report-info:content:creation date|format = dd MMM yyyy}{report-column}
{report-column:title=Last Modified}By {report-info:content:modifier|link=true}{report-info:content:modification date|format = dd MMM yyyy}{report-column}
{report-column:title=Excerpt}{report-info:content:excerpt|render=wiki} {report-column}
{report-table}
-
Inappropriate?Thank you for your reply, unfortunately it doesn't work - it returns 0 entries :(
-
Try removing the filter initially, to see if that's the issue. If all pages show up again, try fiddling with the filter to see what breaks it. -
Inappropriate?No, it does not work without the filter, either.
I'm working in Confluence version 3.0.0_01. -
Inappropriate?Regardless, my original question remains; how do I sort the contents of a collection?
-
Inappropriate?We have just installed the latest version of the reporting plugin and it all just works now.
I’m happy
Loading Profile...



EMPLOYEE