6 Replies Latest reply on Jul 19, 2013 10:22 AM by Nikolas Saridakis

    Is it possible to achieve table column paging in ADF?

    Nikolas Saridakis

      I have this huge table of important data and want have a "frozen" part of a table and next to it multiple pages of groups of columns that i can view with a "next", "previous" button, similar to this site:


      Regular Season Standings | MLB.com: Standings


      is this possible in ADF 12c?


      Thank you in advance,


        • 1. Re: Is it possible to achieve this effect in ADF?
          Subramanian Meyyappan



          your requirement sounds like  pagination



          Andrejus Baranovskis's Blog: ADF 11g PS6 - ADF 10g Table Pagination Feature is Back Finally



          In Link "left side" Jul 16 2013 sounds like pagination and "right side" standard splits frozen scroll bar can does. why you need to that same in some arrow button.

          • 2. Re: Is it possible to achieve this effect in ADF?
            Nikolas Saridakis

            Thank you for your answer, what you proposed reffers to row pagination, not column...


            Thank you anyway...


            • 3. Re: Is it possible to achieve this effect in ADF?
              Subramanian Meyyappan

              Hi user,


              Thank you for your answer, what you proposed reffers to row pagination, not column...


              You 're looking for by pressing some arrow button you had scroll left to right and vice versa? if am right.

              this would be done with the help of frozen effect in your af:table that would provide the scroll bar options itself have the stuff. why you need to put up some button to do that.

              • 4. Re: Is it possible to achieve this effect in ADF?
                Arunkumar Ramamoorthy-Oracle



                You could have a property defined in the bean and set the visible property for the columns according to its value. Set the necessary values in the actionListener of the buttons.


                For ex :  Here is the example using Emp table.


                jspx source :


                <af:commandButton text="&lt;" id="b1" actionListener="#{viewScope.ColPaginationBean.prevCols}"
                                           disabled="#{viewScope.ColPaginationBean.visColGroup lt 2}" partialTriggers="b2"/>
                                <af:commandButton text="&gt;" id="b2" actionListener="#{viewScope.ColPaginationBean.nextCols}"
                                 disabled="#{viewScope.ColPaginationBean.visColGroup eq 3}" partialTriggers="b1"/>
                                <af:table value="#{bindings.EmpView1.collectionModel}" var="row" rows="#{bindings.EmpView1.rangeSize}" partialTriggers="::b1 ::b2"
                                          emptyText="#{bindings.EmpView1.viewable ? 'No data to display.' : 'Access Denied.'}"
                                          rowBandingInterval="0" selectedRowKeys="#{bindings.EmpView1.collectionModel.selectedRow}"
                                          selectionListener="#{bindings.EmpView1.collectionModel.makeCurrent}" rowSelection="single"
                                          fetchSize="#{bindings.EmpView1.rangeSize}" id="t1">
                                    <af:column headerText="#{bindings.EmpView1.hints.Empno.label}" id="c1">
                                        <af:outputText value="#{row.Empno}" shortDesc="#{bindings.EmpView1.hints.Empno.tooltip}"
                                            <af:convertNumber groupingUsed="false" pattern="#{bindings.EmpView1.hints.Empno.format}"/>
                                    <af:column headerText="#{bindings.EmpView1.hints.Ename.label}" id="c2">
                                        <af:outputText value="#{row.Ename}" shortDesc="#{bindings.EmpView1.hints.Ename.tooltip}"
                                    <af:column headerText="#{bindings.EmpView1.hints.Job.label}" id="c3" visible="#{viewScope.ColPaginationBean.visColGroup eq 2}">
                                        <af:outputText value="#{row.Job}" shortDesc="#{bindings.EmpView1.hints.Job.tooltip}" id="ot3"/>
                                    <af:column headerText="#{bindings.EmpView1.hints.Mgr.label}" id="c4" visible="#{viewScope.ColPaginationBean.visColGroup eq 2}">
                                        <af:outputText value="#{row.Mgr}" shortDesc="#{bindings.EmpView1.hints.Mgr.tooltip}" id="ot4">
                                            <af:convertNumber groupingUsed="false" pattern="#{bindings.EmpView1.hints.Mgr.format}"/>
                                    <af:column headerText="#{bindings.EmpView1.hints.Hiredate.label}" id="c5" visible="#{viewScope.ColPaginationBean.visColGroup eq 2}">
                                        <af:outputText value="#{row.Hiredate}" shortDesc="#{bindings.EmpView1.hints.Hiredate.tooltip}"
                                            <af:convertDateTime pattern="#{bindings.EmpView1.hints.Hiredate.format}"/>
                                    <af:column headerText="#{bindings.EmpView1.hints.Sal.label}" id="c6" visible="#{viewScope.ColPaginationBean.visColGroup eq 3}">
                                        <af:outputText value="#{row.Sal}" shortDesc="#{bindings.EmpView1.hints.Sal.tooltip}" id="ot6">
                                            <af:convertNumber groupingUsed="false" pattern="#{bindings.EmpView1.hints.Sal.format}"/>
                                    <af:column headerText="#{bindings.EmpView1.hints.Comm.label}" id="c7" visible="#{viewScope.ColPaginationBean.visColGroup eq 3}">
                                        <af:outputText value="#{row.Comm}" shortDesc="#{bindings.EmpView1.hints.Comm.tooltip}" id="ot7">
                                            <af:convertNumber groupingUsed="false" pattern="#{bindings.EmpView1.hints.Comm.format}"/>
                                    <af:column headerText="#{bindings.EmpView1.hints.Deptno.label}" id="c8" visible="#{viewScope.ColPaginationBean.visColGroup eq 3}">
                                        <af:outputText value="#{row.Deptno}" shortDesc="#{bindings.EmpView1.hints.Deptno.tooltip}"
                                            <af:convertNumber groupingUsed="false" pattern="#{bindings.EmpView1.hints.Deptno.format}"/>



                Backing bean :


                package view.backing;
                import javax.faces.event.ActionEvent;
                public class ColPaginationBean {
                    private int visColGroup=1;
                    public void setVisColGroup(int visColGroup) {
                        this.visColGroup = visColGroup;
                    public int getVisColGroup() {
                        return visColGroup;
                    public ColPaginationBean() {
                    public void prevCols(ActionEvent actionEvent) {
                        // Add event code here...
                    public void nextCols(ActionEvent actionEvent) {
                        // Add event code here...



                • 5. Re: Is it possible to achieve this effect in ADF?
                  Nikolas Saridakis

                  Because we're talking about over 30 columns of info... and by pressing the scrollbar i cannot see the groups of data i need...

                  Thanks anyway...!

                  • 6. Re: Is it possible to achieve this effect in ADF?
                    Nikolas Saridakis

                    Thanks Arun... Sounds ok... I'll test it and award you the points!

                    Take care,