Add Column in Table in SQL in confluence

Dhiraj Kr_ Gupta

I want to add a column in SQL(made from table transformer) using Alter Table

I have written the code

ALTER TABLE Table1 ADD STATUS varchar(255)

But it is giving error like Parse error Expecting 'COLUMN' got 'LITERAl'

 

Can you solve the problem

If you help me also to apply condition like when and then

Stiltsoft support

Hi @Dhiraj Kr_ Gupta ,

The Table Transformer macro is based on the AlaSQL library, you can find plenty of different code examples in our documentation.

What concerns statuses that are inserted using a condition (it is a "CASE WHEN" statement for the macro), you may check this example: https://docs.stiltsoft.com/tfac/dc-server/advanced-table-cells-formatting-58426218.html#Advancedtablecellsformatting-Conditionalinsertingofstatuses

It should help your case.

If somehow you are still stuck, please refer to our support. Attach the page storage format (upper right corner -> menu ... -> View storage format) to the ticket: we'll be able to recreate your source table and your macro and help you with the query.