Toad World® Forums

13.2.0.146 How to use Grid Column/Data Find?

I tried to find a connection in the "New Connection" dialog using Ctrl+F.

Checked "Filter Data", selected the corresponding column and typed some text.
The list in the background is filtered as expected, but when I press OK (or Cancel), the list displays all elements again and one of the matches is selected.

"Find Data" seems to find the first entry, but I do not know how to continue my search.

As the grid filters in the background and you see the row you want, you can use up/down arrow on your keyboard to move to the record that you want. then when you close the find dialog, that record will remain selected.

If you want a more permanent filter...

  • if the dataset is large, your best bet is the where clause.
  • if the dataset is not so large, in the editor, you can use the column header filters
  • in SB-Tables, you can use the column header filters or the filter/sort dialog (first toolbar button above the grid)

I'm afraid I don't know how to make this work with the arrow keys.

I have this dialog, and depending on the current selection the arrow keys either select another column, switch to recently entered values(?) or changes the selection. I cannot move the focus to the "New connection" dialog.

What am I missing? Thanks!

image

Oh, you are working against the login grid. Sorry, I was working against a query result grid.

you're right, It doesn't work as I described on the login grid. Seems like a bug. I'll take a look at that. Hmm, and now that I re-try on a query result grid, it doesn't work there anymore either.

As a workaround, I think the easiest way to search in the login window is click the column header that you want to search, then start typing in that column and it will jump down to find matching data.

Fixed for next beta. Also I added pgup/pgdown.