Posts tagged: APEX

APEX Calender report

Another powerfull item that can be used to fight the data pile: presentation by a calendar. Oracle APEX supplies us with a simple wizzard which makes it easy to present date related data.

Because I am still learning and always trying just a bit different than standard, I found something to be aware of.

Case: An application for Helpdesk Tickets (see “Beginning Oracle Application Express”). I already have the “Form on a Report” page pair which lists the tickets and links to the Ticket details update page. Now I want to create a page with a calendar where the data links to that existing details page.

Action: Create a Calendar report page and let the link of the data point to the already existing detail page.

The link being the ticket_id ofcourse. Now APEX generates a link filling the #PRIMARY_KEY_VALUE#, but it should fill the “TICKET_ID#.

Interactive reports

Interactive reports are very powerfull tools of Oracle APEX, not only for the developer but also for the user. After the report has been developed you still can filter, sort, hide columns, add aggregates, highlights etc. In the current version APEX 4.1 there are however some limitations that I can’t quite understand. To mention some:

  • A with a filter on a date you cannot specify a time;
  • filtering on alfanumeric fields does not allow using the relations greater than (>), less than (<), greater-or-equal (>=), less-or-equal (<=) and between;
  • aggregate functions like min and max are not possible on alfanumeric fields.

Ofcourse there is the fact that printing of a shown interactive report is not supported. Luckily for us developers 😉

I am still learning to use this great development tool to it’s full potential so I might add some – to me – strange things later.

Herman Mol is powered by WordPress.  Staypressed theme by Themocracy