How to remove borders from SQL table transformer view

Question

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

Stiltsoft support · Answer

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;
}

Stiltsoft support · Answer

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.