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 edited

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
atlassian, likes for trees, atlassian community, social impact, tree planting campaign, community kudos, atlassian giving, environmental impact, sustainability, likes for good, atlassian social responsibility, community challenge

Make every click count—help us plant 50,000 trees! 🌳

Want to make your everyday Community actions directly contribute to reforestation? The Atlassian Community can achieve this goal by liking a post, attending an ACE, sending your peers kudos, and so much more!

Help us plant more trees
AUG Leaders

Atlassian Community Events