Text filter in Reporting no longer working since upgrade to version 6.1.1

  • 1
  • Problem
  • Updated 3 years ago
  • (Edited)
In all reports that use text-filter in an expanding reporter I get since the last update the message "This macro cannot be used in this context". These reports worked well in previous Reporting versions.
I have many reports that report on Scaffolding table data and that use expanding reporter in a way such as
<Report Table>
   <Expanding Reporter>
     <Local or Content Reporter>
    </Local or Content Reporter>
    <Text Filter/> <!-- Removing this works fine, with it the error is returned -->
  </Expanding Reporter>
...
</Report Table>
Photo of Otto Schindler

Otto Schindler

  • 2 Posts
  • 0 Reply Likes

Posted 3 years ago

  • 1
Photo of thomykay

thomykay

  • 18 Posts
  • 1 Reply Like
Same here. I already opened a ticket through support, hoping to get a fix soon.
Photo of Michael Kulas

Michael Kulas

  • 7 Posts
  • 2 Reply Likes
same here
Photo of Stephen Gramm

Stephen Gramm

  • 154 Posts
  • 6 Reply Likes
We have the same issue in Confluence Data Center 5.8.18.
Photo of Khalid Kader

Khalid Kader

  • 32 Posts
  • 1 Reply Like
Hi everyone,

Thank you for reporting this issue to us.

We can verify this issue is a bug and our development team is currently working on the fix for this issue at the moment.

We will update you once the fix has been completed and released.

As a temporary workaround, we recommend you to revert back the add-on upgrade to a working version.

We apologies for any inconvenience caused

Cheers,
Khalid
Photo of Khalid Kader

Khalid Kader

  • 32 Posts
  • 1 Reply Like
Hi all,

Our developers has fixed the bug and just released the fix in Atlassian Marketplace.

Could you kindly upgrade to the latest version of the Reporting add-on v6.1.2 and check whether the issue has been resolved.

For more information on the release you can head here

Cheers,
Khalid
Photo of Michael Kulas

Michael Kulas

  • 7 Posts
  • 2 Reply Likes
We've just tried the new release but unfortunately the problem is still there :-(
Photo of Azwandi Mohd Aris

Azwandi Mohd Aris, Official Rep

  • 20 Posts
  • 6 Reply Likes
Michael, would you mind to share your storage format here, or contact us at support@servicerocket.com for further investigation?
Photo of Michael Kulas

Michael Kulas

  • 7 Posts
  • 2 Reply Likes
Azwandi, here we go:
<ac:structured-macro ac:name="report-table"><ac:rich-text-body><ac:structured-macro ac:name="local-reporter"><ac:parameter ac:name="source">Ops:Monitor Implementation Catalog (MOIMC)</ac:parameter><ac:parameter ac:name="">value:label _meta_moimc &gt; label:content</ac:parameter><ac:rich-text-body><ac:structured-macro ac:name="and-filter"><ac:rich-text-body><ac:structured-macro ac:name="content-filter"><ac:parameter ac:name="label">+_meta_moimc</ac:parameter></ac:structured-macro> <ac:structured-macro ac:name="text-filter"><ac:parameter ac:name="include">.*SMW.*</ac:parameter><ac:parameter ac:name="">metadata:Service Group</ac:parameter></ac:structured-macro></ac:rich-text-body></ac:structured-macro>
<p><ac:structured-macro ac:name="text-sort"><ac:parameter ac:name="">metadata:ID</ac:parameter></ac:structured-macro></p></ac:rich-text-body></ac:structured-macro><ac:structured-macro ac:name="report-column"><ac:parameter ac:name="title">ID</ac:parameter><ac:rich-text-body>
<p><ac:structured-macro ac:name="report-info"><ac:parameter ac:name="link">true</ac:parameter><ac:parameter ac:name="">title</ac:parameter></ac:structured-macro></p></ac:rich-text-body></ac:structured-macro><ac:structured-macro ac:name="report-column"><ac:parameter ac:name="title">DESCRIPTION</ac:parameter><ac:rich-text-body>
<p><ac:structured-macro ac:name="report-info"><ac:parameter ac:name="render">wiki</ac:parameter><ac:parameter ac:name="">metadata:Description</ac:parameter></ac:structured-macro></p></ac:rich-text-body></ac:structured-macro><ac:structured-macro ac:name="report-column"><ac:parameter ac:name="title">DEV-Support</ac:parameter><ac:rich-text-body>
<p><ac:structured-macro ac:name="report-info"><ac:parameter ac:name="render">wiki</ac:parameter><ac:parameter ac:name="">metadata:DEV-Support</ac:parameter></ac:structured-macro></p></ac:rich-text-body></ac:structured-macro><ac:structured-macro ac:name="report-column"><ac:parameter ac:name="title">Conf-Support</ac:parameter><ac:rich-text-body>
<p><ac:structured-macro ac:name="report-info"><ac:parameter ac:name="render">wiki</ac:parameter><ac:parameter ac:name="">metadata:Conf-Support</ac:parameter></ac:structured-macro></p></ac:rich-text-body></ac:structured-macro></ac:rich-text-body></ac:structured-macro>
This report extracts from labeled meta-data pages. Only those where metadata-field "Service Group" contains string "SMW"  (indicated by include-text filter where ".*SMW.*") .
This report worked fine and works again after downgrade to v6.0.
Let me know if you need more information.
Photo of Khalid Kader

Khalid Kader

  • 32 Posts
  • 1 Reply Like
Hi Michael,

We are currently in the midst of replicating your issue based on the storage format provided. 

We will get back to you soon for further updates.

Cheers,
Khalid
Photo of Khalid Kader

Khalid Kader

  • 32 Posts
  • 1 Reply Like
Hi Michael,

From our investigation the problem that you have reported is associated with and-filter itself.

As when you remove the content and text filters out of the and-filter macro. The results render out fine.

Thank you for sharing the storage format of your report as it has led us to the discovery of this issue.

We are still looking into this issue for the moment and will update you soon

Cheers,
Khalid
Photo of Otto Schindler

Otto Schindler

  • 2 Posts
  • 0 Reply Likes
I installed the latest Reporting release 6.1.2 and the reports are working again. So my problem is solved. Thank you.
Photo of Michael Kulas

Michael Kulas

  • 7 Posts
  • 2 Reply Likes
We've installed latest release 6.1.3 and still face issues.
The below storage format reporting application shows "This macro cannot be used in this context"

<p><ac:structured-macro ac:macro-id="75394d6d-06fb-40b3-adc1-2e6bbaddb0b4" ac:name="report-block" ac:schema-version="1"><ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter><ac:rich-text-body><ac:structured-macro ac:macro-id="1a9daa62-248a-4686-8e12-27804ed736c0" ac:name="local-reporter" ac:schema-version="1"><ac:parameter ac:name="">value:label _meta_opc &gt; label:content </ac:parameter><ac:rich-text-body>&nbsp;</ac:rich-text-body></ac:structured-macro>
<p><ac:structured-macro ac:macro-id="c153a3f6-9fa7-4a6b-9a37-a29a5b93624f" ac:name="text-filter" ac:schema-version="1"><ac:parameter ac:name="include">PENGSUPSYS</ac:parameter><ac:parameter ac:name="">metadata:ID</ac:parameter></ac:structured-macro></p><ac:structured-macro ac:macro-id="37cb2f72-24b8-4103-9f31-4a8eba10499c" ac:name="report-body" ac:schema-version="1"><ac:rich-text-body>
<p><ac:structured-macro ac:macro-id="d947feee-0bb9-4d9c-8d45-9168e0444c0d" ac:name="report-info" ac:schema-version="1"><ac:parameter ac:name="link">true</ac:parameter><ac:parameter ac:name="">page:title</ac:parameter></ac:structured-macro></p></ac:rich-text-body></ac:structured-macro></ac:rich-text-body></ac:structured-macro></p>
The problem again originates in text-filter.
Please have a look.
Photo of Nurhana Ziana Bt. Hanafi

Nurhana Ziana Bt. Hanafi, Employee

  • 3500 Posts
  • 269 Reply Likes
Hello Michael,

I could see that you place {text-filter} macro outside {local-reporter}, kindly please wrap it inside {local-reporter} macro instead. Hope it helps.


Thanks&Regards,
Ziana
Photo of Michael Kulas

Michael Kulas

  • 7 Posts
  • 2 Reply Likes
Hi Ziana.

Indeed there was  an issue with the report because the line 4 of below wiki-markup was missing:
1: {report-block} 
2: {local-reporter:value:label _meta_opc > label:content}
3: {text-filter:metadata:ID|include=PENGSUPSYS}
4: {local-reporter}
5: {report-body}
6: {report-info:page:title|link=true}
7: {report-body}
8: {report-block}
However even after correction neither {wiki-markup} nor {metadata-list} body renders correct but show  "Error occurred while rendering report: null".
Our concrete use-case is {metadata-list} where the body  has to be specified in wiki-markup.
So in fact we still have an issue which cannot be solved without correction of reporting plugin which was working fine before.
Thanks for having a look.
Photo of Nurhana Ziana Bt. Hanafi

Nurhana Ziana Bt. Hanafi, Employee

  • 3500 Posts
  • 269 Reply Likes
Hello Michael,

Do you mean that the report is written in wiki markup? If yes, we confirm this is a bug and estimate to fix it on next sprint.

Thanks&Regards,
Ziana
Photo of Michael Kulas

Michael Kulas

  • 7 Posts
  • 2 Reply Likes
Hi Ziana.

Yes, as explained by the words:
Our concrete use-case is {metadata-list} where the body  has to be specified in wiki-markup.
We run Cinfluence 5.9.7. When do  you plan to release a bugfix ?

Thanks & regards
Michael Kulas
Photo of Nurhana Ziana Bt. Hanafi

Nurhana Ziana Bt. Hanafi, Employee

  • 3500 Posts
  • 269 Reply Likes
Hello Michael,

For "Error occurred while rendering report: null" thrown when Reporting is in wiki markup, we estimate to fix it within 1-2 weeks after we start our next sprint.


Thanks&Regards,
Ziana