Using Text-Filter to filter reports based on page name

  • 1
  • Problem
  • Updated 2 years ago
I have multiple page with scaffold reports and it contains a list-data column with content-options listing the page titles of initiatives. On each of the initiative pages will then have a report which I want to filter the results based on the initiative page title.

I have read through quite a few posts and I cant seem to find a solution so would really appreciate any help.

h1. {table-filter:cell-width=150,150|column=Project,Health|datefilter=Due Date|datepattern=yy-mm-dd|default=,,->|id=1466696908317_0|separator=Point (.)}


Here is the List:
{list-data:atlassian-macro-output-type=BLOCK|name=initiative|separator=pipe}\\

{content-options:ancestor=GSA:Alliance Partners|labels=gsap_initiative|limit=99|spaces=GSA}
\\
{content-options}
\\
{list-data}


Here is the Report:

{report-table:injected=true}

{expanding-reporter:data:initiative|as=gsap}
{local-reporter:content:descendants|source=GSA:GSAP Reporting}\\
{local-reporter}
{text-filter:data:initiative>first|include=%page:title%}{expanding-reporter}

{report-column:title=Report}
{report-info:expanded:item > page:title|link=true}{report-column}

{report-column:title=Partner - Initiative}
{report-info:expanded:gsap > data:partner|link=true|render=richtext} *-* {report-info:expanded:gsap > data:initiative|link=true|render=richtext}{report-column}

{report-column:title=Activity}
{report-info:expanded:gsap > data:activity|link=true|render=richtext}{report-column}

{report-column:title=Phase}
{report-info:expanded:gsap > data:phase|link=true|render=wiki}{report-column}

{report-column:title=Health}
{report-info:expanded:gsap > data:health|link=true|render=wiki}{report-column}

{report-column:title=Stakeholders}
{report-info:expanded:gsap > data:stakeholders|link=true|render=wiki}{report-column}

{report-column:title=Target Completion date}
{report-info:expanded:gsap > data:due date|format=dd/MMM/yyyy|link=true|render=wiki}{report-column}

{report-column:title=Consumer Rev Impact}
{report-info:expanded:gsap > data:Consumer|link=true|render=wiki}{report-column}

{report-column:title=Sales Rev Impact}
{report-info:expanded:gsap > data:Sales|link=true|render=wiki}{report-column}

{report-column:title=MBO - Status}
{report-info:expanded:gsap > data:mbo|link=true|render=wiki} *-* {report-info:expanded:gsap > data:mbostatus|link=true|render=wiki}{report-column}

{report-empty}
_No Active Projects created_{report-empty}
{report-table}
{table-filter}

Thanks
Conor
Photo of Con

Con

  • 17 Posts
  • 0 Reply Likes

Posted 2 years ago

  • 1
Photo of Nurhana Ziana Bt. Hanafi

Nurhana Ziana Bt. Hanafi, Employee

  • 3500 Posts
  • 269 Reply Likes
Hello Conor,

I could see that you're using {table-filter} macro from StiltSoft. Can you let us know the version of Confluence and Reporting plugin you're currently using?

Thanks&Regards,
Ziana
Photo of Con

Con

  • 17 Posts
  • 0 Reply Likes
Confluence: 5.7.5
Scaffolding: 8.4.1
Reporting: 6.4.1
Table Filter: 3.3.1
Photo of Con

Con

  • 17 Posts
  • 0 Reply Likes
Hi Folks,
I was wondering if you had any ideas on how I can implement this? no change in trying any of the injected variables in the include field.
  • .*page:title.*
  • .*%page:title%.*
  • %page:title%
  • .*%report:parent>page:title%.*

We have just upgraded to the below:
Scaffolding 8.5.0
Reporting: 6.4.1
Table Filter: 3.6.8

Uninstalled:
RB Filtering - Confluence (org.randombits.filtering.filtering-confluence version 1.2.7)
RB Filtering - Core (org.randombits.filtering.filtering-core version 1.1.0)
RB Storage - Confluence (org.randombits.storage.confluence version 5.4.0)
RB Storage - Core (org.randombits.storage version 5.4.0)
RB Storage - Parameters (org.randombits.storage.param version 5.4.0)
RB Storage - Servlet (org.randombits.storage.servlet version 5.4.0)
RB Supplier - Confluence (org.randombits.supplier.supplier-confluence version 1.2.0)
RB Support - Confluence (org.randombits.support.confluence version 5.3.0)
(Edited)
Photo of Con

Con

  • 17 Posts
  • 0 Reply Likes
I have also tried a workaround which i could live with if you can help me get it working

I added this to the page where I am generating the report:
{text-data:atlassian-macro-output-type=INLINE|name=pagename}
{report-on:atlassian-macro-output-type=INLINE|injected=true}
{report-info:page:title}
{report-on}
{text-data}

Then I used the below in the report on that page to filter.
{text-filter:data:initiative|include=.*%data:pagename%.*}

This doesnt work either.
Photo of Con

Con

  • 17 Posts
  • 0 Reply Likes
Hi Folks,
Do you have any ideas that can help me here?

Conor
Photo of Con

Con

  • 17 Posts
  • 0 Reply Likes
Does this mean you don't have a solution? :(