Cool software I just found that someone recommended.

“ClipboardPath” software adds a new command “Copy Path to Clipboard” to the context menu for files and folders. Pasting the complete filename or foldername into any dialog or editor is just a mouse click away. You always get the full path. This software is free for end users.

If you’re any sort of Windows geek, you’ll find this indispensible.


This is the main map from their home page.  You can click on the icons under the text to see hover text, then click again to jump to that page, which is an additional concept map.  I like that you can sort of read them as English sentences, while still retaining the relationships of a diagram.

Main page of CmapTools site

Main page of CmapTools site

It looks pretty cool, though I’d think it would be slow to develop each map.  Much slower than a mindmap for example.  But I think having a tool to create these diagrams would be very helpful, especially when they get large and you want to be able to drill down into sub-concepts.

Update: April 16, 2009 – I found and fixed a bug in how it handled the contains clause in the filters.  Stupid me, I’d used contains in other flavors of SQL so never bothered to confirm that Oracle SQL supports it!

Sorry about that!!!

The purpose of this package is to grab the user’s current Filters and Searches and recreate them in a WHERE clause, so I could do some external reporting.  A couple other people have shown me their solutions to this but this is my original work (with a hint from Anton and Shunt).

The little bit extra mine adds that I haven’t seen elsewhere is that it supports User-Saved Reports.  So if a user clicks the report tab for one of their saved reports and possibly customizes it, my routine can figure that out and recreate their current query.

It also supports the user typing a value into the Search box, which Apex matches against all text and numeric fields currently displayed.  That was an amusing trick!  If you care, you can view the query that IR generates by using Debug mode.

What this code does not support is a sort order, since my external report tool has a fixed sort.  Shunt did something that works with sort orders that you should check out here:

If you compare how others handled the various filter options (IN, CONTAINS, etc) versus how I did it, I think you’ll prefer their method.  I know I did, and wished I could have figured it out when I was writing this!  :-/

From the IR report page (e.g. 2), you add the following Javascript to the Page HTML Header:

<script language="JavaScript" type="text/javascript">
function SaveAndRunReport() {
            'P7_IR_REPORT_ID:'+$v('apexir_report_id'), 1024, 768);

You can certainly make a simpler call, mine just happens to use a pop-up page.

In the target page,  (e.g. 7), you can display the WHERE clause by creating an item computed with the following SQL query:

SELECT apex_ir_query.ir_query_where(:APP_ID,
           :P7_IR_REPORT_ID) FROM DUAL;

Here’s the package.  It’s hosted on MediaFire, so you’ll have to live with the ads.

Let me know if you find it useful or have suggestions to offer.

– Stew

[I know this is a bit off-topic for me, but thought it was worth sharing. – Stew]

I happened to catch yesterday’s column in the LA Times titled “Google’s Chrome: Brand new but not so shiny?” by Jessica Guynn.  The point was that Chrome came out with a flurry but it hasn’t affected the total market share of browsers yet.

I had to write the following reply to her, which follows:

I was disappointed that you focused Chrome not taking over the browser market within 2 weeks after it was released.  How negative can you get saying it lost its initial market share gain, rather than reporting that Chrome attracted such interest when it first came out.  I was one of the early-adopters/geeks that downloaded it the day after it was released.  I think it shows strong potential.

I’m using it to send this note, but I have gone back to FireFox for most of my browsing.  Why?  For the same reason everyone else did – this is beta software! I can’t believe your column didn’t mention that little detail anywhere in it.  I would guess that everyone who’s tried Chrome has said

“Hey that’s pretty cool and wicked fast.  I can’t wait until it supports all the great FireFox addons I’m used to, but I gotta get work done so back to FireFox or IE.”

So give credit where credit’s due, huh?

BTW, I have no business relationship with Google other than as a user.
That’s my rant for the day.  Thanks for visiting.

Moving back and forth

June 13, 2008

I stopped maintaining this blog because I’d moved it to the Oracle Community, but that software lacks so many good features that I’m probably moving back.

I’m also trying out free note-taking database software, EverNote, to keep track of all the Oracle Apex tips and tricks I’m learning. It has a web interface as well and says it has a widget I can use to share here, but can’t seem to connect to WordPress. So far… sigh…

That Apex notebook is here:

I’m probably moving back here shortly. I’m so decisive! :-/

MindJet has (finally) officially announced the upcoming release of MindManager version 7 (aka MM7), so beta-testers like me are finally allowed to talk about it publicly! I take my beta-tester responsibilities seriously, so kept it under my hat.

They say it’ll be available for purchase on May 30th, for both PC and Macintosh.

This is the software tool I use the most at work, some days even more than email! It’s great for managing lots of information in various forms and places. If you’ve never seen a mindmap, think “graphical outline.” If you’ve never seen a MindManager mindmap, think “visual organizer with tons of power for integrating, sorting, finding and organizing your information”.

As for what’s in the upgrade… Read the rest of this entry »