nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

how can I build a report for value = ?

Jonathan Dingma

So I have metadata on a page, but I'm trying to figure out how I can build a report against a specific value.

ie if the column is "day", and there are values of friday, friday, friday, thursday, wednesday

how can I build a report for all the rows that have day = friday?

Accepted answers

David Peterson

I'm a little hazy on the exact Supplier that Metadata provides, but you should be able to do something like this:

{report-table}

{local-reporter:page:descendents}

{text-filter:metadata:AB|value=AB}

{text-sort:page:title}

{local-reporter}

{report-column:title=Page}{report-info:page:title|link=true}{report-column}

{report-column:title=Application}{report-info:metadata:Application}{report-column}

{report-column:title=Component}{report-info:metadata:Component}{report-column}

etc...

{report-table}

You can add more filters and sort values inside the {local-reporter} to customise your query. If you use Scaffolding data fields instead, you can specify formatting for date and number fields. Just substitute "data:My Field Name" into the above, and provide a 'format' rule to display them. Eg, for creation date it might be:

{report-info:data:Creation Date|format=d MMMM, yyyy}

Which would output something like "29 September, 2011".

Hope that helps!

All comments

Kevin Buchs2

{text-filter:prefix:key|value="friday"} should do the trick for you.

David Peterson

Does depend on how you're storing your metadata (ie. with the Metadata Plugin or the Scaffolding Plugin?) and what you're reporting with. More details of your wiki markup would be helpful...

Jonathan Dingma

I'm actually using both.

I'm using live-template to pull in the live template from the scaffolding plugin and inside the live-template, I'm wrapping the fields with metadata

that way each page with the template that I use, has the metadata

Here is an example of the reporting page I have on the metadata

@{metadata-report:Page,Application,Component,Create Date,Fix Version,Author,Publisher|root=Test Cases|pages=@descendants}

that pulls in the meta data that I'm using for each page. I'm trying to figure out how I can do something like...

Component = AB

David Peterson

I'm a little hazy on the exact Supplier that Metadata provides, but you should be able to do something like this:

{report-table}

{local-reporter:page:descendents}

{text-filter:metadata:AB|value=AB}

{text-sort:page:title}

{local-reporter}

{report-column:title=Page}{report-info:page:title|link=true}{report-column}

{report-column:title=Application}{report-info:metadata:Application}{report-column}

{report-column:title=Component}{report-info:metadata:Component}{report-column}

etc...

{report-table}

{report-info:data:Creation Date|format=d MMMM, yyyy}

Which would output something like "29 September, 2011".

Hope that helps!

Jonathan Dingma

Thanks David

I tested that, and it's returning the actual scaffolding data, not the values I put in.

ie when I specify for Application, it's returning this value:

{text-data:Application2|width=600px|height=50px|type=area}WM, WMPB .. etc etc

Any idea how I can get around that?

David Peterson

I would suggest using the actual 'Application2' value then. That is:

{report-info:data:Application2|render=wiki}

That will return the contents of the Scaffold field, rather than the metadata field which contains the Scaffold {text-data} markup.

Jonathan Dingma

Great! That's one step closer to getting what I need.

Based on using the data: pre-fix, how should I use the text-filter to filter based on that data?

Can I use something like data:Application2|include=WC where the metadata has WC somewhere in the data? (I want to be able to use include rather than just value=)

Thank you David!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

metadata