cancel
Showing results for 
Search instead for 
Did you mean: 

How can i retrieve rownumber using flexible search?

Former Member
0 Kudos

I wanted to retrieve the row number using flexible search. For example, I have employee table with column name and I want to retrieve the column name with row number. Please see below:

Num . Name 1 . ABC 2 . DEF 3 . GHI 4 . JKL

Former Member
0 Kudos

Do you need to have a row number in FlexibleSearch in Hybris Administration Console, or in a Java code?

View Entire Topic
lucian_ciufudean
Discoverer
0 Kudos

This works with SQLServer:

SELECT ROW_NUMBER() OVER(ORDER BY p_code ASC) AS Row#, {code}, {creationtime} FROM {Product!}