Display Distinct records in column ising reporting plugin
Hi David,
I have wrote a following Code.
{table-plus}
{report-table}
{content-reporter:space=aa|types=page|scope=Example Links List >descendents|labels=idea}
{text-filter:data:subject_area}
{text-sort:content:title\|order=ascending}
{content-reporter}
{report-column:title=Type}{report-info:data:idea_type}{report-column}
{report-table}
{table-plus}
This Only shows the TYPE column.
I wish to show only distinct values in column.
For ed. If I have one entry of Type 'A' And Two Entries OF Type 'B'
Then the report should only display Two rows Not the three Rows.
With Entry of A and B
And Not A, B, B
How to write a code for the distinct entry?
--
With warm Regards
--
Shweta
I have wrote a following Code.
{table-plus}
{report-table}
{content-reporter:space=aa|types=page|scope=Example Links List >descendents|labels=idea}
{text-filter:data:subject_area}
{text-sort:content:title\|order=ascending}
{content-reporter}
{report-column:title=Type}{report-info:data:idea_type}{report-column}
{report-table}
{table-plus}
This Only shows the TYPE column.
I wish to show only distinct values in column.
For ed. If I have one entry of Type 'A' And Two Entries OF Type 'B'
Then the report should only display Two rows Not the three Rows.
With Entry of A and B
And Not A, B, B
How to write a code for the distinct entry?
--
With warm Regards
--
Shweta
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?you may try to use this macro {repeat-filter:prefix:key|match=[first/repeats]}
-
Inappropriate?Hi Shweta,
please try something like this:
{combining-reporter}
{content-reporter:space=aa|types=page|scope=Example Links List >descendents|labels=idea}
{text-sort:data:idea_type > reference:value}
{content-reporter}
{repeat-filter:data:idea_type > reference:value}
{combining-reporter} -
Inappropriate?Thanks Alex.
I will try this -
Inappropriate?{report-table}
{content-reporter:space=@self|types=page|scope=Example Links List >descendents|labels=idea}
{content-reporter}
{repeat-filter:data:subject_area > reference:value}
{report-column:title=Subject}{report-info:data:subject_area > reference:value}
{report-column:title=Type}{report-info:data:idea_type}{report-column}
{report-column}
{report-table}
I have tried this But it shows blank column...
and when I use combining reporter this shows nothing...
I’m frustrated
-
Inappropriate?Hey Alex,
i just need to implement distinct column in my application.
Can you will just have quick view.
I have tried repeat filter in combining reporter but that doesnt works.
I’m sad
-
Inappropriate?Sorry for the late reply.
It is tricky to have the distinct on it. What you need to do is sort the content & filter out the second content. Lets give it a try without the column & sort it by text-sort.
Hope it's help.
Loading Profile...



EMPLOYEE