Ok, this is the first of (what I hope will be) a recurring feature on this blog: a post about one of the hidden gems of APEX. Little bits of functionality that casual users–and sometimes, even power users–aren't aware of, but which are really useful.
Today's installment is the “Query on Selected Table” functionality, which I only found out about because my manager caught me in a sloppy moment and showed me how to do things better.
I was adding a feature to the packaged applications which are a central part of the upcoming 4.2 release, and needed to add a report on a table to each of the applications. Each report had to refer to a different table, and I was working quickly, so I'd taken a shortcut: the report queries were simply “select * from