Devart Forums

Hello,

Is it possible to only export filtered data from a Data view in dbForge Studio for SQL? If so, can you please explain how to export filtered data from a table. Here is what I am doing... I am using the database explorer, and viewing the data in a table. I have applied a filter, so I am now seeing only the filtered data. I click on the export data button. It exports all rows ignoring the filter. Am I missing something?

Thank you for your help,

Jordan

I'm guessing you are using the Export Data... in table context menu in Database Explorer.
Try using the Export Data button in DataView of your filtered data. There is a button in DataView toolbar. It works ok for me.

Please let us know if any questions arise.

I found a way to do it, by going directly to the Data Export function from the start screen. It's not as intuitive as using the database explorer first, but it works for now.

Thank you for your help.

Or, you can use this button like I said:

That button only works when the filtering is done as part of the SQL statement. But it does not work when filtered through the column filter or filter editor.

That button only works when the filtering is done as part of the SQL statement. But it does not work when filtered through the column filter or filter editor.

I don't know what you are doing, but it works for me perfectly with filters.