Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Deborah Frommer
Contributor
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
Contributor
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