Geek Answers Handbook

How to renumber pages in Oracle APEX application?

I just finished my first “real” APEX application, but it looks a little dirty. Can I paginate the pages so that they return to the order of the application flow?

Thanks in advance, Matt

+4
source share
5 answers

Numbers are arbitrary. Do not go into the hassle of renumbering everything, since you will need to check all the branches, tabs, breadcrumbs ....

+7
source
  • Copy the specified page and set a new number
  • Change any links leading to the old page to the new page
  • Delete old page
+6
source

The following tip will not help you with your current application, but I find it useful to plan ahead for page numbering in advance.

First, I divide my application into groups of pages, say, “Accounting, reports and administration,” and then assign 100 (or 1000) pages to each of these groups.

For instance:

100 - Accounting (main page) 200 - Reports (main page) 300 - Administration (main page)

Then I assign subpages to each group based on which pages my requirements analysis tells me that I will most likely need:

 100 - Accounting (main page) 110 - List Invoices 120 - Edit Invoice 121 - Edit Invoice - Details Screen 130 - Add new invoice - step 1 131 - Add new invoice - step 2 132 - Add new invoice - step 3 200 - Reports (main page) 300 - Administration (main page)

And so on, you get the idea. Leave some space between the numbers (110, 120, etc.) to add a few pages later.

Of course, it is difficult to plan everything in advance, so some pages of pages outside the page should be used after some time, but, in my experience, a little preliminary planning makes it much more manageable (and easy to work).

+2
source

  • As Gary says, it's better to consider page numbers arbitrary.

  • You can export the application, edit the SQL script with the new page numbers (do not forget to look for all the locations that the page number refers to), and then re-import the application - and test it thoroughly :) - I hope you do not have links to pages in other applications , although:)

  • In Apex 3.2 and later, you can put your pages in groups, which can be useful for sorting pages and making it easier to find the page you are interested in.

+1
source

Step 1. Create a copy of the page.

see how to copy a page

Step 2: And delete your previous pages.

And here you are. But you will need to check all the branches, tabs, crackers, etc.

If you want to do this, I will suggest that you follow your page creation order (that is, create a copy of the first page that you created at the beginning of your application). This will help you get a hint about which branches, tabs, breadcrumbs you need to update.

0
source

More articles:


All Articles