Loading Profile...
How do i filter my report on scaffolding list item with wiki links in it?
Hi
I have a little problem with my report on a scaffolding data. I just can't filter when the entry in a scaffolding list is a link to another confluence page. My scaffolding form looks like that:
{list-data:Thema|type=check|multiple=true|separator=newline}
{list-option:one}[pagename1]{list-option}
{list-option:two}[pagename2]{list-option}
{list-data}
My reporter looks like that:
{report-table}
{local-reporter:content:children|type=page}
{content-filter:@self|labels=cons_project}
{collection-filter:data:Thema|matchItems=any}
{text-filter:reference:value|include=\[pagename1\]}
{collection-filter}
{text-sort:content:titel}
{local-reporter}
{report-column:title=Referenzprojekt}{report-info:content:title|link=true}{report-column}
...
{report-table}
I'm quite new to the reporting plugin so maybe it's a very simple problem but i just can't find a way to filter it right.
thx
Sabrina Hock
I have a little problem with my report on a scaffolding data. I just can't filter when the entry in a scaffolding list is a link to another confluence page. My scaffolding form looks like that:
{list-data:Thema|type=check|multiple=true|separator=newline}
{list-option:one}[pagename1]{list-option}
{list-option:two}[pagename2]{list-option}
{list-data}
My reporter looks like that:
{report-table}
{local-reporter:content:children|type=page}
{content-filter:@self|labels=cons_project}
{collection-filter:data:Thema|matchItems=any}
{text-filter:reference:value|include=\[pagename1\]}
{collection-filter}
{text-sort:content:titel}
{local-reporter}
{report-column:title=Referenzprojekt}{report-info:content:title|link=true}{report-column}
...
{report-table}
I'm quite new to the reporting plugin so maybe it's a very simple problem but i just can't find a way to filter it right.
thx
Sabrina Hock
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?Regular expressions are really hard to escape correctly in Confluence, partly due to how Confluence escapes (or in some case, doesn't) characters. Two options to try:
1. Change your '\' characters to a double-slash ('\\').
2. Skip the explicit match on '[' and just use '?', which is 'any single character'. Not as accurate, but often does the job. -
Inappropriate?Hi
Thanks for the really fast answer!
But unfortunatly both doesn't work. If i use
{text-filter:reference:value|include=\\[pagename1\\]}
I got the error message:
Error formatting macro: text-filter: java.util.regex.PatternSyntaxException: Illegal character range near index 9 [pagename1] ^
And with
{text-filter:reference:value|include=?pagename1?}
I got the error message:
Error formatting macro: text-filter: java.util.regex.PatternSyntaxException: Dangling meta character '?' near index 0 ?pagename1? ^
-
Inappropriate?Ok i got it. My filter must look like that:
{text-filter:reference:value|include=.*pagename1.*}
I’m happy
-
Inappropriate?Of course - not sure what I was thinking of with the '?' suggestion - that is essentially '1 or 0 of the previous character', which is not helpful here.
If you just want to match a single character, you can just use '.', with out the '*', but it depends on what you're expecting in the field.
EMPLOYEE
