Loading Profile...
Expanding-Reporter on Table-Data values
Hello,
I have a table-data object named "ConsumedServices" with the following columns, which are defined as {list-data}
||System||Service||Consumer||.
The table is placed on each page of the space Project.
I want to display the values of the column "Service" which correspond with a specific Consumer from the column "Consumer". The report should return a total value for all pages in the space.
I have tried with the following report but got stuck on report-info:expanded:item. I would like to go into the table-data and display the values from the "Service" column, but get no results. The report set seems to be ok since the number of items which I display in the report-footer is correct .
{report-table}
{expanding-reporter:data:ConsumedServices|as=consumer}
{content-reporter:space=PROJ}
{content-reporter}
{text-filter:data:Consumers > reference:value|include=MY CONSUMER}{text-filter}
{expanding-reporter}
{report-column:title=Services}{report-info:expanded:item > data:ConsumedServices > data:Service|render=wiki|link=true}
{report-column}
{report-footer}{report-info:report:item number}{report-footer}
{report-empty}0{report-empty}
{report-table}
Krzysztof Gabruk
I have a table-data object named "ConsumedServices" with the following columns, which are defined as {list-data}
||System||Service||Consumer||.
The table is placed on each page of the space Project.
I want to display the values of the column "Service" which correspond with a specific Consumer from the column "Consumer". The report should return a total value for all pages in the space.
I have tried with the following report but got stuck on report-info:expanded:item. I would like to go into the table-data and display the values from the "Service" column, but get no results. The report set seems to be ok since the number of items which I display in the report-footer is correct .
{report-table}
{expanding-reporter:data:ConsumedServices|as=consumer}
{content-reporter:space=PROJ}
{content-reporter}
{text-filter:data:Consumers > reference:value|include=MY CONSUMER}{text-filter}
{expanding-reporter}
{report-column:title=Services}{report-info:expanded:item > data:ConsumedServices > data:Service|render=wiki|link=true}
{report-column}
{report-footer}{report-info:report:item number}{report-footer}
{report-empty}0{report-empty}
{report-table}
Krzysztof Gabruk
I’m unsure
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?Hello,
I have already managed to find the answer on http://getsatisfaction.com/customware.... :)
i have changed the report-info into {report-column:title=Service}{report-info:expanded:consumer > data:Service|render=wiki|link=true}
Now I can display what I want, the only problem is that the results are not linked to the confluence content, although I have specified the parameters render=wiki|link=true.
Could you help?
Kris
I’m happy
-
Inappropriate?And the next probelm is that the results are not distinct. It can happen that the Service is used by the same Consumer on many pages in the project. How to display distinct values?
Kris
I’m unsure
-
Inappropriate?you may try to use this macro {repeat-filter:prefix:key|match=[first/repeats]}1 Comment
Add a comment
This answers the question
-
Hello,
thanks for the suggestion, I have tried the repeat-filter with the following definitions but without success
{repeat-filter:data:Service|match=first}
or
{repeat-filter:expanded:consumer > data:Service|match=first}
I have tried to put the filter at different places, I mean inside the content-reporter, inside the expanding reporter and also outside of them. Every time I get the full list (not distinct) or 0.
Is there any other way to display the distinct list?
Regards
Kris -
Inappropriate?Hi,
Please try to sort the data then apply for the report-filter.
http://getsatisfaction.com/customware...1 Comment Add a comment
This answers the question
-
Unfortunately I'm not able to sort the results at all. I try with the following
{report-table}
{expanding-reporter:data:ConsumedServices|as=consumer}
{content-reporter:space=PROJ}
{text-sort:expanded:item > page:title|order=ascending}
{content-reporter}
{text-filter:data:System|include=.*ESB.*}{text-filter}
{text-filter:data:Consumers > reference:value|include=.*My System.*}{text-filter}
{expanding-reporter}
{report-column:title=Service}{report-info:expanded:consumer > data:Service|render=wiki|link=true}
{report-column}
{report-column:title=Project}{report-info:expanded:item > page:title|render=wiki|link=true}
{report-column}
{report-empty}0{report-empty}
{report-table}
but the results are not sorted at all.
Instead I have successfully sorted results by means of {table-plus} but the repeat-filter does not work either.
{table-plus:autoNumber=true|sortColumn=1}
{report-table}
{expanding-reporter:data:ConsumedServices|as=consumer}
{content-reporter:space=PROJ}
{text-sort:expanded:item > page:title|order=ascending}
{content-reporter}
{text-filter:data:System|include=.*ESB.*}{text-filter}
{text-filter:data:Consumers > reference:value|include=.*My System.*}{text-filter}
{repeat-filter:expanded:consumer > data:Service|match=first}
{expanding-reporter}
{report-column:title=Service}{report-info:expanded:consumer > data:Service|render=wiki|link=true}
{report-column}
{report-column:title=Project}{report-info:expanded:item > page:title|render=wiki|link=true}
{report-column}
{report-empty}0{report-empty}
{report-table}
{table-plus}
With the combining reporter I also could not get the report I need.
{table-plus:autoNumber=true|sortColumn=1}
{report-table}
{combining-reporter}
{expanding-reporter:data:ConsumedServices|as=consumer}
{content-reporter:space=PROJ}
{text-sort:expanded:item > page:title|order=ascending}
{content-reporter}
{text-filter:data:System|include=.*ESB.*}{text-filter}
{text-filter:data:Consumers > reference:value|include=.*My System.*}{text-filter}
{expanding-reporter}
{content-reporter:space=PROJ}
{repeat-filter:expanded:consumer > data:Service|match=first}
{content-reporter}
{combining-reporter}
{report-column:title=Service}{report-info:expanded:consumer > data:Service|render=wiki|link=true}
{report-column}
{report-column:title=Project}{report-info:expanded:item > page:title|render=wiki|link=true}
{report-column}
{report-empty}0{report-empty}
{report-table}
{table-plus}
Could you help?
Regrads
Kris -
Inappropriate?Hi Kris,
Sorry for the delay in replying. Try this:
{report-table}
{expanding-reporter:data:ConsumedServices|as=consumer}
{content-reporter:space=PROJ}
{text-sort:page:title|order=ascending}
{content-reporter}
{text-filter:data:System|include=.*ESB.*}
{text-filter:data:Consumers > reference:value|include=.*My System.*}
{expanding-reporter}
{report-column:title=Service}{report-info:expanded:consumer > data:Service|render=wiki|link=true}
{report-column}
{report-column:title=Project}{report-info:expanded:item > page:title|render=wiki|link=true}
{report-column}
{report-empty}0{report-empty}
{report-table}
If you can't get that working, could you please post your full wiki markup for the Scaffolding data table? I had to make some assumptions on what your table looked like. For example, if 'Consumers' is a multiple select box, you will need to put a {collection-filter} around your {text-filter} also.
EMPLOYEE
