Skip to main content
Nintex Community Menu Bar

Hi I am facing issues with the list view. Business requirement is to have a Serial no- sequence no based on the no of rows of data to be diplayed in list view. 

I tried to use the expression along with th elist count it did not work.

I am looking for an output like this. Im going get list on the list No Add/Edit/Delete option. Please help if any one of you came across similar requirement.

 

16775i47AFF4E907786B1A.png

Hi  @DubaiK215504,

 

You need to create stored procedure to do that,

 

13122iAD66F5505DFADB5F.png

 

 

Here it is: 

 

SELECT TOP (1000) Sequence = ROW_NUMBER() OVER (ORDER BY DCountryID]), yUserName], NCountryID]
FROM /dbo]. Vendors] ORDER BY Sequence;

 

wish it helps :)

 

Regards,

 


Reply