Nice filter region template

Written by Paulo Vale on Wednesday, April 23, 2008

One of the good things that Oracle APEX Team made to help the new developers are the Packaged Applications. Packaged Applications are working example applications that you can use to get the feel of APEX capabilities. You can also learn how things get done, since you can access all the source.

This leads me to the point of this post. I like v
ery much the way, reports filters and options are organized in these example applications. The person who made this, certainly has a good taste :)

Look at the next screenshot to see what I mean. I'm talking about that gray region where the search field and conditions are.

Since I liked it so much, I've decided to use it in my applications. For instance, I've integrated this region template in our APEX built CRM App (Better.CRM).

How to do it? :) Just copy the code from any of the Packaged Applications and then:

- Shared Components > Templates > Create
- Template Type: Region
- Create Region Template: From Scratch
- Name: Finder Bar
- Template Class: Button Region Without Title
- Template Code:

Now you just need to create an HTML Region in your page, apply the new Finder Template and include the fields in the region.

That's it. I hope this helps you make good looking apps :)

New blog

Written by Paulo Vale on Saturday, April 05, 2008

I would like to point you to a new APEX related blog. João Oliveira is my personal friend, works with me at Neoface and he is an experienced Oracle DBA.

APEX is not an exclusive subject, but you will find on beyondoracle blog many interesting topics regarding this technology, specialy in terms of server configurations, security and tunning.

He started his blog last February, so please give him a visit and a warm welcome.

Partial Page Request Reports

Written by Paulo Vale on Thursday, April 03, 2008

Last December I wrote a post about Turning a Report into PPR Report, making some changes in report template.

PPR means Partial Page Request, in other words, you can navigate your report records without needing to submit the whole page.

With the last APEX update, in case you havent noted yet, this feature option is already added to the report properties, so you don't need to change report template anymore.

To enable it, go to the report region properties and change to "Report Attributes" tab, "Layout and Pagination" section and change "Enable Partial Page Refresh" to Yes.

Have fun.