How can i retrieve rownumber using flexible search?

[Former Member]

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]

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

[lucian_ciufudean]

This works with SQLServer:

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

[Former Member]

you need to do it with a syntax available in your DB (Oracle with ROWNUM), there is nothing in FlexibleSearch which can deliver "row number"-like info.