August 3, 2011
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.
March 31, 2009
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.
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.
February 19, 2009
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!
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, 2, :SESSION, :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.
September 26, 2008
[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:
June 13, 2008
I stopped maintaining this blog because I’d moved it to the ning.com 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: http://www.evernote.com/pub/sstryker58/Stews_Apex_tips/
I’m probably moving back here shortly. I’m so decisive!
January 28, 2008
1. Upload your file to the Workspace.
2) If the file is application-specific, assign it to the application.
3) Note the image name in the Shared Components->Files->Images. You’ll need to click on the icon/link for this item and get the image name value from the detail page, because the icon list replaces underscores with spaces and you need the exact name.
4) To reference it, like your company logo that goes on all pages, add something like the following on the Application Definition page in the Logo field:
You can also use this to reference Cascading Style Sheets that you’ve uploaded to your application.
May 10, 2007
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 »