How to keep Text and Link-Formating and define Table Column Widths?

Deborah Frommer February 29, 2024

Hi all, 

I currently use the Table Transformer to define the column size of an table.
With the query:
SELECT *,
FORMATWIKI("{cell:width=20%}" + 'Type'+ "{cell}") AS 'Type',
FORMATWIKI("{cell:width=20%}" + 'all'+ "{cell}") AS 'all',
FORMATWIKI("{cell:width=20%}" + 'Request'+ "{cell}") AS 'Request',
FORMATWIKI("{cell:width=20%}" + 'Requirement'+ "{cell}") AS 'Requirement',
FORMATWIKI("{cell:width=20%}" + 'Task'+ "{cell}") AS 'Task'
FROM T*


Unfortunately the text formatting (bold text) and Links (to Jira-Filter) and other thinks are gone.

Is there a possiblity to keep the content and only define the column width?

 

In Edit Mode:
Origin Table.png

And in the normal view: --> formatting is gone
afterwards.png

Thanks for your help and best regards. 

Deborah

 

1 answer

1 accepted

2 votes
Answer accepted
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 1, 2024

Hi @Deborah Frommer ,

Please use commas instead of pluses in you SQL queries, they will help you to preserve initial cell formatting.

https://docs.stiltsoft.com/tfac/dc-server/advanced-table-cells-formatting-58426218.html#Advancedtablecellsformatting-Preservinginitialcellformatting

Deborah Frommer March 4, 2024

Thanks for your help.

Like Stiltsoft support likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events