Confluence Data Center Question on Table Transformer Macro

Dolly Kirubavathi

I have an attribute in Jira that is a multi-select text.  The values could range from 1 to several in that attribute. 

I am trying to show this attribute in the table transformer macro. Since the field is too long, it takes up the whole page for showing one row. Is there a better way to show it? may be like ... three dots and then when they click on it, show the entire text just like we have it in Jira list display?

Stiltsoft support

Hi @Dolly Kirubavathi ,

You may try the following workaround for the case:

Then you use this SQL query to create a tooltip for the 'Col 2' that you need to cut. The tooltip will contain all the original cell contents:

SELECT 'Col 1',
FORMATMARKDOWN("[" + 'Col 2' + "](# \""+ 'Col 2'+ "\")") AS 'New Col 2'
FROM T*

Then you go to the Stylesheet tab, set a specific cell width and make your cell contents look like text:

td a {
display: inline-block;
width: 40px;
white-space: nowrap;
overflow: hidden;
text-overflow: ellipsis;

color: inherit;
text-decoration: none;
//pointer-events: none;
cursor: default;
}

The result will be similar to your initial request: