We're using an external table connected to a SQL Server data. The table name is GIS_StoneOrchard.dbo.GIS_cemetery_sites. The field names have been given alias names.
After publishing the map service, the resultant REST end point shows the following field names:
If I query the REST end point, the following query fails:
GIS_StoneOrchard.GEOCORTEX.%GIS_cemetery_sites.interred_persons like '%John%'
But if I query the REST end point with the following query, the query is successful:
interred_persons like '%John%'
This is impacting our Geocortex Essentials site where it seems now that when Essentials queries the REST end point, the query is failing.