Search code examples
oracle-adfrownum

Get Rownum Attribute as a Transient Attribute in Oracle ADF

I have a requirement, in which the code is using a SQL as 

Select <COLUMN_LIST>, ROWNUM from <TABLE_LIST_AND_WHERE_CLAUSE>;

Now i need to remove this ROWNUM from the Select list but still keep the functionality of the attribute.

I have tried forums but with no fruit.

Please suggest is i can use an EL or an attribute to do the same.

Thanks in advance

Solution

  • Will adding #{vs.index + 1} for getting row number in your table solve your problem . vs would be your varStatus attribute value in <af:table> ?