Aggregate with Row Number

Aggregate with Row Number

  

hi there, how to get number column (1..2..3...etc) in an aggregate, so below, instead of Name and Age columns:

i also want to show numbers of the row.

RowNo Name Age

1 abc 92

2 cde 100


thank you,

regards, indra

One way to do it is to replace your Aggregate by a SQL Query, and use a database specific function to retrieve the row number. For SQL Server, you could use a query similar to this:

SELECT ROW_NUMBER() OVER (ORDER BY [Id]), [Name] FROM {TestEntity}

You're going to have to create a structure to store the row number and the attributes you need, and set this structure as the output structure of the SQL Query.