Edit Data filters are only applied to prefetched rows

[FlavioAttolni]

Description

When I use the “Edit Data” feature on tables with a lot of data, I can't specify a condition in the WHERE clause. The available filters only work on the visible data and the visible page, which makes them unusable.

Original text:

Quando utilizzo l'edit data su tabelle con tanti dati non ho modo di specificare una condizione in where. I filtri che ci sono funzionano solo per i dati visibili e per pagina visibile rendendoli inutilizzabili.

Steps to Reproduce

1. Connessione al Database
2. Click Destro sulla tabella
3. Edit Data

Affected Area

• Connection dialog (SQL Server | Azure browse/Fabric browse)
• Query editor
• Query results panel
• Object Explorer
• GitHub Copilot integration
• Preview/Edit data
• Table Designer
• Schema Designer
• Schema Compare
• Local SQL Server Container provisioning
• SQL database in Fabric provisioning
• DACPAC/BACPAC export/import
• SQL Database projects
• Query Plan Visualizer
• Other (please describe below)

If you selected "Other", please describe the affected area

No response

Environment Information

Ultima Versione per Windows

Confirmation

• I have searched existing issues and couldn't find a match
• I want to work on this issue