Page Specific Utilities

First things first. Yes, it' has been to long since I wrote my last blog post. But you know what, it's not like I didn't had time or something like that...it was just that I lost my login credentials for blogger.com...

Today I walked to the office and suddenly I remembered what my credentials are, and I also got an idea for a new blog post. Maybe it was due to the fact that it was a really nice walk...who knows :)

I'm working with APEX for many years now and here and there I "discover" things that are there, I guess for ages, but somehow I have overlooked them. My last presentation that I did was "It's good to know your APEX backyard" for the APEX Alpe Adria conference. In this presentation I talked about that APEX is not only Page Designer, where we spend most of our time when working with APEX. But there is so much more then Page Designer. As part of the presentation I also covered Application Utilities and on the page with Page Utilities you can see utilities like Application Dashboard, Upgrade Application,... But for me the best part was/is, the part rounded with the red color: Page Specific Utilities

For me this was a really nice discovery. Why discovery? I would say that you don't notice ( maybe it's just me ) the Page Specific Utilities right away. They are there on the page but a bit left out on the side and I would really like to see them more visible. Simply because they are so useful. So take a bit of your time to check them out, it's worth it.

I will not cover all the Page Specific Utilities in this blog post, I will just highlight my personal top 3.

1. Region Utilities > Grid Edit all No Data Found Messages

With this you can edit ALL "No Data Found" messages on a single page.

2. Process Utilities > Grid Edit of all Process Messages

Similar to the previous, only that in this case you can edit all Process messages...again on a single page.

3. Region Utilities > Update Interactive Report Settings

This is actually my favorite Page Specific Utility. You can see Interactive Report Settings of all Interactive reports and you can also manipulate this settings...again on a single page.

Aljaž

Change image prefix when using ORDS in standalone mode

In Oracle Application Express we can specify instance wide image prefix ( we provide this when installing APEX or later if we run apex/utilities/reset_image_prefix.sql ). Purpose of this blog post in not to explain what image prefix is, but if you would like to know more about it, then I recommend that you read a blog post from Joel Kallman - Image Prefix changes in Oracle Application Express 4.2.2 My blog post is about what we need to do, if we are changing image prefix and at the same time we are using Oracle REST Data Services (ORDS) in standalone mode . If we need to change image prefix, first thing is to run apex/utilities/reset_image_prefix.sql script and here we specify new image prefix - for example /i_test/ After this change when accessing APEX login page we will see this warning: I find this warning very useful. It's telling us that we have to verify that we have copied images directory to right location and also that our new path is /i_test/ . In case w

APEX Alpe Adria

APEX Alpe Adria There are different ways how a story can start. The story about the APEX Alpe Adria conference started in the beautiful city of Rovinj in Croatia. I was travelling from the SiOUG event to the HrOUG event . Since the HrOUG event takes place on the island, I was waiting for the boat transfer. I was standing at the end of the peer and thinking it's good that we have an event in Slovenia and also in Croatia, but at the same time, would it be great to do something together? To do something together, you need other people who would support this idea, and by "coincident", who do I see standing on the peer waiting for a boat transfer ... Dario Bilić. Dario is a good friend of mine. At that time, he was helping with the APEX track for the HrOUG event. I explained my idea to Dario. He suggested, let's also reach out to Peter Raganitsch and we can organise the dedicated APEX event for the Alpe Adria region . Sure enough, Peter supported this idea without an

New Look & Feel for Radio Group in Oracle Application Express 5.1

With Oracle Application Express version 5.1 we are getting lots of new features. Among most notable or exposed are for sure Interactive Grids, JET Charts and Live Template Options. But we can also find some smaller (and really nice) enhancements. One of this is new look and feel of Radio Group item. We can spot this for example when we use Create New Page wizard in Page Designer: So what do we need to do, if we want to have this look and feel in our applications. Just adding combo box item to our page is not enough, it will have the same effect as in version 5.0. It will look like this : Basically we need to change three things. Number of Columns: should match number of elements in group or you can also set it to some bigger value (for example 100) Display Null Value: NO Template Option -> Region Group Display: Display as Pill Button After this three small changes we now have new look and feel for our radio group: For me personally the s

B - APEX

Search This Blog