Number order in group table

Support
#1

Hello everyone. I want to have number order in separate column in Group Table which looks like SELECT ROW_NUMBER() OVER (ORDER BY Address) AS [NUMBER ORDER] FROM ENTITY. Have a nice day!

#2

Not sure what you are trying to achieve here. Do you want the the actual number coming from the db row_number() function? I think you will have to resort to native queries

Or are you looking at getting the index from the datacontainer paging?

1 Like
#3

Thank Tom. I don’t want to use the database.What I want here is to have an ordinal number in the table so that I can clearly see how many elements are in the table

#4

@nguyencongphuong

if it’s only about the number of elements in the table, what about using the <rowCount/> property?

https://doc.cuba-platform.com/manual-latest/gui_Table.html

1 Like
#5

1
sorry.what I need it looks like

#6

I need a number for each record

#7

what should happen when sorting the table on a property? should the numbers be updated? or should every element keep his original number order?

depending on the answer you could use a columngenerator

1 Like
#8

if i sort record. number order also will update. look like .The sequence number column is only temporary1