Wish: Query by Example enhancement

[BWendling]

In the SQL window results pane, a menu popup function "Filter by selection" (as in MS Access) would be much more comfortable.

At the moment, I need to:
- Mark and Copy a string in the results pane
- Click "Query by example"
- Paste in specific column
- Click "Query by example" again

 

[ScottMattes]

Have you tried the Linked Query button on the top of the results grid?

 

[BWendling]

That's not helpful because there are no linked tables in my case.

After e.g.
Select asofdate,cptyname,... from counterparty

I want to easily restrict the query to all rows, where asofdate='2004-07-31' just by right clicking into the result column and selecting "filter by selection".

 

[ScottMattes]

I WAS going to say that you could dbl click the cell with the value (to select it) and then right click and do a copy with header and then paste it into the select

BUT

the copy with header DOES NOT work in the result grid. Marco, is this a bug in the feature or in the right click menu having the option displayed at that point?

 

[Marco Kalter]

The "Filter by selection" idea seems nice. The idea is that you see an existing record and want to view all records with a matching set of columns (instead of remembering/retyping or copying/pasting).

"Copy with Header" should be disabled if you have selected a specific piece of text within a cell. We'll fix that.

 

[ScottMattes]

Marco,
Why? My gut feeling is that if the user selects the whole column or one cell or one part of one cell and they want to copy with header they should be able to.

I also like the filter idea.