bayram.ucuncu

ArcGIS 10.5 Desktop find query is invalid for globalid

Discussion created by bayram.ucuncu on Jan 17, 2018

I am using ArcGIS 10.5 and Postgesql 9.5 database. I have added globalid to my feature class via "Add GlobalIDs" tool. So I want to search a keyword in my feature class :

 

Find

But I this search returns error:

I have looked the postgresql error logs and the query string created like this:

 select  sde.atiksu_donati_noktalari.objectid,  sde.atiksu_donati_noktalari.id,  sde.atiksu_donati_noktalari.tur_id,  sde.atiksu_donati_noktalari.zemin_kot,  sde.atiksu_donati_noktalari.akar_kot,  sde.atiksu_donati_noktalari.derinlik,  sde.atiksu_donati_noktalari.kurum_id,  sde.atiksu_donati_noktalari.firma_id,  sde.atiksu_donati_noktalari.yapim_tarihi,  sde.atiksu_donati_noktalari.veri_id,  sde.atiksu_donati_noktalari.x,  sde.atiksu_donati_noktalari.y,  sde.atiksu_donati_noktalari.ilce_id,  sde.atiksu_donati_noktalari.layer,  sde.atiksu_donati_noktalari.globalid,  sde.atiksu_donati_noktalari.created_user,  sde.atiksu_donati_noktalari.created_date,  sde.atiksu_donati_noktalari.last_edited_user,  sde.atiksu_donati_noktalari.last_edited_date,  sde.atiksu_donati_noktalari.proje_id,  st_asewkb(ST_setSRID(atiksu_donati_noktalari.shape,-1)) AS shape,  sde.atiksu_donati_noktalari.nokta_adi,  isugis.sde.atiksu_donati_noktalari.GDB_GEOMATTR_DATA  from  isugis.sde.atiksu_donati_noktalari   where ((objectid = 1000 or UPPER(id) like '%1000%' or tur_id = 1000 or zemin_kot = 1000 or akar_kot = 1000 or derinlik = 1000 or kurum_id = 1000 or firma_id = 1000 or veri_id = 1000 or x = 1000 or y = 1000 or ilce_id = 1000 or UPPER(layer) like '%1000%' or globalid = 1000 or UPPER(created_user) like '%1000%' or UPPER(last_edited_user) like '%1000%' or UPPER(proje_id) like '%1000%' or UPPER(nokta_adi) like '%1000%'))

The cause of this error is about globalid where clause: globalid = 1000 

If I set the globalid where clause like this globalid = '%1000%'  and run the query on Pgadmin tool, error does not occured: 

I think the ArcMap is generating invalid sql query for globalid in search operations. 

Outcomes