Toad World® Forums

Definition Window - Data Tab - Filter

If I hit control-enter to “Go to Definition” while the mouse is on a table name from the sql editor it opens the definition window and I can go to the Data. How do I filter the rows or add a where clause so that I can find the row I want to edit in there?

Hi Wesley,

Welcome to Quest Community.

Currently there’s no filter option available in the Data tab. You can build up your query with where clause in the Code Editor. Make sure the button “Updateable ON” is pressed(see attached screen shot), and then hit F9 to run. Data pane will be shown on the bottom of the editor and you can edit any row you want to.

Let me know if you still have any question.

Thanks,
Vincent
EditData.jpeg