ApEx 4.0: Date Picker Item Minimumdate and Maximumdate

One of the big improvements of ApEx 4.0 in my opinion is the rebirth of the date picker Item. The old version of the date picker was a popup that opened a calender, it was ok but a lot of developers already used something more sexy like the jQuery Ui Datepicker. This required some custom development and was’t out of the box functionality.

In ApEx 4.0 the date picker got a new look and feel based on the jQuery Datepicker. It opens a lot faster and is overall more simple to use. You don’t have to create a validation anymore to check if the user has specified a valid date, this is done automatically.

Some new properties are available for the date picker:

Continue reading

ApEx Export Interactive Report: tip or security issue?

Exporting an Interactive Report in one click is possible, you don’t have to use the right menu witch can save your user 3 clicks!

To accomplish this you have make a branch to the page containing an Interactive Report and play around with your Page Request:
– CSV
– RTF
– PDF
– XLS
– HTMLD (ApEx 4.0 Only)

Although this sounds actually very nice, it becomes less nice when I try to disable the export for an Interactive Report.

Even when I disable every option for the Interactive Report, it still will allow me to download all the data when playing around with the page request.

Maybe not a critical issue but definitely something to take in account when you use a lot of Interactive Reports.

ApEx 4.0: Websheet Objects

When creating a new workspace you might have noticed that there will be some extra tables on your schema.
All these table start with the name APEX$_ and are used for the websheets feature of the new version of ApEx.

If you don’t use websheets (at start) and you don’t want these extra tables present on your schema then you can prevent the creation of these tables by following the next steps:
– Login into the internal workspace
– Go to Manage Instance -> Feature Configuration
– Set “Create Websheet objects in new workspaces” to No

Please keep in mind that the above action will still allow developers to make websheets. If these objects do not exist then the developer will see a warning message when he/she tries to create a websheet. You then will able to create these objects again:

If you have the Websheet Objects on your schema and you wish to remove them then go to “
Home -> Administration > Manage Service -> Websheet Database Objects” and there you can safely remove these objects.