Please disable your adblock and script blockers to view this page

Search this blog

Thursday 29 November 2012

Add Serial No. in Table in ADF, Auto Increment column in ADF table

ADF provides easy way to add a autoincrement column in table to make Serial No. or Sequence Column for table ,thats value autoincrements with no.of rows in table .
You have to follow these steps to do this.

  • Go to tabel properties (property Inspector) and set VarStatus to vs

set varStatus of af:table to vs
  •  Now add a column in table and drop an output text inside this new added column
Add new column to af:table to show serial number for each row
  • Select output text and Go to its property inspector and set value to #{vs.index+1} as it is selected in Expression Builder by going through- 
ExpressionBuilder----->JspObjects--->VS---->index




using varStatus we can access various built in function like index,count etc
  • You have done now run your page and you can see a serial no. column
af:table with serial number column
You might also like:

Labels: , , , , , , ,

4 comments :

  1. kishan13 December 2016 at 09:30

    Very good example, it is really working , thanks for effort.

    ReplyDelete
  2. Unknown17 December 2016 at 19:38

    how can i save this index value into DB?

    ReplyDelete
    Replies
    1. Ashish Awasthi28 February 2017 at 13:34

      You can generate a serial no of sequence and then save it in DB

      Delete
  3. mosta18 September 2017 at 14:18

    Thanks

    ReplyDelete

Subscribe to: Post Comments ( Atom )