{table-data}
Plugin: Scaffolding Plugin
Allows dynamic addition and deletion of rows in a table.
Description
Any standard data macros other than {table-data} itself can be used inside its cells.
Usage
Parameters
| Name |
Required |
Default |
Description |
| [default]/name | | | The name of the table. Must be unique to the scaffold. |
| initialRows | | | The number of rows to have in the section initially. Saves us from having to hit '+' repeatedly. |
| order | | ascending | If set to 'descending', the content will be sorted in in reverse order, and new rows will be added to the top of the repeating section. |
Notes
Due to the simplistic parser currently being used, you need to be careful with how you format the table. The main requirement is that any '|' characters which mark a table boundary must have whitespace on either side. Conversely, any other '|' characters must not have any whitespace around them. For example, in the markup below there are two errors:
- The Number column does not have any whitespace around the '|' markers
- The Date column does have whitespace inside the macro
{table-data:My Table}
|| Text||\Number ||Date||
| {text-data:Text}|{number-data:Number}0{number-data}|{date-data:Date| format=dd-MMM-yyyy} |
{table-data}
Correct formatting would look like this:
{table-data:My Table}
|| Text || Number || Date ||
| {text-data:Text} | {number-data:Number}0{number-data} | {date-data:Date|format=dd-MMM-yyyy} |
{table-data}
Recipes
See Also
Hi,
I am using table-data macro inside a live template. One of the table columns has a list-data macro that has a required=true and user-options parameters
When you add a row for the first time, fill up the said table column with the user from the selection list and save it, you will get an error saying the value (ie the user name) is required. When you go back and save the page again, it will accept the addition.
In addition, your entries on the other fields on that row will also be lost.
Overall I think the table-data macro is a bit unstable. But it such a very nice feature I really want to make it work.
Hope you can help. Thanks.
Mel
{hidden-data} {note:title=Vendor Company Notes} * TYPE: Live template * USED BY: Vendor Company Page {note} {hidden-data} h1. Notes {section} {column:width=80%} {table-data:Vendor Notes} || Contributor/Owner || Item || Type || Date || Remarks || | {list-data:Vendor Note Owner|required=true}{user-options}{list-data} | {text-data:Vendor Note Item|width=300px}{text-data} | {list-data:Vendor Note Type|type=check}{list-option}(x){list-option}{list-option}:){list-option}{list-option}(/){list-option}{list-option}(i){list-option}{list-option}(on){list-option}{list-data} | {date-data:Vendor Note Date|format=dd-MMMM-yyyy|minYear=2005} | {text-data:Vendor Note Remarks|type=area|width=600px|height=5em}{text-data} | {table-data} {column} {column:width=20%} {panel:title=Type|borderStyle=none} | Task, Not Started | (x) | | Task, On Going | :) | | Task, Completed | (/) | | Information | (i) | | Idea | (on) | {panel} {column} {section}Are you by any chance using Internet Explorer? There are several known issues with tables in IE. We will be working on them, but in the meantime you may enjoy more success with FireFox...
Hi
Thanks for this. I have no problem with FF but I guess I need to cater for the other users who use IE mostly. I will await your fixes on the IE.
Another problem with table-data:
Hope you can help on this one
Cheers,
Mel
Hi
Just to add to what I posted earlier
The scenario I describe is such that number-data defaults to 0 to ensure that there is a value to the field. However when you save it and go back to edit it, the field becomes uneditable
I tried using the required=true option and same thing, it wouldnt accept the default 0 value saying "null" is not allowed. Worse is I tried entering a number greater than zero and it still says the field is null and ask you to enter a number
Hi Mel,
Thanks for the information. Could you add the details of your issues here, so that they will be taken into consideration when we actually fix the issue? Thanks.
done in SCAFF-90
thanks
Can we use Content-options inside a table-data tag?
thanks
Sure. Just use it inside a {list-data} macro as per usual. Eg:
{table-data:Table} || Page || | {list-data:Page} {content-options:scope=@self > children} {list-data} | {table-data}Thank you.
So is there a way that the table data macro can allow dynamic deletion of columns instead of rows? I have put two separate pieces of data in a table. But these pieces of data are not related but for organization purpose we put them there I want someone to be able to delete Org677 without deleting or222. But this is not possible? Yet?
No, tables only allow deletion of rows. Deletion of columns is not likely to happen any time soon, if at all...
Is there a way to pre-populate data in more that just for first row? I'm trying to create a list of items, sort of like a checklist. The user will add and change information in each row, and should also be able to delete pre-existing rows as well as create new rows. Something like this:
{table-data:Name}
|| Item || Due Date ||
| {text-data:Data1}Checklist Item 1{text-data} | {data-data:DateData1}{date-data} |
| {text-data:Data2}Checklist Item 2{text-data} | {data-data:DateData2}{date-data} |
| {text-data:Data3}Checklist Item 3{text-data} | {data-data:DateData3}{date-data} |
{table-data}
Thanks!
Shawn
Not presently, I'm afraid. If it's something you'd like to see in a future version, the best idea is to raise a feature request.
Thank You!
http://jira.adaptavist.com/browse/SCAFF-153
Is there a way to copy the table and the content of the table from one page to another page?
Where is the content stored in conflence?
Not easily. If you have access to the database, details are here.
Is there a way to make the border white?
Also, when I export to pdf, all the columns become the same width. is there a way to set the column width?
Thanks!
Hi all,
Does someone knows if there is a way to tag a table-data as required?
Thanks
Not really at present. I guess the way to do that would be to add a 'minimumRows' parameter which would force the specified number of rows before it will save. If you'd like to see such a feature in a future version, please create a feature request.
Hi,
Do you mean 'initialRows'? How do you use it?
Thanks again
Hi david,
Is there anyway to access data in a table-data? Specifically, I was wondering if I could get a list of values in a column or row.
not very imaginitive, but I tried
{get-data:table-data-name.1} to get a row {get-data:table-data-name.column-name} to get a column.I feel like this is a RTFM type question, but I can't seem to find anything on it.
Thanks!
The Reporting Plugin will serve you better here. Something like:
{report-table} {local-reporter:data:table-data-name} {report-column:title=Column Name}{report-info:data:column name}{report-column} {report-table}Is there any way of sorting data within a table?
Not directly. You can use the {table-plus} macro from Bob Swift's Table plugin to wrap some JavaScript sorting around it, but I'm not sure if that has any side-effects when manipulating data.
Hi
A page that has been working fine has suddenly started coming up with an error [ TypeError: $("heartbeatDiv").style has no properties ] when editing the page or adding a row to the report-table.
Any ideas?
Thanks
Jon
{composition-setup} cloak.toggle.type = default cloak.memory.duration = 7 deck.tab.spacer=1 {composition-setup} {workflow-include} {add-label:to_be_processed} h2.Expenses Form {table} {tr} {td} ||Report Date|| |{date-data:ReportDate|format=dd/MM/yyyy|width=240px|required=true}today{date-data}| {td} {td} ||Employee|{list-data:Employee|width=240px|required=true} {user-options:groups=employees} {list-data}| ||Manager|{list-data:Manager|width=240px|required=true} {user-options:groups=managers} {list-data}| {td} {td} ||Expense Period||From||To|| || |{date-data:PeriodStart|format=dd/MM/yyyy|width=240px}today{date-data}|{date-data:PeriodEnd|format=dd/MM/yyyy}today{date-data}| {td} {td} ||Authorisation Status || |{report-block} {local-reporter:content:labels|label=authorised|matchAll=true} {text-filter:label:title|include=authorised} {local-reporter} {report-body} {set-data:Status}(/) Authorised{set-data} {report-body} {report-empty}{set-data:Status}(x) Not Authorised{set-data}{report-empty} {report-block} | {td} {tr} {table} h2. General Expenses {hidden-data} {table-data:GeneralExpenses} ||Date||Work/Task Order Number||Description||Category||Currency||ExchangeRate||Total Amount||VAT Rate||VAT Amount GBP||Total Amount GBP||Net Amount GBP|| Attachment || | {date-data:Itemdate|format=dd/MM/yyyy}today{date-data} | {text-data:TaskOrder|width=40px}1{text-data} | {text-data:Description|width=100px} | {list-data:Category|type=select|width=240px} {list-option}6003 Rechargeable Expenses - Travel{list-option} {list-option}6003 Rechargeable Expenses - Hotel{list-option} {list-option}6003 Rechargeable Expenses - Subsistence{list-option} {list-option}6003 Rechargeable Expenses - Other{list-option} {list-option}7400 UK Travel{list-option} {list-option}7401 Car Hire{list-option} {list-option}7402 Hotels{list-option} {list-option}7403 UK Entertainment{list-option} {list-option}7404 Overseas Entertainment{list-option} {list-option}7405 Overseas Travel{list-option} {list-option}7406 Subsistence{list-option} {list-option}7502 Phones & Internet{list-option} {list-option}7506 Other expenses{list-option} {list-data} | {list-data:Currency|type=select|width=100px} {list-option}GBP{list-option} {list-option}USD{list-option} {list-option}EUR{list-option} {list-option}JPY{list-option} {list-option}ZAR{list-option} {list-option}NOK{list-option} {list-option}CHF{list-option} {list-data} | {number-data:FXRate|decimal=true|format=##,##0.0000|min-value=0|width=60px}1.0000{number-data} | {number-data:TotalAmount|decimal=true|format=##,##0.00|min-value=0|width=60px}0.00{number-data} | {number-data:VATRate|decimal=true|format=##,##0.00|min-value=0|width=60px}17.5{number-data}% | {eval-data:VATAmount|format=£ ##,##0.00|type=number} (${TotalAmount} / ${FXRate}) - ( (${TotalAmount} / ${FXRate})/(1+(${VATRate}/100 ))){eval-data} | {eval-data:RowCost|format=£ ##,##0.00|type=number} ${TotalAmount} / ${FXRate} {eval-data} | {eval-data:NetOfVat|format=£ ##,##0.00|type=number} ((${TotalAmount} / ${FXRate})/(1+(${VATRate}/100 ))){eval-data} | {attachment-data:Attach} | {table-data} *Summary* ||VAT|{eval-data:VATTotal|format=£ ##,##0.00} sumtable("GeneralExpenses", "VATAmount") {eval-data} ||Total|{eval-data:CostTotal|format=£ ##,##0.00} sumtable("GeneralExpenses", "RowCost") {eval-data}| {hidden-data} {deck:id=Summaries|width=1015} {card:label=All Items} {report-table} {local-reporter:data:GeneralExpenses} {local-reporter} {report-column:title=Itemdate}{report-info:data:Itemdate|format=dd/MM/yyyy}{report-column} {report-column:title=Work/Task Order Number|width=40px}{report-info:data:TaskOrder}{report-column} {report-column:title=Category|width=220px}{report-info:data:Category}{report-column} {report-column:title=Description|summaryContent=Total|width=150px}{report-info:data:Description}{report-column} {report-column:title=Currency|width=60px}{report-info:data:Currency}{report-column} {report-column:title=Exchange Rate|width=60px}{report-info:data:FXRate|format=##,##0.0000}{report-column} {report-column:title=Total Amount|width=60px}{report-info:data:TotalAmount|format=##,##0.00}{report-column} {report-column:title=VAT Rate|width=60px}{report-info:data:VATRate|format=##,##0.00} %{report-column} {report-column:title=VAT Amount GBP|width=80px| summaryType=sum| summaryFormat=#,##0.00}{report-info:data:VATAmount|format= ##,##0.00|type=number}{report-column} {report-column:title=Net Amount GBP|width=80px| summaryType=sum| summaryFormat=#,##0.00}{report-info:data:NetOfVat|format= ##,##0.00|type=number}{report-column} {report-column:title=Total Amount GBP|width=80px| summaryType=sum| summaryFormat=#,##0.00}{report-info:data:RowCost|format= ##,##0.00|type=number}{report-column} {report-column:title=Attachment|width=100}{report-link:data:Attach > reference:value > content:download path}{report-info:data:Attach}{report-link}{report-column} {report-table} {card} {card:label=Rechargeable Expenses} {report-table} {local-reporter:data:GeneralExpenses} {text-filter:data:Category| include=6003 Rechargeable Expenses.*} {local-reporter} {report-column:title=Itemdate}{report-info:data:Itemdate|format=dd/MM/yyyy}{report-column} {report-column:title=Work/Task Order Number|width=40px}{report-info:data:TaskOrder}{report-column} {report-column:title=Category|width=220px}{report-info:data:Category}{report-column} {report-column:title=Description|summaryContent=Total|width=150px}{report-info:data:Description}{report-column} {report-column:title=Currency|width=60px}{report-info:data:Currency}{report-column} {report-column:title=Exchange Rate|width=60px}{report-info:data:FXRate|format=##,##0.0000}{report-column} {report-column:title=Total Amount|width=60px}{report-info:data:TotalAmount|format=##,##0.00}{report-column} {report-column:title=VAT Rate|width=60px}{report-info:data:VATRate|format=##,##0.00} %{report-column} {report-column:title=VAT Amount GBP|width=80px| summaryType=sum| summaryFormat=#,##0.00}{report-info:data:VATAmount|format= ##,##0.00|type=number}{report-column} {report-column:title=Net Amount GBP|width=80px| summaryType=sum| summaryFormat=#,##0.00}{report-info:data:NetOfVat|format= ##,##0.00|type=number}{report-column} {report-column:title=Total Amount GBP|width=80px| summaryType=sum| summaryFormat=#,##0.00}{report-info:data:RowCost|format= ##,##0.00|type=number}{report-column} {report-column:title=Attachment|width=100}{report-link:data:Attach > reference:value > content:download path}{report-info:data:Attach}{report-link}{report-column} {report-table} {card} {card:label=UK Travel} {report-table} {local-reporter:data:GeneralExpenses} {text-filter:data:Category| include=7400 UK Travel} {local-reporter} {report-column:title=Itemdate}{report-info:data:Itemdate|format=dd/MM/yyyy}{report-column} {report-column:title=Work/Task Order Number|width=40px}{report-info:data:TaskOrder}{report-column} {report-column:title=Category|width=220px}{report-info:data:Category}{report-column} {report-column:title=Description|summaryContent=Total|width=150px}{report-info:data:Description}{report-column} {report-column:title=Currency|width=60px}{report-info:data:Currency}{report-column} {report-column:title=Exchange Rate|width=60px}{report-info:data:FXRate|format=##,##0.0000}{report-column} {report-column:title=Total Amount|width=60px}{report-info:data:TotalAmount|format=##,##0.00}{report-column} {report-column:title=VAT Rate|width=60px}{report-info:data:VATRate|format=##,##0.00} %{report-column} {report-column:title=VAT Amount GBP|width=80px| summaryType=sum| summaryFormat=#,##0.00}{report-info:data:VATAmount|format= ##,##0.00|type=number}{report-column} {report-column:title=Net Amount GBP|width=80px| summaryType=sum| summaryFormat=#,##0.00}{report-info:data:NetOfVat|format= ##,##0.00|type=number}{report-column} {report-column:title=Total Amount GBP|width=80px| summaryType=sum| summaryFormat=#,##0.00}{report-info:data:RowCost|format= ##,##0.00|type=number}{report-column} {report-column:title=Attachment|width=100}{report-link:data:Attach > reference:value > content:download path}{report-info:data:Attach}{report-link}{report-column} {report-table} {card} {card:label=Car Hire} {report-table} {local-reporter:data:GeneralExpenses} {text-filter:data:Category| include=7401 Car Hire} {local-reporter} {report-column:title=Itemdate}{report-info:data:Itemdate|format=dd/MM/yyyy}{report-column} {report-column:title=Work/Task Order Number|width=40px}{report-info:data:TaskOrder}{report-column} {report-column:title=Category|width=220px}{report-info:data:Category}{report-column} {report-column:title=Description|summaryContent=Total|width=150px}{report-info:data:Description}{report-column} {report-column:title=Currency|width=60px}{report-info:data:Currency}{report-column} {report-column:title=Exchange Rate|width=60px}{report-info:data:FXRate|format=##,##0.0000}{report-column} {report-column:title=Total Amount|width=60px}{report-info:data:TotalAmount|format=##,##0.00}{report-column} {report-column:title=VAT Rate|width=60px}{report-info:data:VATRate|format=##,##0.00} %{report-column} {report-column:title=VAT Amount GBP|width=80px| summaryType=sum| summaryFormat=#,##0.00}{report-info:data:VATAmount|format= ##,##0.00|type=number}{report-column} {report-column:title=Net Amount GBP|width=80px| summaryType=sum| summaryFormat=#,##0.00}{report-info:data:NetOfVat|format= ##,##0.00|type=number}{report-column} {report-column:title=Total Amount GBP|width=80px| summaryType=sum| summaryFormat=#,##0.00}{report-info:data:RowCost|format= ##,##0.00|type=number}{report-column} {report-column:title=Attachment|width=100}{report-link:data:Attach > reference:value > content:download path}{report-info:data:Attach}{report-link}{report-column} {report-table} {card} {card:label=Hotels} {report-table} {local-reporter:data:GeneralExpenses} {text-filter:data:Category| include=7402 Hotels} {local-reporter} {report-column:title=Itemdate}{report-info:data:Itemdate|format=dd/MM/yyyy}{report-column} {report-column:title=Work/Task Order Number|width=40px}{report-info:data:TaskOrder}{report-column} {report-column:title=Category|width=220px}{report-info:data:Category}{report-column} {report-column:title=Description|summaryContent=Total|width=150px}{report-info:data:Description}{report-column} {report-column:title=Currency|width=60px}{report-info:data:Currency}{report-column} {report-column:title=Exchange Rate|width=60px}{report-info:data:FXRate|format=##,##0.0000}{report-column} {report-column:title=Total Amount|width=60px}{report-info:data:TotalAmount|format=##,##0.00}{report-column} {report-column:title=VAT Rate|width=60px}{report-info:data:VATRate|format=##,##0.00} %{report-column} {report-column:title=VAT Amount GBP|width=80px| summaryType=sum| summaryFormat=#,##0.00}{report-info:data:VATAmount|format= ##,##0.00|type=number}{report-column} {report-column:title=Net Amount GBP|width=80px| summaryType=sum| summaryFormat=#,##0.00}{report-info:data:NetOfVat|format= ##,##0.00|type=number}{report-column} {report-column:title=Total Amount GBP|width=80px| summaryType=sum| summaryFormat=#,##0.00}{report-info:data:RowCost|format= ##,##0.00|type=number}{report-column} {report-column:title=Attachment|width=100}{report-link:data:Attach > reference:value > content:download path}{report-info:data:Attach}{report-link}{report-column} {report-table} {card} {card:label=UK Entertainment} {report-table} {local-reporter:data:GeneralExpenses} {text-filter:data:Category| include=7403 UK Entertainment} {local-reporter} {report-column:title=Itemdate}{report-info:data:Itemdate|format=dd/MM/yyyy}{report-column} {report-column:title=Work/Task Order Number|width=40px}{report-info:data:TaskOrder}{report-column} {report-column:title=Category|width=220px}{report-info:data:Category}{report-column} {report-column:title=Description|summaryContent=Total|width=150px}{report-info:data:Description}{report-column} {report-column:title=Currency|width=60px}{report-info:data:Currency}{report-column} {report-column:title=Exchange Rate|width=60px}{report-info:data:FXRate|format=##,##0.0000}{report-column} {report-column:title=Total Amount|width=60px}{report-info:data:TotalAmount|format=##,##0.00}{report-column} {report-column:title=VAT Rate|width=60px}{report-info:data:VATRate|format=##,##0.00} %{report-column} {report-column:title=VAT Amount GBP|width=80px| summaryType=sum| summaryFormat=#,##0.00}{report-info:data:VATAmount|format= ##,##0.00|type=number}{report-column} {report-column:title=Net Amount GBP|width=80px| summaryType=sum| summaryFormat=#,##0.00}{report-info:data:NetOfVat|format= ##,##0.00|type=number}{report-column} {report-column:title=Total Amount GBP|width=80px| summaryType=sum| summaryFormat=#,##0.00}{report-info:data:RowCost|format= ##,##0.00|type=number}{report-column} {report-column:title=Attachment|width=100}{report-link:data:Attach > reference:value > content:download path}{report-info:data:Attach}{report-link}{report-column} {report-table} {card} {card:label=Overseas Entertainment} {report-table} {local-reporter:data:GeneralExpenses} {text-filter:data:Category| include=7404 Overseas Entertainment} {local-reporter} {report-column:title=Itemdate}{report-info:data:Itemdate|format=dd/MM/yyyy}{report-column} {report-column:title=Work/Task Order Number|width=40px}{report-info:data:TaskOrder}{report-column} {report-column:title=Category|width=220px}{report-info:data:Category}{report-column} {report-column:title=Description|summaryContent=Total|width=150px}{report-info:data:Description}{report-column} {report-column:title=Currency|width=60px}{report-info:data:Currency}{report-column} {report-column:title=Exchange Rate|width=60px}{report-info:data:FXRate|format=##,##0.0000}{report-column} {report-column:title=Total Amount|width=60px}{report-info:data:TotalAmount|format=##,##0.00}{report-column} {report-column:title=VAT Rate|width=60px}{report-info:data:VATRate|format=##,##0.00} %{report-column} {report-column:title=VAT Amount GBP|width=80px| summaryType=sum| summaryFormat=#,##0.00}{report-info:data:VATAmount|format= ##,##0.00|type=number}{report-column} {report-column:title=Net Amount GBP|width=80px| summaryType=sum| summaryFormat=#,##0.00}{report-info:data:NetOfVat|format= ##,##0.00|type=number}{report-column} {report-column:title=Total Amount GBP|width=80px| summaryType=sum| summaryFormat=#,##0.00}{report-info:data:RowCost|format= ##,##0.00|type=number}{report-column} {report-column:title=Attachment|width=100}{report-link:data:Attach > reference:value > content:download path}{report-info:data:Attach}{report-link}{report-column} {report-table} {card} {card:label=Overseas Travel} {report-table} {local-reporter:data:GeneralExpenses} {text-filter:data:Category| include=7405 Overseas Travel} {local-reporter} {report-column:title=Itemdate}{report-info:data:Itemdate|format=dd/MM/yyyy}{report-column} {report-column:title=Work/Task Order Number|width=40px}{report-info:data:TaskOrder}{report-column} {report-column:title=Category|width=220px}{report-info:data:Category}{report-column} {report-column:title=Description|summaryContent=Total|width=150px}{report-info:data:Description}{report-column} {report-column:title=Currency|width=60px}{report-info:data:Currency}{report-column} {report-column:title=Exchange Rate|width=60px}{report-info:data:FXRate|format=##,##0.0000}{report-column} {report-column:title=Total Amount|width=60px}{report-info:data:TotalAmount|format=##,##0.00}{report-column} {report-column:title=VAT Rate|width=60px}{report-info:data:VATRate|format=##,##0.00} %{report-column} {report-column:title=VAT Amount GBP|width=80px| summaryType=sum| summaryFormat=#,##0.00}{report-info:data:VATAmount|format= ##,##0.00|type=number}{report-column} {report-column:title=Net Amount GBP|width=80px| summaryType=sum| summaryFormat=#,##0.00}{report-info:data:NetOfVat|format= ##,##0.00|type=number}{report-column} {report-column:title=Total Amount GBP|width=80px| summaryType=sum| summaryFormat=#,##0.00}{report-info:data:RowCost|format= ##,##0.00|type=number}{report-column} {report-column:title=Attachment|width=100}{report-link:data:Attach > reference:value > content:download path}{report-info:data:Attach}{report-link}{report-column} {report-table} {card} {card:label=Subsistence} {report-table} {local-reporter:data:GeneralExpenses} {text-filter:data:Category| include=7406 Subsistence} {local-reporter} {report-column:title=Itemdate}{report-info:data:Itemdate|format=dd/MM/yyyy}{report-column} {report-column:title=Work/Task Order Number|width=40px}{report-info:data:TaskOrder}{report-column} {report-column:title=Category|width=220px}{report-info:data:Category}{report-column} {report-column:title=Description|summaryContent=Total|width=150px}{report-info:data:Description}{report-column} {report-column:title=Currency|width=60px}{report-info:data:Currency}{report-column} {report-column:title=Exchange Rate|width=60px}{report-info:data:FXRate|format=##,##0.0000}{report-column} {report-column:title=Total Amount|width=60px}{report-info:data:TotalAmount|format=##,##0.00}{report-column} {report-column:title=VAT Rate|width=60px}{report-info:data:VATRate|format=##,##0.00} %{report-column} {report-column:title=VAT Amount GBP|width=80px| summaryType=sum| summaryFormat=#,##0.00}{report-info:data:VATAmount|format= ##,##0.00|type=number}{report-column} {report-column:title=Net Amount GBP|width=80px| summaryType=sum| summaryFormat=#,##0.00}{report-info:data:NetOfVat|format= ##,##0.00|type=number}{report-column} {report-column:title=Total Amount GBP|width=80px| summaryType=sum| summaryFormat=#,##0.00}{report-info:data:RowCost|format= ##,##0.00|type=number}{report-column} {report-column:title=Attachment|width=100}{report-link:data:Attach > reference:value > content:download path}{report-info:data:Attach}{report-link}{report-column} {report-table} {card} {card:label=Phones/Internet} {report-table} {local-reporter:data:GeneralExpenses} {text-filter:data:Category| include=7502 Phones & Internet} {local-reporter} {report-column:title=Itemdate}{report-info:data:Itemdate|format=dd/MM/yyyy}{report-column} {report-column:title=Work/Task Order Number|width=40px}{report-info:data:TaskOrder}{report-column} {report-column:title=Category|width=220px}{report-info:data:Category}{report-column} {report-column:title=Description|summaryContent=Total|width=150px}{report-info:data:Description}{report-column} {report-column:title=Currency|width=60px}{report-info:data:Currency}{report-column} {report-column:title=Exchange Rate|width=60px}{report-info:data:FXRate|format=##,##0.0000}{report-column} {report-column:title=Total Amount|width=60px}{report-info:data:TotalAmount|format=##,##0.00}{report-column} {report-column:title=VAT Rate|width=60px}{report-info:data:VATRate|format=##,##0.00} %{report-column} {report-column:title=VAT Amount GBP|width=80px| summaryType=sum| summaryFormat=#,##0.00}{report-info:data:VATAmount|format= ##,##0.00|type=number}{report-column} {report-column:title=Net Amount GBP|width=80px| summaryType=sum| summaryFormat=#,##0.00}{report-info:data:NetOfVat|format= ##,##0.00|type=number}{report-column} {report-column:title=Total Amount GBP|width=80px| summaryType=sum| summaryFormat=#,##0.00}{report-info:data:RowCost|format= ##,##0.00|type=number}{report-column} {report-column:title=Attachment|width=100}{report-link:data:Attach > reference:value > content:download path}{report-info:data:Attach}{report-link}{report-column} {report-table} {card} {card:label=Other} {report-table} {local-reporter:data:GeneralExpenses} {text-filter:data:Category| include=7506 Other Expenses} {local-reporter} {report-column:title=Itemdate}{report-info:data:Itemdate|format=dd/MM/yyyy}{report-column} {report-column:title=Work/Task Order Number|width=40px}{report-info:data:TaskOrder}{report-column} {report-column:title=Category|width=220px}{report-info:data:Category}{report-column} {report-column:title=Description|summaryContent=Total|width=150px}{report-info:data:Description}{report-column} {report-column:title=Currency|width=60px}{report-info:data:Currency}{report-column} {report-column:title=Exchange Rate|width=60px}{report-info:data:FXRate|format=##,##0.0000}{report-column} {report-column:title=Total Amount|width=60px}{report-info:data:TotalAmount|format=##,##0.00}{report-column} {report-column:title=VAT Rate|width=60px}{report-info:data:VATRate|format=##,##0.00} %{report-column} {report-column:title=VAT Amount GBP|width=80px| summaryType=sum| summaryFormat=#,##0.00}{report-info:data:VATAmount|format= ##,##0.00|type=number}{report-column} {report-column:title=Net Amount GBP|width=80px| summaryType=sum| summaryFormat=#,##0.00}{report-info:data:NetOfVat|format= ##,##0.00|type=number}{report-column} {report-column:title=Total Amount GBP|width=80px| summaryType=sum| summaryFormat=#,##0.00}{report-info:data:RowCost|format= ##,##0.00|type=number}{report-column} {report-column:title=Attachment|width=100}{report-link:data:Attach > reference:value > content:download path}{report-info:data:Attach}{report-link}{report-column} {report-table} {card} {deck}If it was working and is now not working, then something in the environment has probably changed. Since it's a JavaScript error, chief suspects are:
Have either of these changed?
Also, it's probably best to move this to JIRA - it's easier to manage there. Could you create a bug report if you are unable to resolve the issue, and we'll deal with it from there.
This is happening for us to. We upgraded to 2.7.3 and started seeing this. The root cause is an out of date theme. The Left Navigation and Top and Left Navigation themes trigger this error, but it doesn't happen with the default theme. The solution is to fix the themes.
I love themes. I'm attempting to get this stuff working in 2.8 now, and working with the new 'Default' theme vs. the classic themes vs left nav vs. whatever is lots of fun...
Hi David,
I am attempting to use the table-data macro but it is not keeping the data. It allows me to add rows and enter the data, but when I preview or save, the data is not there.
I used your usage script above which is rather simple and the same problem occurs so I do not think it is my syntax that is broken. But no errors. The macro thinks
that it is working beautifully
Where do I start looking for the problem? We are on Confluence 2.8 at the moment.
Regards,
Cornelis.
The best thing to do is to create a bug report with the details of your markup, web server, plugin version, etc and we'll address it from there.
SCAFF-248 has been opened. It seems to be a repeat of SCAFF-172 which is listed as being resolved but does not state what the cause of the problem was.
Regards,
Cornelis.
I'm trying using to use Reporting macro to report on just the last row entered into a table.
I'm using the maxResults=1 but is there a hidden record number field I can sort the data in the table on?
I've tried using 'order' in both directions but that still gives the same results