Page tree
Skip to end of metadata
Go to start of metadata

Playground and DEMO space

This is a playground and demo space for ConfiForms and ConfiDoc addons developed and supported by Vertuna LLC

Most pages provide a storage format for the demo, so you can use the free add-on from Atlassian Confluence Source Editor to import this configuration into your Confluence and see it in action

Please note, all the examples here are provided without any obligation and may or may not be incomplete or may have bugs, and we provide NO SUPPORT for these examples and demos.


Using the form from Using TableViewMerger to show the data with CONCAT function

Each record joined as new row

Full name

James Bond
test test
First Last
s c
William Furneaux
John Doe
Alfa Betta
Michael Jackson
H h
Michael Jackson
Mister Echo
first Last
John Doe
Julia Roberts

Using the concat of concat (smile)

Full name

James Bond :: joined this in addition ::
test test :: joined this in addition ::
First Last :: joined this in addition ::
s c :: joined this in addition ::
William Furneaux :: joined this in addition ::
John Doe :: joined this in addition ::
Alfa Betta :: joined this in addition ::
Michael Jackson :: joined this in addition ::
H h :: joined this in addition ::
Michael Jackson :: joined this in addition ::
Mister Echo :: joined this in addition ::
first Last :: joined this in addition ::
John Doe :: joined this in addition ::
Julia Roberts :: joined this in addition ::

Code

<p>Using the form from <ac:link>
    <ri:page ri:content-title="Using TableViewMerger to show the data with CONCAT function"/>
  </ac:link>
</p>
<p>Each record joined as new row</p>
<ac:structured-macro ac:macro-id="b7c438b6-6bf9-4953-baed-76c77fb8cd6b" ac:name="confiform-table-merger" ac:schema-version="1">
  <ac:rich-text-body>
    <p>
      <ac:structured-macro ac:macro-id="ad5dee52-915b-4310-9c57-cbeb1e0668c2" ac:name="confiform-field" ac:schema-version="1">
        <ac:parameter ac:name="hideIfEmpty">true</ac:parameter>
        <ac:parameter ac:name="fieldName">id</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="a8bb8c91-011f-49a3-8e89-8d554945612e" ac:name="confiform-field" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">Full name:(CONCAT("[entry.firstName]", " [entry.lastName]"))</ac:parameter>
      </ac:structured-macro>
    </p>
    <ac:structured-macro ac:macro-id="0c05a16b-d903-4bd2-89db-0d161d5d1ee6" ac:name="confiform-table" ac:schema-version="1">
      <ac:parameter ac:name="pageTitle">
        <ac:link>
          <ri:page ri:content-title="Using TableViewMerger to show the data with CONCAT function"/>
        </ac:link>
      </ac:parameter>
      <ac:parameter ac:name="formName">myform</ac:parameter>
      <ac:rich-text-body>
        <p> </p>
        <p> </p>
      </ac:rich-text-body>
    </ac:structured-macro>
  </ac:rich-text-body>
</ac:structured-macro>
<p>Using the concat of concat <ac:emoticon ac:name="smile"/>
</p>
<ac:structured-macro ac:macro-id="f4e76368-f718-4237-b537-92fa92c3d904" ac:name="confiform-table-merger" ac:schema-version="1">
  <ac:rich-text-body>
    <p>
      <ac:structured-macro ac:macro-id="71512dad-02e1-4f8a-bf58-7cfb8a37c862" ac:name="confiform-field" ac:schema-version="1">
        <ac:parameter ac:name="hideIfEmpty">true</ac:parameter>
        <ac:parameter ac:name="fieldName">id</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="1d334e4d-d9b9-4cb4-8d23-deb8ce82e6d3" ac:name="confiform-field" ac:schema-version="1">
        <ac:parameter ac:name="fieldName">Full name:(CONCAT(CONCAT("[entry.firstName]", " [entry.lastName]"), " :: joined this in addition ::"))</ac:parameter>
      </ac:structured-macro>
    </p>
    <ac:structured-macro ac:macro-id="45826284-956a-46e2-ba93-5f5cccb82b53" ac:name="confiform-table" ac:schema-version="1">
      <ac:parameter ac:name="pageTitle">
        <ac:link>
          <ri:page ri:content-title="Using TableViewMerger to show the data with CONCAT function"/>
        </ac:link>
      </ac:parameter>
      <ac:parameter ac:name="formName">myform</ac:parameter>
      <ac:rich-text-body>
        <p> </p>
        <p> </p>
      </ac:rich-text-body>
    </ac:structured-macro>
  </ac:rich-text-body>
</ac:structured-macro>