search

dbcodeio / public

The Power of Databases, The Convenience of VS Code: All in One Place
15 stars 0 forks source link

Advanced filtering for table data #40

Open DIMANRUS opened 3 weeks ago

DIMANRUS commented 3 weeks ago

Hello. I would like to edit the SQL code after I open the table to select specific data and edit it, as it happens in Azure Data Studio and SSMS. I can't do this through the filter, since the data that was received is filtered there, but I have a limit of 5000 rows and, for example, the record is not included in these rows. I hope you understand what I wrote. Thank you.

mikeburgh commented 3 weeks ago

Yes, I follow what you mean..

The 5000 limit though, did you set that in settings ? default is 100,000 and you can change that by right clicking the table and choosing the open with limit option... Not a perfect fix if your table has 10 million rows.

DIMANRUS commented 3 weeks ago

Yes, I set this limit in the settings. But I have more than 100,000 rows in the tables, I don't want to cause problems for vs code with display))

mikeburgh commented 3 weeks ago

Yeah makes sense, let me think about how to make that workable from the UI side.. I want to try and keep all "SQL" inside a real vscode editor so you get all the editor benefits.. I could let you open it in a new tab, and then when you execute it the results will show in the panel, and you can then drag those into the window when #37 is done.. or maybe a keyboard modifier to execute to a new window rather than the panel (saves a few steps)