reporting-plugin question: Is it possible to get a specific entry when reporting on table-data?

[Justin Shapiro]

I want to create a status log using table-data.

This is what my table looks like:

{table-data:Entries|order=descending}
|| Date || Reporter || Tool || Status || Notes || Attachment || CM ||
| {date-data:DateTime\|format=yyyy-MMM-dd HH:mm}now{date-data} | {list-data:Reporter}{user-options:match=all|default=@self}{user-options}{list-data} | {list-data:Tool\|required=true}{list-option}Bamboo{list-option}{list-option}Confluence{list-option}{list-option}Crucible{list-option}{list-option}Fisheye{list-option}{list-option}Git{list-option}{list-option}IM{list-option}{list-option}JIRA{list-option}{list-option}Nexus{list-option}{list-option}Subversion{list-option}{list-option}Other{list-option}{list-data} | {list-data:Status\|required=true}{list-option:label=Broken}(x){list-option}{list-option:label=Not Sure}(!){list-option}{list-option:Label=Fixed}(/){list-option}{list-data} | {text-data:Notes\|type=area\|width=300px\|height=150px}{text-data} | {attachment-data:Attachment} | {list-data:CM\|required=true}{list-option}New{list-option}{list-option}Investigating{list-option}{list-data}|
{table-data}

I'd like to use the reporting plugin and show just the last entry for a given tool. So I tried something like:

{report-table}

{local-reporter:data:Entries}
{text-filter:data:Tool|include=Bamboo}
{local-reporter}

{report-column:title=Tool}{report-info:data:Tool}{report-column}
{report-column:title=Status}{report-info:data:Status|render=wiki}{report-column}

{report-table}

Is there a way to just show the last entry in the list returned?

[Akeles · Accepted solution]

Hi Justin,

You can use the MaxResults parameter to limit the number of entries to be returned. You might want to include a date-sort too,

http://wiki.customware.net/repository/display/AtlassianPlugins/report-table

[Justin Shapiro]

{report-table}

{report-block:maxResults=1}

{local-reporter:data:Entries}

{text-filter:data:Tool|include=Bamboo}

{date-sort:data:DateTime|order=descending}

{local-reporter}

{report-body:injected=true}

{metadata:Bamboo|hidden=true}%data:Status%{metadata}

{report-body}

{report-empty}

{metadata:Bamboo|hidden=true}(/){metadata}

{report-empty}

{report-block}

{report-table}

[Justin Shapiro]

So, I used this answer in conjunction with the metadata plugin then constructed my summary table.

||Tool||Status||Version||Upgrade Plans||

|Bamboo|{metadata-from:@self|Bamboo}|3.1.1| |