Hai All 

        I need Serial number for My Table Records Like 1,2,,3,4

S.noAtt1
1a
2b
3c
4d
5e
6f
7g
8e


How I am Achieve This Method 

Regards 

Selva


Solution

Hi Selva,

You can use

entityname.list.currentroenumber+1 

because index start from 0

see below image-


Regards

Rahul Sahu

Solution

You means


entityname.list.currentrownumber+1  


:)

Selva bharath wrote:

Hai All 

        I need Serial number for My Table Records Like 1,2,,3,4

S.noAtt1
1a
2b
3c
4d
5e
6f
7g
8e


How I am Achieve This Method 

Regards 

Selva


 Hi

u can also use it

SELECT ROW_NUMBER()  OVER (ORDER BY  id) As SrNo FROM  {JulyReport}

 

Vijay Malviya wrote:

Selva bharath wrote:

Hai All 

        I need Serial number for My Table Records Like 1,2,,3,4

S.noAtt1
1a
2b
3c
4d
5e
6f
7g
8e


How I am Achieve This Method 

Regards 

Selva


 Hi

u can also use it

SELECT ROW_NUMBER()  OVER (ORDER BY  id) As SrNo FROM  {JulyReport}

 

 

 I don't agree for use advance sql for this type of operations.

Normally can achieve by aggregate.