6 Replies Latest reply: May 5, 2011 12:51 AM by mark.lancaster RSS

    Reset pagination for a region

    VANJ
      Is there a way to reset pagination for a region and not the whole page?

      If I have a report region R1 with a clickable link to another report region on the same page R2, I would want each click on R1's link to reset pagination only for R2, not for the whole page! Otherwise I lose my place in R1's resultset.

      Thanks
        • 1. Re: Reset pagination for a region
          VANJ
          I guess this is not possible. What is the rationale for this? How can I workaround it? Thanks
          • 2. Re: Reset pagination for a region
            60437
            I guess this is not possible.
            I agree.
            What is the rationale for this?
            How would an answer help you?
            How can I workaround it?
            Put reports on different pages so that resetting pagination on a page doesn't reset pagination on reports that you don't want pagination reset for.

            Scott
            • 3. Re: Reset pagination for a region
              VANJ
              What is the rationale for this?
              How would an answer help you?
              Well, obviously it wouldnt if I wanted to do just that, but I am the curious sort. I just wanted to understand what the reason for it was from a architecture/design perspective.
              Put reports on different pages so that resetting
              pagination on a page doesn't reset pagination on
              reports that you don't want pagination reset for.
              Yeah, I guess, but changing pages just for this reason doesnt quite seem right. It disrupts the user experience to flip between pages

              • 4. Re: Reset pagination for a region
                135285
                If someone is still looking for a solution to this problem, have a look at http://inside-apex.blogspot.com/2007/09/resetting-pagination-of-master-detail.html

                Patrick
                ----------------------------------------------------------------------------------------------------
                My APEX Blog: http://inside-apex.blogspot.com
                The ApexLib Framework: http://apexlib.sourceforge.net
                The APEX Builder Plugin: http://sourceforge.net/projects/apexplugin/
                • 5. Re: Reset pagination for a region
                  Phil UK
                  Scott

                  Is it possible that you could be any less helpful?

                  Does anyone else know how to do this please - am trying to reset one region in a multi-region page which uses extJS to display four regions.

                  Thanks

                  Phil
                  • 6. Re: Reset pagination for a region
                    mark.lancaster
                    Hi Phil

                    Since you mentioned Ext JS, you will find the solution to refresh a region on page 330 of my book.

                    Just use the hightlighted code.

                    Regards

                    Mark

                    demo: http://apex.oracle.com/pls/otn/f?p=200801 |
                    blog: http://oracleinsights.blogspot.com |
                    book: Oracle Application Express 4.0 with Ext JS