How to remove borders from SQL table transformer view

[Dhiraj Kr_ Gupta]

I want to remove vertical line from the view of a table based on SQL Table Transformer Macro im confluence

[Stiltsoft support]

Hi @Dhiraj Kr_ Gupta ,

As the Table Transformer macro treats source tables as mini databases, it draws borders around your cell contents. But you can color them white and make them "invisible".

The first option is to use the following SQL query:

SELECT
FORMATWIKI("{cell:border-color=white}", 'Column 1' + "{cell}") AS 'Column 1',
FORMATWIKI("{cell:border-color=white}" + 'Column 2' + "{cell}") AS 'Column 2'
FROM T*

And the second option is to use the Stylesheet tab of the macro: 

td {border-color:white}

The result will be the same:

Hope it helps your case.

[Stiltsoft support]

And another CSS for the Stylesheet tab from our developers to remove only vertical lines from your table:

.confluenceTh, .confluenceTd {
border: none;
border-bottom: 1px solid #C1C7D0;
}