Versions Compared

Old Version 13

changes.mady.by.user Elena Amandola

Saved on

compared with

New Version 14

changes.mady.by.user Elena Amandola

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Reverted from v. 10

Scenario

Live template
templateTypetemplate
templateOption{"label":"Recipe Reporting Cloud no-code v2","value":"477335056","templateType":"template"}
templateTypeOption{"label":"Confluence template/blueprint","value":"template"}
templateId477335056
excerptScenario This recipe shows you how to split page titles containing hyphens into separate values and use them in separate columns of a table.

...

You can copy and paste this code into the target Confluence page:

...

{

...

"cql":

...

"type=page

...

and

...

title

...

~

...

\"Meeting\"",

...

"filters":

...

[],

...

"expansions":

...

"content.history",

...

"reportInfos":

...

[

...

{

...

"id":

...

"2a699b1b-899f-4021-9b6e-9da7af1248e8",

...

"type":

...

"text",

...

"title":

...

"Meeting

...

ID",

...

"value":

...

"content.id",

...

"template":

...

"{\"version\":1,\"type\":\"doc\",\"content\":[{\"type\":\"paragraph\",\"content\":[{\"type\":\"text\",\"text\":\"{%

...

assign

...

temp

...

=

...

content.title

...

|

...

split:

...

'

...

-

...

'

...

%}

...

{{

...

temp[0]

...

}}\"}]}]}"

...

},

...

{

...

"id":

...

"850c5abf-41a3-4a22-8562-b4cd39033f10",

...

"type":

...

"text",

...

"title":

...

"Meeting

...

Title",

...

"value":

...

"content.id",

...

"template":

...

"{\"version\":1,\"type\":\"doc\",\"content\":[{\"type\":\"paragraph\",\"content\":[{\"type\":\"text\",\"text\":\"{%

...

assign

...

temp

...

=

...

content.title

...

|

...

split:

...

'

...

-

...

'

...

%}

...

{{

...

temp[1]

...

}}\"}]}]}"

...

},

...

{

...

"id":

...

"d21fa09b-811f-4fe0-98a5-0ef5545e1361",

...

"type":

...

"text",

...

"title":

...

"Created

...

Date",

...

"value":

...

"content.id",

...

"template":

...

"{\"version\":1,\"type\":\"doc\",\"content\":[{\"type\":\"paragraph\",\"content\":[{\"type\":\"text\",\"text\":\"{%

...

assign

...

temp

...

=

...

content.history.createdDate

...

|

...

split:

...

'T'

...

%}

...

{{

...

temp[0]

...

}}\"}]}]}"

...

},

...

{

...

"id":

...

"1cca57bb-7258-4a36-b6c2-f1a4828a64a5",

...

"type":

...

"basic",

...

"title":

...

"Creator",

...

"value":

...

"content.history.createdBy.displayName",

...

"template":

...

"{\"type\":\"doc\",\"version\":1,\"content\":[{\"type\":\"paragraph\",\"content\":[{\"type\":\"text\",\"text\":\"{{

...

content.history.createdBy.displayName

...

}}\"}]}]}"

...

}

...

]

...

}

...

Result

...

Recipe

...

Apps

...

Reporting for Confluence Cloud

...

Level

...

Intermediate

...

Estimated time

...

20 minutes

...

Notes

...

This recipe is now part of Reporting's built-in templates. You can easily load it into your page by using the templates feature .

...

By default, the report is limited to 200 results. Enable Get all results below the search box if you need to view more results.

...

Caveats

...

Hyperlinking is not yet implemented - may be implemented in future

...

Relies on Liquid split function to convert ISO 8601 date time to “YYYY-dd-mm” format

Image Removed

...

Copyright © 2023

...

fieldGroupKeys{"nygh5im311":["net.customware.confluence.plugin.scaffolding__nygh5im311__data_0_x8zrw46zxx"]}