I would like to add a column order_line_nr (persistent) to OrderLine that automatically increments for the Order when creating a new line.
Would be great if it could also handle special cases like re-numbering when a row was deleted.
Is there any suitable Service for this?
It may also be a non-persisent value. Important for me would be to have it somehow generated for the report (without Jasper). Something like “select row_number()…” would be enough, if it’s easier to implement. Persistent would be better though as it would keep the ordering.
I checked these, but didnt find the soluition, it might be there but didn’t get it :