Confluence Cloud : Auto assign id to the column

[Ashish Saini]

Hello team, 

I have table created with diff columns for requirements.

Once such table is called Sys id and i want to auto assign the values like 001, 002 ,003 and 0004, automatically.. is there any way to achieve this using macro ..native or 3rd part 

Regards
Ashish

[Katerina Rudkovskaya_Stiltsoft_ · Accepted solution]

Hello Ashish,

I advise you using Table Filter and Chart for Confluence app in this case.
Please wrap your table with our Table Transformer macro and use the following SQL query:

SELECT 'Subsystem',
'Sys Req id'::string->padStart(3, "0") AS 'Sys Req id',
'Summary',
'Description'
FROM
(SELECT *, ROWNUM() AS 'Sys Req id' FROM T1)




Katerina
Stiltsoft

[Ashish Saini]

@Katerina Rudkovskaya_Stiltsoft_ : This works ..Thank you :)

[Ashish Saini · Accepted solution]

@Katerina Kovriga _Stiltsoft_  : Any suggestion please 

[Katerina Kovriga _Stiltsoft_]

Hi @Ashish Saini ,

Please check the previous answer from @Katerina Rudkovskaya_Stiltsoft_ - it fully suits your case.

You may find the list of functions available for the Table Transformer macro here.

[Ashish Saini]

@Katerina Kovriga _Stiltsoft_ : Thank you for the help :)