[fossil-users] (Q) How to add the row number column to an open tickets report?

Hi Everyone, I am sorry if I am asking something trivial but I am not a SQL expert. I have a ticket report that lists all open and active tickets. I would like its first column to simply show row numbers starting with 1 for the first row of the report, 2 for the second row and so on. Google

Re: [fossil-users] (Q) How to add the row number column to an open tickets report?

On Tue, Apr 3, 2012 at 6:54 PM, Themba Fletcher themba.fletc...@gmail.comwrote: You might be interested instead in selecting SQLite's ROWID column -- it won't give you the nice short humane numbering you're looking for but it can be counted upon in the above situations. However, the rowids