
Define the table or view
I created this Blog to share my knowledge especially in Oracle Application Express (APEX) and my feelings ...

Define the table or view
Posted by
Dimitri Gielis
at
15:22
1 comments
Labels: apex 4, build query, chart


Posted by
Dimitri Gielis
at
11:55
7
comments
Labels: apex 4, chart, font color, grid
Now, if you want your chart to start with e.g. 500 instead of 0 you need to define the axis minimum value.
This is in fact a known bug in APEX 4 (bug id 11700598), or you can read on it in this forum thread. Basically the Axes Settings should show the Y Axis Min instead of the X Axis.
So now you can change the type back to 3D Bar Chart and you see it applied the start value correctly (the axis start now from 500).
My recommendation to the APEX Development team would be that either we see both X and Y Axis min and max or add a dynamic action to the drop down list of the chart type to dynamically show the appropriate axis. (next to fixing the bug)
Posted by
Dimitri Gielis
at
10:18
3
comments
Something surprised me in APEX 4.0.2.00.07 (and probably entire 4.0).

Posted by
Dimitri Gielis
at
20:35
2
comments
It seems to me that in APEX 4.0.2.00.07 (and probably entire 4.0, but can't check at the moment) there's a bug with adding markers to your (bar/column) chart. For a Pie chart it works fine.
If you edit your Chart Attributes you can define a Marker in the Display Settings.

- add another Series in the chart of type Marker, but this is not my preferred option because you lose performance as it will need to run the query twice.
Posted by
Dimitri Gielis
at
19:49
2
comments
Posted by
Dimitri Gielis
at
21:38
0
comments
Labels: obug
I really like surfing on my iPad whenever I'm not behind my laptop.

Posted by
Dimitri Gielis
at
10:15
2
comments

Posted by
Dimitri Gielis
at
09:50
6
comments

Posted by
Dimitri Gielis
at
08:19
4
comments
Labels: apexblogs
Just a quick note to say that there's a new patch for Oracle Application Express that fixes a number of issues and also adds some enhancements to APEX (e.g. two new themes, API additions to APEX_UTIL etc.)
Posted by
Dimitri Gielis
at
09:28
2
comments
Labels: apex 4.0.2
The APEX Development team updated the Statement of Direction for the future releases of Oracle Application Express.
Posted by
Dimitri Gielis
at
11:53
3
comments
Labels: apex 4.1

Posted by
Dimitri Gielis
at
08:15
0
comments
Labels: apexblogs
I'll have to push back the release of APEXBlogs version 2 for some time. Most of the development is completed, but I'm still working on the new UI of the site. Before going live I also want to do some blog posts about what will be in this release, so if some of you have comments I can still consider these and possibly make changes. There are at least five other blog posts waiting, before the go-live...
At this stage it aggregates the Oracle Plugins page and the Community Plugins rss feed. I decided to keep it like that for now and am not including other personal links to APEX plugins, but might consider to do that in the future if I see they don't get posted in the ones I aggregate now.
Posted by
Dimitri Gielis
at
20:18
3
comments
Labels: apexblogs
Another new feature of APEXBlogs v2 will be the synchronisation of Tweets with the hashtags of #apexblogs and/or #orclapex.
select *
from xmltable(xmlnamespaces('http://www.w3.org/2005/Atom' as "AE"), '//AE:entry'
passing httpuritype('http://search.twitter.com/search.atom?q=apexblogs').getxml()
columns title varchar2(250) path '/AE:entry/AE:title/text()'
);

Posted by
Dimitri Gielis
at
20:39
2
comments
Labels: apexblogs
The main reason for APEXBlogs was to aggregate the blog posts and be able to search in an easy manner.

Posted by
Dimitri Gielis
at
13:44
0
comments
Labels: apexblogs

Posted by
Dimitri Gielis
at
08:48
6
comments
This post is part of the The 10 days of APEXBlogs.

Posted by
Dimitri Gielis
at
18:51
2
comments
Labels: apexblogs
On March 29, 2011 the Oracle Benelux User Group (OBUG) will hold its 4th OBUG Benelux Connect.
As in previous years, this event is being organized in close collaboration with Oracle.
Possibly you were one of the 700 visitors who attended the 2010 event at the Papendal Conference Centre in Arnhem, The Netherlands in March earlier this year and you are eager to present your customer case at the upcoming OBUG Benelux Connect 2011.
OBUG Benelux 2011 will be held at SQUARE Brussels Meeting Centre in Brussels, Belgium. Square is housed in an elegant, architecturally significant building originally constructed for the 1958 World Expo.
The theme for OBUG Benelux Connect 2011 is "The Real User Experience".
The strength of OBUG Benelux Connect is the customer cases presented by OBUG members and other Oracle customers. Learn from peers to maximise the value of your business-critical applications and technology.
Speakers will share their experiences and business solutions with you in more than 40 sessions scheduled in different streams: Applications (Oracle eBS, Peoplesoft, Siebel, JD Edwards, Primavera), Technology (DBMS, JDeveloper/ADF, etc.), Middleware (BPEL, SOA, EAS, etc.) & Business Intelligence (Hyperion, OBI, GRC, etc.). There will also be a complete APEX track.
CALL FOR PRESENTATIONS
End-users, project leaders, implementers, IT and functional managers and CIO´s share your experience with Oracle products in a 45-minute presentation – (slides to be prepared in
English, presentations to be given preferably in English). You can submit your abstract here.
Posted by
Dimitri Gielis
at
23:24
0
comments
Labels: obug connect 2011
| ACE Director |
Need to export to PDF, Excel, HTML, ... or print data in the Oracle database and APEX?
Need to manipulate images and other media in the Oracle database and APEX?
Searching for awesome plug-ins for Oracle APEX?
Want to get insight into your Oracle APEX apps?