MS SQL: Filtered Export is Empty

[caseydwyer]

Which driver are you using and version of it (Ex: PostgreSQL 10.0):

Microsoft SQL Server 2008 R2 (SP3) - 10.50.6220.0 (X64)

Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81):

Build 182

The steps to reproduce this issue:

• Open an MS SQL table
• Filter on one column, in a way that you get 1+ results
• Export as CSV (NULL to EMPTY = FALSE | line break to space = FALSE | field names in first row = TRUE)
• Confirm your Export query looks like:

SELECT TOP -1 * FROM [dbo].[table] WHERE [field] LIKE '%search%' ORDER BY [field]

Export to a CSV and check that file is empty.

[caseydwyer]

@huyphams Sorry to ping you, I know you're probably swamped, but wanted to see if you had any thoughts on what might be the issue here. I've got a bit of an urgent need to export some data before the end of this week, if possible. TIA!

[huyphams]

Hi, we're working on this issue. In the meantime, you can copy the query to sql query, remove the top -1, then run it and export the result manually. Sorry for the issue

[caseydwyer]

No problem, thanks so much for the quick update & workaround! 👍