Search Tables

Dan Griffin

March 28, 2012 06:13

Hello,

The new Search Tables feature in GE3.8. doesn't seem to work with a Data Connection that I've previously defined in my map.  The data connection is to SQL Server and seems to be working fine.  The search shows up in the REST endpoint but no records are returned?

Any ideas?

 

    <SearchTable Command="SELECT GIS_ID, Owner1 FROM DOSSDE.GISDA.ROLL_MAIS WHERE Owner1 LIKE @Owner" DataConnectionID="0" DisplayName="StrataSearch" ID="StrataSearch" MaximumRecords="1000">

 

      <Parameters>

 

        <Parameter Name="Owner" />

 

      </Parameters>

 

    </SearchTable>

 

 

0

• 

  Ryan Cooney

  March 30, 2012 23:27

  If there are no errors in the logs my first guess would be that there is an issue with the "LIKE" part of the query. Usually with a LIKE statement you'll need to add wildcards. You also may need to make the query case insensitive.

  Can you try changing the query to be an exact match and test it to see if we can get any results?

  SELECT GIS_ID, Owner1 FROM DOSSDE.GISDA.ROLL_MAIS WHERE Owner1 = @Owner

  If that doesn't work try something that will always return results like:

  SELECT TOP(10)  GIS_ID, Owner1 FROM DOSSDE.GISDA.ROLL_MAIS WHERE 1=1 OR  Owner1 = @Owner

  --Ryan

  0
• 

  Dan Griffin

  April 03, 2012 04:37

  This worked:  WHERE OWNER1 LIKE '%' + @Owner + '%'

  0

Please sign in to leave a comment.