IMO you are describing a mixed requirement task. For one part you would like serial numbers (those should probably be unique) and the second part describes a have an attribute for sorting that also can be manipulated to move a row in the grid.
I think Lukas answers most of your questions. I just want to point out something regarding:
> Is there any way to just display serials in view and not store it in database?
Yes, this can be achieved using counters – https://developer.mozilla.org/en-US/docs/Web/CSS/CSS_Lists_and_Counters/Using_CSS_counters
IMO this is the best approach if you only want something in the UI.
-Andrej
Have you tried adding an attribute of type autonumber?
That should work out of the box numbering your objects. However it will store it in the database.
If you want to only display it and not calculate it you could try a calculated attribute but that will impact your performance significantly on 100,000 rows.
Hope this helps
hi,
have you found a siluatuion for the above question ?