Hi Team,
We have an application which tries to query a feature service layer based on its GLOBALID. The where clause of the query is formed like eg -
GLOBALID IN ('07649fda-c84a-4937-8659-c3ef5901baa8')
This seems to be working on several other FGDBs and Enterprise GDBs and we get the query results both through the application and as well through the REST API endpoint (Query layer).
But on one particular Enterprise geodatabase with Utility Network, the query does not return any values if provided in the above format. It only works when we provide the GLOBALID exactly as it is like eg-
GLOBALID IN ('{07649FDA-C84A-4937-8659-C3EF5901BAA8}')
In both cases , the data type is set to be Global ID in the Fields. Any suggestions would be greatly appreciated..!