...
Scenario
This recipe shows you how to split page titles containing hyphens into separate values and use them in separate columns of a table.
...
Code Block |
---|
{ "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.
...