Table Transformer Macro - auto row numbering

David Wu May 6, 2021

Is it possible to add automatic row numbering to a table generated by the Table Transform Macro.  Embedding the Table Transform Macro into Table Plus does not seem to work.

2 answers

3 votes
David Wu May 6, 2021
SELECT *, ROWNUM() AS '_' FROM T*
Andrey Khaneev _StiltSoft_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 7, 2021

Here you can find the list of SQL functions and the ROWNUM() function.

Like # people like this
2 votes
Katerina Rudkovskaya _Stiltsoft_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
May 7, 2021

Hi @David Wu

Note that there's also a row numbering option using the Table Filter macro.

2021-05-07_21h27_21.png

Katerina
Stiltsoft

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events