| templateType | template |
|---|
| templateOption | {"label":"Use Case livetemplate cloud ready","value":"979936585","templateType":"template"} |
|---|
| templateTypeOption | {"label":"Confluence template/blueprint","value":"template"} |
|---|
| templateId | 979936585 |
|---|
| excerpt | Scenario This recipe shows you how to split page titles containing hyphens into separate values and using them in separate columns of a table. For example, you have many pages and the title of the page has the following format: "Meeting-ID - Meeting-Title" For example: 12345 - Meeting with NASA 23456 - Meeting with Dolby 34567 - Meeting with Atlassian With the use of the Collection Supplier and Text Supplier , you can split the page titles with hyphens to break the Meeting ID and Meeting title into two different columns. Result Recipe Apps Reporting for Confluence Server & Data Center Level Easy Estimated time 10 minutes Macros Content Reporter, Report Column, Report Info, Report Table, Text Sort Suppliers Collection Supplier, Content Supplier, Date Supplier, Text Supplier, User Supplier Storage format You can copy and paste this code into the Confluence Source Editor : <ac:structured-macro ac:macro-id="84217c92-e5d7-4cc7-93da-17ca44bdff03" ac:name="report-table" ac:schema-version="1"> <ac:rich-text-body> <ac:structured-macro ac:macro-id="b097ce96-aeb0-475b-b3ba-6ee46166a4c5" ac:name="content-reporter" ac:schema-version="1"> <ac:parameter ac:name="types">page</ac:parameter> <ac:parameter ac:name="scope">Meeting Notes > Children</ac:parameter> <ac:rich-text-body> <p> <ac:structured-macro ac:macro-id="4ce3d743-c0ef-4a66-a4c5-27ff4e0fec81" ac:name="text-sort" ac:schema-version="1"> <ac:parameter ac:name="">title</ac:parameter> </ac:structured-macro> </p> </ac:rich-text-body> </ac:structured-macro> <ac:structured-macro ac:macro-id="0cf0354e-ac50-4a76-be26-e36beb9dc7b1" ac:name="report-column" ac:schema-version="1"> <ac:parameter ac:name="title">Meeting ID</ac:parameter> <ac:rich-text-body> <p> <ac:structured-macro ac:macro-id="4e836aa8-bf1a-48c8-a17c-940f0f4abb76" ac:name="report-info" ac:schema-version="1"> <ac:parameter ac:name="">content:title > text:split with - > collection:1</ac:parameter> </ac:structured-macro> </p> </ac:rich-text-body> </ac:structured-macro> <ac:structured-macro ac:macro-id="9e28024b-5e39-4503-baa6-f7b3c2e3264f" ac:name="report-column" ac:schema-version="1"> <ac:parameter ac:name="title">Meeting Title</ac:parameter> <ac:rich-text-body> <p> <ac:structured-macro ac:macro-id="ae0a35a2-9633-40ba-8e3f-d203c1ee38b1" ac:name="report-info" ac:schema-version="1"> <ac:parameter ac:name="link">true</ac:parameter> <ac:parameter ac:name="">content:title > text:split with - > collection:2</ac:parameter> </ac:structured-macro> </p> </ac:rich-text-body> </ac:structured-macro> <ac:structured-macro ac:macro-id="814e3d66-e6fa-4249-98a7-5ada0e2d8c42" ac:name="report-column" ac:schema-version="1"> <ac:parameter ac:name="title">Created Date</ac:parameter> <ac:rich-text-body> <p> <ac:structured-macro ac:macro-id="7a3dc562-4c60-409a-8f88-4333e74347a6" ac:name="report-info" ac:schema-version="1"> <ac:parameter ac:name="">content:creation date > yyyy-MM-dd</ac:parameter> </ac:structured-macro> </p> </ac:rich-text-body> </ac:structured-macro> <ac:structured-macro ac:macro-id="94d6cb4e-1ab1-4f03-8c25-b8d884cbcf4d" ac:name="report-column" ac:schema-version="1"> <ac:parameter ac:name="title">Creator</ac:parameter> <ac:rich-text-body> <p> <ac:structured-macro ac:macro-id="3fb0ed4d-62b5-4a13-8b85-e2c5928a80a9" ac:name="report-info" ac:schema-version="1"> <ac:parameter ac:name="">content:creator > full name</ac:parameter> </ac:structured-macro> </p> </ac:rich-text-body> </ac:structured-macro> </ac:rich-text-body> </ac : structured-macro> <p class="auto-cursor-target"> <br /> </p> <p class="auto-cursor-target"> <br /> </p> Macro structure You can recreate the example in the editor view: Steps Create a Report Table macro. Within Report Table macro, create a Content Reporter macro. For Content Reporter macro, set the following parameters: Types : page Scope : Meeting Notes > Children Within Content Reporter macro, create a Text Sort macro and insert " title " in Key parameter. Within Report Table macro, under Content Reporter macro, create four Report Column macro. Set the first Report Column macro's Title to " Meeting ID " and add a Report Info macro within it. Set the Report Info macro's Key to " content:title > text:split with - > collection:1 ". Set the second Report Column macro's Title to " Meeting Title " and add a Report Info macro within it. Set the Report Info macro's Key to " content:title > text:split with - > collection:2 ". Tick Link To Item . Set the third Report Column macro's Title to " Created Date " and add a Report Info macro within it. Set the Report Info macro's Key to " content:creation date > yyyy-MM-dd ". Set the forth Report Column macro's Title to " Creator " and add a Report Info macro within it. Set the Report Info macro's Key to " content:creator > full name ". Line-by-Line Explanation N/A |
|---|
| fieldGroupKeys | {"6aqnjkbqoz":["net.customware.confluence.plugin.scaffolding__6aqnjkbqoz__data_0_tnhhrbla7o"]} |
|---|
|