Why need identify arcgis rest service source type?
because
Different type of source cause arcgis rest service behave differently
For example, this query HOUSE_NO like '51030' and STREET like 'AVENIDA HERRERA' will failed if the rest service source type is file geodatabase and/or shape file.
This rest service source type is file geodatabase, ERROR is expected.
https://gis.la-quinta.org/arcgis/rest/services/GoGov/goGov2230/MapServer/0/query
This failed query generate a error message in server log see below
However,
SITUS_HOUSE_NO like '13200' will work if the rest service source type is enterprise geodatabase (Microsoft SQL Server and/or Oracle) (Note: the enterprise geodatabase must be registered with ArcGIS Server in order to publish the service as a reference and not a copy)
This rest service source type is enterprise geodatabase ( Microsoft SQL Server )
https://gisservices.interwestgrp.com/externalarcgis/rest/services/Eastvale/Eastvale_GOEnforce/MapServer/1/query
query syntax : Nuber field like 'xxxxx' may work , may not, depends on rest service source type
query syntax : Text field like 'xxxxx' is always work on all type of source
if query syntax : Nuber field like 'xxxxx' works, the source is Enterprise Geodatabase (Microsoft or Oracle)
if query syntax : Nuber field like 'xxxxx' not work, the source is file Geodatabase or Shape file
How to find out arcgis rest service use
Geodatabase (both file and enterprise) or Shape file
Check my other post here:
https://transparentgov.net/cleargov1/847/how-to-turn-on-advanced-queries-in-arcgis-server