Loading Profile...
How to filter on space and on page
I have one space per project. Each space have a project status page.
I would like to create a report page that shows an excerpt from each status page but filter spaces on a label.
This is doing the excerpt trick but not the space filtering trick...
{report-block}
{content-reporter:spaces=@global|type=page|labels=+status}
{content-reporter}
{report-body}
{report-info:content:excerpt}
{report-body}
{report-block}
Any one can help?
Thanks!
I would like to create a report page that shows an excerpt from each status page but filter spaces on a label.
This is doing the excerpt trick but not the space filtering trick...
{report-block}
{content-reporter:spaces=@global|type=page|labels=+status}
{content-reporter}
{report-body}
{report-info:content:excerpt}
{report-body}
{report-block}
Any one can help?
Thanks!
I’m excited
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?For performance reasons, I'd probably approach this from a different direction. If you have Reporting 3.2.0, you can use the 'Value Supplier' to get the label you want, then filter the contents of that based on space label. Eg:
{local-reporter:value:label status > label:content}
{content-filter:@self|type=page}
{content-filter:content:space|label=space_label}
{local-reporter}
I think that should work. If not, I have a couple of other ideas, let me know. -
Inappropriate?Thanks David, I will try this out this afternoon. Being relatively new to the reporting I am a bit puzzled by your suggestion, I was expecting more code...
Just to clarify, let me throw some pseudo code.
select spaces that matches a specific space label
select pages that matches a specific page label
display page content (using report-info)
done
done
FYI - This following excerpt works but rely entirely on page labels.
{report-block}
{content-reporter:spaces=@global|type=page|labels=+status,+sust}
{content-reporter}
{report-body}h4. {report-info:page:space|link=true}{report-body}
{report-body:title:AsOf}*As of* {report-info:data:AsOf}{report-body}{report-body:title:By} *by* {report-info:data:By}{report-body}{report-body:title:ProjectStatus} *Status* {report-info:data:ProjectStatus}{report-body}
{report-empty}_No project(s) in this stage at this time._{report-empty}
{report-block}
Thanks David, your suggestions are greatly appreciated.
I’m confident
-
Inappropriate?Hi again,
Sorry for the delay in getting back to you on this. My initial code was a suggestion to replace the {content-reporter}. It's kind of going in the reverse direction to your pseudo code. Something like this:
select the page label, and get all content for that label in all spaces
select the content for that label that are pages AND whose space has the required space label
The reason for this is efficiency. If you start by getting all pages from all spaces, you will be starting with a very large data set. If you start by getting only the pages with the specific page label, the starting data set is much smaller. Then, you just have to eliminate the extras we're not interested in, such as non-pages, and pages from other spaces.
The full code, based on your example, would be something like this:
{report-block}
{local-reporter:value:label status > label:content}
{content-filter:@self|type=page}
{content-filter:content:space > space:description|label=space_label}
{local-reporter}
{report-body}h4. {report-info:page:space|link=true}{report-body}
{report-body:title:AsOf}*As of* {report-info:data:AsOf}{report-body}{report-body:title:By} *by* {report-info:data:By}{report-body}{report-body:title:ProjectStatus} *Status* {report-info:data:ProjectStatus}{report-body}
{report-empty}_No project(s) in this stage at this time._{report-empty}
{report-block}
Hope that helps!
EMPLOYEE
