That’s unfortunately this won’t make it into the next release – I just spoke with our users about finally switching over from BrioQuery to TDA and this is one of the key problems that is preventing them from doing so. Looks like I’m back to looking at other solutions.
For the record, the first attached image is exactly what we’re looking for. It’s from Toad for Oracle’s schema browser data grid filter.
By comparison, in TDA I can get a list of values and choose one value, then I have to type the rest of the values in the box. After which, the where clause looks something like this:
WHERE (“V_$SESSION”.LOGON_TIME IN
(‘8/4/2009 3:21:21 AM’, ‘8/4/2009 3:21:22 AM’))
When I execute the query I get:
Toad for Data Analysts Beta: ORA-01843: not a valid month
due to TDA not putting in the to_date function properly (I get the same results for only one value as well) so I have to manually put in to_date functions on all of the time/date values in the list (it works fine if I use the “=” operator instead of the “IN” operator.)
I’m not sure why this is considered an enhancement and not a bug fix – seems like a lot of manual work to get the query to execute, I might as well just write the query manually.