Loading Profile...
Filtering a report based on whether an item is in another scaffolding list
I have a set of pages in my space with a particular label (user_story), and a table of page titles. I want to show a report of all the pages that are not in the list.
I've tried to do this with the code below, but I get an empty list. If I take out the filter it shows all the pages, so that bit works. All my fiddling is in vain - any ideas, anyone?
If the table was on a different page would this still be feasible?
If there were multiple tables on different pages would this still be feasible?
Bryan
{table-data:UserStories}
|| ID ||
| *{text-data:StoryID}{text-data}* |
{table-data}
{report-table}
{content-reporter:space=@self|label=user_story|type=page}
{text-sort:content:title|order=ascending}
{collection-filter:content:root content > data:UserStories > data.StoryID|matchItems=any|matchFilter=any}
{text-filter:content:title|include=.*}
{collection-filter}
{content-reporter}
{report-column}{report-info:content:title|link=true}{report-column}
{report-table}
I've tried to do this with the code below, but I get an empty list. If I take out the filter it shows all the pages, so that bit works. All my fiddling is in vain - any ideas, anyone?
If the table was on a different page would this still be feasible?
If there were multiple tables on different pages would this still be feasible?
Bryan
{table-data:UserStories}
|| ID ||
| *{text-data:StoryID}{text-data}* |
{table-data}
{report-table}
{content-reporter:space=@self|label=user_story|type=page}
{text-sort:content:title|order=ascending}
{collection-filter:content:root content > data:UserStories > data.StoryID|matchItems=any|matchFilter=any}
{text-filter:content:title|include=.*}
{collection-filter}
{content-reporter}
{report-column}{report-info:content:title|link=true}{report-column}
{report-table}
I’m confused
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?This one's tricky. I think the only way to get this working is to somehow combine your StoryID values into a regular expression and inject it into the report. Something like this might work:
{replace-and-render}
{replace-item:%excluded%}{report-on:data:UserStories|separator=comma}{report-info:data:StoryID}{replace-item}
{replace-body}
{report-table}
{content-reporter:space=@self|label=user_story|type=page}
{text-sort:content:title|order=ascending}
{text-filter:content:title|exclude=%excluded%}
{content-reporter}
{report-column}{report-info:content:title|link=true}{report-column}
{report-table}
{replace-body}
{replace-and-render}
If your page titles include any regular-expression-unfriendly values, you might have issues...
1 person says
this answers the question
-
-
Inappropriate?Slight tweak to syntax (missing closing tag)
{replace-and-render}
{replace-item:%excluded%}{report-on:data:DataUserStories|separator=comma}{report-info:data:StoryID}{report-on}{replace-item}
{replace-body}
{report-table}
{content-reporter:space=@self|label=user_story|type=page}
{text-sort:content:title|order=ascending}
{text-filter:content:title|exclude=%excluded%}
{content-reporter}
{report-column}{report-info:content:title|link=true}{report-column}
{report-table}
{replace-body}
{replace-and-render}
I’m thankful
EMPLOYEE
