I need help in retrieving data from a 2nd template.

  • 1
  • Question
  • Updated 2 years ago
  • (Edited)

I have been able to select the pages I would like to filter on  but I am having a problem with filtering to get the data. My wiki administrators have removed the content reporter option so I have to use Local Reporter. I was able to use Content Options to access the page that I would like to filter on, this is what I have. I think I am not getting the data I need because of the local reporter.

This is my Source Data to select the page which works fine:


<ac:macro ac:name="list-data">
                  <ac:parameter ac:name="name">OnBoardname</ac:parameter>
                  <ac:parameter ac:name="atlassian-macro-output-type">BLOCK</ac:parameter>
                  <ac:rich-text-body>
                    <ac:macro ac:name="content-options">
                      <ac:parameter ac:name="limit">101</ac:parameter>
                      <ac:parameter ac:name="spaces">gcsobp</ac:parameter>
                      <ac:parameter ac:name="parent">gcsobp:Product On-Boarding Front Door Request Form</ac:parameter>
                      <ac:parameter ac:name="branches">children</ac:parameter>
                      <ac:rich-text-body>
                        <p> </p>
                      </ac:rich-text-body>


From the 2nd  template I need to pull fields with the data names of: PN

This is what I have from reporting:


<ac:macro ac:name="show-if">
  <ac:parameter ac:name="action">view</ac:parameter>
  <ac:parameter ac:name="atlassian-macro-output-type">BLOCK</ac:parameter>
  <ac:rich-text-body>
    <strong> <span style="color: rgb(0,0,255);"> <strong>Product Details</strong>
      </span> </strong>
    <p> </p>
    <ac:macro ac:name="report-table">
      <ac:rich-text-body>
        <ac:macro ac:name="local-reporter">
          <ac:default-parameter>@self</ac:default-parameter>
          <ac:rich-text-body>
            <p> </p>
          </ac:rich-text-body>
        </ac:macro>
        <ac:macro ac:name="report-column">
          <ac:parameter ac:name="title">Onboarding Product Page</ac:parameter>
          <ac:rich-text-body>
            <p>
              <ac:macro ac:name="report-info">
                <ac:parameter ac:name="link">true</ac:parameter>
                <ac:parameter ac:name="render">richtext</ac:parameter>
                <ac:default-parameter>data:OnBoardname</ac:default-parameter>
              </ac:macro>
            </p>
          </ac:rich-text-body>
        </ac:macro>
        <ac:macro ac:name="report-column">
          <ac:parameter ac:name="title">Product</ac:parameter>
          <ac:parameter ac:name="injected">true</ac:parameter>
          <ac:rich-text-body>
            <ac:macro ac:name="report-block">
              <ac:parameter ac:name="atlassian-macro-output-type">BLOCK</ac:parameter>
              <ac:rich-text-body>
                <ac:macro ac:name="local-reporter">
                  <ac:parameter ac:name="source">gcsobp:Product On-Boarding Front Door Request Form</ac:parameter>
                  <ac:default-parameter>data:PN</ac:default-parameter>
                  <ac:rich-text-body>
                    <p>
                      <ac:macro ac:name="text-filter">
                        <ac:default-parameter>page:title|value=%data:OnBoardname&gt;first%</ac:default-parameter>
                      </ac:macro>
                    </p>



2nd update, I changed the local reporter, and tried to filter the data from the text filter and I still have no results.


I  changed my local reporter and text filter to something closer that I saw, I still have no results in the from the PN data field.


<ac:macro ac:name="report-column">
          <ac:parameter ac:name="title">Product</ac:parameter>
          <ac:parameter ac:name="injected">true</ac:parameter>
          <ac:rich-text-body>
            <ac:macro ac:name="report-block">
              <ac:parameter ac:name="injected">true</ac:parameter>
              <ac:parameter ac:name="atlassian-macro-output-type">BLOCK</ac:parameter>
              <ac:rich-text-body>
                <ac:macro ac:name="local-reporter">
                  <ac:parameter ac:name="source">gcsobp:Product On-Boarding Front Door Request Form</ac:parameter>
                  <ac:default-parameter>page:children</ac:default-parameter>
                  <ac:rich-text-body>
                    <p>
                      <ac:macro ac:name="text-filter">
                        <ac:default-parameter>page:title|value=%data:PN&gt;collection:first%</ac:default-parameter>
                      </ac:macro>
                    </p> <br/>


I feel I am close, I really need to figure this out.

Photo of Martrice Denson

Martrice Denson

  • 112 Posts
  • 1 Reply Like
  • desparate

Posted 3 years ago

  • 1
Photo of Nurhana Ziana Bt. Hanafi

Nurhana Ziana Bt. Hanafi, Employee

  • 3500 Posts
  • 269 Reply Likes
Hello Martrice,

Can you share with us the whole report macros you're working on? Is "OnBoardname" located on the same page as Reporting page? Is "PN" data you need to retrieve from the page selected on "OnBoardname"?

Thanks&Regards,
Ziana
Photo of Martrice Denson

Martrice Denson

  • 112 Posts
  • 1 Reply Like

Yes, OnBoardname field is located on the same page as the reporting page, it is the name of the list data which pulls which pulls the page from the 2nd template. PN is field on the 2nd template and what I am trying to retreive The 2nd template Is located on the child pages of gcsobp:Product On-Boarding Front Door Request Form. The source editor is long, so I am mailing it to you.

Photo of Martrice Denson

Martrice Denson

  • 112 Posts
  • 1 Reply Like

@Nurhana Ziana Bt. Hanafi

Do you have a solution to my question?

Photo of Martrice Denson

Martrice Denson

  • 112 Posts
  • 1 Reply Like

I changed my reporting data, still no results but is seems a little more logical:

\<ac:macro ac:name="report-column">
          <ac:parameter ac:name="title">Product</ac:parameter>
          <ac:parameter ac:name="injected">true</ac:parameter>
          <ac:rich-text-body>
            <ac:macro ac:name="report-block">
              <ac:parameter ac:name="injected">true</ac:parameter>
              <ac:parameter ac:name="atlassian-macro-output-type">BLOCK</ac:parameter>
              <ac:rich-text-body>
                <ac:macro ac:name="local-reporter">
                  <ac:parameter ac:name="source">gcsobp:Product On-Boarding Front Door Request Form</ac:parameter>
                  <ac:default-parameter>page:children</ac:default-parameter>
                  <ac:rich-text-body>
                    <p>
                      <ac:macro ac:name="text-filter">
                        <ac:parameter ac:name="value">%data:PN&gt;collection:first&gt;content:title%</ac:parameter>
                        <ac:default-parameter>data:OnBoardname</ac:default-parameter>
                      </ac:macro>
                    </p> <br/>
                    <p>
                      <code> <br/> </code>
                    </p>
                  </ac:rich-text-body>
                </ac:macro>
                <p> </p>
                <p> </p>
              </ac:rich-text-body>
            </ac:macro>
          </ac:rich-text-body>
        </ac:macro>
        <ac:macro ac:name="report-column">
          <ac:parameter ac:name="title">Description</ac:parameter>
          <ac:parameter ac:name="injected">true</ac:parameter>
          <ac:rich-text-body>
            <ac:macro ac:name="report-block">
              <ac:parameter ac:name="atlassian-macro-output-type">BLOCK</ac:parameter>
              <ac:rich-text-body>
                <ac:macro ac:name="local-reporter">
                  <ac:parameter ac:name="source">gcsobp:Product On-Boarding Front Door Request Form</ac:parameter>
                  <ac:default-parameter>data:children</ac:default-parameter>
                  <ac:rich-text-body>
                    <p>
                      <ac:macro ac:name="text-filter">
                        <ac:parameter ac:name="value">%data:Overview&gt;collection:first&gt;content:title%</ac:parameter>
                        <ac:default-parameter>page:title</ac:default-parameter>
                      </ac:macro>
                    </p> <br/>

Photo of Nurhana Ziana Bt. Hanafi

Nurhana Ziana Bt. Hanafi, Employee

  • 3500 Posts
  • 269 Reply Likes
Hello Martrice,

We would need your full storage format in order to assist. If it is too long, you may email it to supportATservicerocket.com

Thanks&Regards,
Ziana
Photo of Martrice Denson

Martrice Denson

  • 112 Posts
  • 1 Reply Like
I emailed the source code a couple of weeks ago, but I have just emailed it again.