I have a connection to a MSSQL and select statement to a view

SELECT 

      [Parcel]
      ,[Name]
      ,[PropertyAddress]
  FROM [CurrentParcels]

The table shows data

I cannot get the global search or the column filter to return anything.

Yes, this was created in Settings/Separate DB Connection. And then "Create a table linked to an existing source"

I have change the query to

SELECT 
      Parcel
      ,Name
      ,PropertyAddress
  FROM CurrentParcels

The query will not save

I tried 

SELECT 
      Parcel
      ,Name
      ,PropertyAddress
  FROM CurrentParcels

The query will not save.

I got it to save by doing the following

SELECT 
      Parcel
      ,Name
      ,PropertyAddress
  FROM [CurrentParcels]


But this has given me the same results.  The table populates, but will not search or filter.

I also tried

SELECT 
*
  FROM [CurrentParcels]

This populated the table, but will not search or filter.

Also,

I tried disabling Server-side processing, and when I save changes, it re-enables itself.

This does not seem to be a record count issue.  I limited the view in the database to 50 records and has the same results.
I also removed the where clause with the same results.

So as a last ditch effort.....
I created a new view

I copied the view to the new view and saved

I created a new wptable and pointed it to the new view, and it is working well.  I cannot tell the differenct between the old view and new view, nor the old wptable or the ne wptable.