ClariFit From/To Date Picker Plug-in Moved to OraOpenSource

This article is for people looking for help with the ClariFit From/To Date Picker.

I’m currently in the process of updating some of the plugins I created for ClariFit to support APEX 5.0. As part of these changes some additional things are happening, mainly listing the plugins in the new apex.world site and moving the plugins ownership over to OraOpenSource.

The first plugin that has been moved/updated is the ClariFit From/To Date Picker. The plugin is now called OraOpenSource From/To Date Picker and is hosted here. To help with backwards compatibility the plugin’s internal name has remained the same. This means that upgrades will be seamless.

Please post all bugs and enhancement requests on the project’s issue page.

The next plugin that will be updated is the ClariFit Dialog (to be called OraOpenSource Dialog). It is currently being tested and will be officially released pending any major bugs. If you’d like any other ClariFit plugins updated to APEX 5.0 please leave a comment and I’ll look into it.

ODTUG Technical Journal - Authors Wanted

If you’ve ever thought of starting your own blog or wanted to write a detailed article on some cool APEX or Oracle feature but didn’t know where to start, now’s your big chance! The ODTUG Technical Journal is looking for some new articles and we’d like to see articles from first time contributors.

Signing up is easy. Simply email Karen Cannell (kcannell@odtug.com) and let her know that you’re interested in writing an article for the journal. Then you can work out a schedule with her. After that, all you need to do is write the article, Karen will take care of the rest.

This is a great opportunity to get your name out there and also promote what you and your organization have been been working on. I’m looking forward to seeing some great content from the APEX community.

ODTUG Election

If you were at Oracle Open World a few weeks ago you may have missed that the ODTUG Board of Directors election results were posted.

The newly elected directors are:

I first must thank all the people that voted for me again this year. It means a lot that I have the support of the APEX and Oracle communities

They’re a few board members who will not be returning next year. They all have done a lot for ODTUG and its members.

  • Monty Latiolais
    • Monty has been the President of ODTUG for the past few years. He’s done an amazing job leading the organization. Monty’s lasting legacy at ODTUG will be the Leadership Program. He took a risk trying it out and it has been a very big success helping develop leaders within the ODTUG community.
  • David Schleis
    • David has helped re-energize the traditional developer and DBA communities. Over the past two years he helped merged them into one united “database” community. I look forward to David to continue help out with the database community in the coming years.
  • Mia Urman

I also need to say a special thank you to the current board for supporting me over the past year. Last year was a very difficult time for me personally and they all stepped up and supported me along the way. This is something I will never forget and will always be thankful for.

As ODTUG has a six year term limit for directors, this will be my last two years. I look forward to making them as good as the first four. If you have any feedback or things you’d like to see happen within the community please let me know.

– Martin

1st Calgary APEX Meetup

We’re having our 1st inaugural APEX meetup on Thursday Nov 12th! I’ll be giving a presentation about APEX 5 and the new apex.world site.
FAQs I’ve received about this meetup:

  • Does it cost anything? No, it’s entirely free
  • What should I bring? Yourself. Some people like to bring their laptop to try things out at the same time.
  • Is this a sales pitch: No, it’s by the APEX community, for the APEX community.
  • Will only APEX items be covered? Primarily we’ll be talking about APEX but may deviate a bit in the future to cover some SQL, PL/SQL, and web technologies. These topics are all relevant for APEX developers.
  • Where can I get one of the cool APEX stickers I see everyone has on Twitter? At the meetup. I’ve got a whole stack to give away.

Location details:
Trident Limited Partnership 1000, 444 - 7 Avenue SW (Barclay building) Calgary, Alberta T2P 0X8
10th floor – Must sign-in at reception desk

Special thanks to Jean Paradis and Trident Limited Partnership for securing the meeting space!

Please RSVP to let us know if you’re coming.

APEX Podcast

If you can’t get enough APEX there’s now an APEX Podcast! This is a great opportunity to know more about the people behind APEX and some key people in the APEX community.

Juergen Schuster and I co-host the show (I only joined on recently) and it has been a lot of fun so far.

You can download each episode on the official site (apex.press/talkshow) or subscribe on iTunes.

Note: In the latest podcast we mentioned that we’re looking for sponsors for the show. If you or your organization is interested in the opportunity please email me.

OOW 15 Presentations

If you’re attending Oracle OpenWorld 2015 this year here are a few links for presentations I’d recommend:

On Tuesday night there will be the APEX meetup. Don’t get their too late since it fills up pretty quickly. We’ll be in the basement.

I’ll also be filming some Periscope interviews for ODTUG. If you can’t attend OOW then you’ll want to follow the ODTUG twitter account. This will be the first time ODTUG has ever done this and we’d appreciate your feedback. If there’s someone you’d like to see interviewed during the conference please let me know below by leaving a comment on this post.

I look forward to seeing everyone there!

ODTUG 2015 Election - Please Vote

The ODTUG Board of Directors election is now officially open. Paid ODTUG members can cast their ballot between Oct 6th - Oct 27th. If you are a paid member you will get an email with the link, username, and voter id.

I am running for the ODTUG Board of Directors and I am looking for your support to continue to help the ODTUG community for another two years.

Here is my official campaign statement:

Over the past four years, I have had the privilege to represent the Oracle APEX Community as a Director for ODTUG. I have made the decision to run again this year for the ODTUG Board and am looking for your support in doing so.

During my four-year tenure, I have been involved in several committees within ODTUG that have helped bring conferences around the world, improved marketing initiatives, and organized developer contests.

I have been able to build strong relationships with other ODTUG Board Members, Oracle employees, and many developers in the APEX community. These relationships have allowed me to be a liaison between all three groups and help relay ideas and opportunities to the appropriate parties. I hope to continue to be able to facilitate open communication over the next two years.

I am looking for your vote to continue as an ODTUG Board Member to represent developers within one of the world’s largest Oracle user groups. Thank you in advance for your support.

Thank you in advance,

Martin

APEX Webinar: From the Community, for the Community

ODTUG will be hosting an APEX webinar on Monday, Oct 19th at 12:00pm EDT. The webinar is about something that several key members of the APEX community have been working on that is “from the community, for the community“. I strongly recommend that everyone attend this webinar.

I can’t say anything more than the above statement and all will be revealed in the webinar. Registration is free, and you can register using this link.

APEX OOW 2015 Meetup

Each year the Oracle APEX community gets together at Oracle Open World (OOW) to have a few beers and catch up. This is a great informal event and its your chance to network with a lot of people in the APEX community and meet some of the gurus and members of the core APEX development team.

We’ll be having the annual APEX OOW Meetup at Johnny Foleys on Tuesday, October 27th at 7:30 onwards. We’ve been their a few times now and it is a really fun night since they have duelling pianos later on in the evening. Don’t show up too late or it may be tough to get in.

243 O’Farrell Street
San Francisco, CA 94102

ODTUG will also be giving away some cool APEX swag!

Looking forward to seeing everyone there!

Martin

Custom Code for Tabular Forms (Part 2)

The previous article covered how to create a Tabular Form with manual code rather than automatic row processing. This article will demonstrate how to change the Tabular Form to modify data from multiple tables using the same Tabular Form.

Modify Tabular Form

Using the example from the previous article, modify the Tabular Form and change the query to:

1
2
3
4
5
6
7
8
9
select
e.empno,
e.empno empno_display,
e.ename,
e.sal,
d.dname
from emp e, dept d
where 1=1
and e.deptno = d.deptno

Edit DNAME

Edit the newly added DNAME column with the following changes:


Modify Page process

Change the page process to use the code snippet below. Note: This isn’t the best example, as the below code will update the department name for each modified employee record. It does highlight is that you can reference and modify data from multiple tables.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
if :empno is null then
-- code to insert emp
null;
else
update emp
set
ename = :ename,
sal = :sal
where empno = :empno;
-- Update dept name
update dept d
set dname = :dname
where 1=1
and d.deptno = (
select e.deptno
from emp e
where e.empno = :empno)
end if;

If you’ve ever developed a true manual tabular form using collections, the above approach covered in this article may be a better alternative to manage and maintain.