Table Search works from endpoint but not Global search

Permanently deleted user

January 18, 2013 08:35

I'm working on a table search to a SQL Server view.  The search works from the endpoint that was created when the search was created in REST Manager but the search doesn't work from the Global Search field. 

Here's my command: 

SELECT WellUseDescription, WUWN, AnalytesDescription FROM GroundWater.dbo.v_LabSample WHERE AnalytesDescription LIKE '%' + @AnalytesDescription + '%'

I also tried:

SELECT WellUseDescription, WUWN, AnalytesDescription FROM GroundWater.dbo.v_LabSample WHERE AnalytesDescription = @AnalytesDescription

Both of those work from the endpoint.

The datalink from the layer to the table works fine.  Is it possible the Global Search is failing because it's a view rather than a table?

 

 

0

• 

  Permanently deleted user

  January 23, 2013 00:05

  I found a typo in the table search configuration.  Global search does appear to work with a SQL View.

  0

Please sign in to leave a comment.