topic Creating Query layer sets all fields in select query as OID fileds in 911 GIS Questions https://community.esri.com/t5/911-gis-questions/creating-query-layer-sets-all-fields-in-select/m-p/705393#M7 <HTML><HEAD></HEAD><BODY><P>In ArcMap, I tried creating a QueryLayer with query "Select Id, StartDate, EndDate... from view_viewname" but instead of setting Id as OID field it sets rest of the fields in the select query as OIDFields.</P><P>Its an Oracle database where the view is residing. I dont&nbsp;face similar issues with sql&nbsp;server database.</P></BODY></HTML> Tue, 12 Jun 2018 17:12:22 GMT JayN 2018-06-12T17:12:22Z Creating Query layer sets all fields in select query as OID fileds https://community.esri.com/t5/911-gis-questions/creating-query-layer-sets-all-fields-in-select/m-p/705393#M7 <HTML><HEAD></HEAD><BODY><P>In ArcMap, I tried creating a QueryLayer with query "Select Id, StartDate, EndDate... from view_viewname" but instead of setting Id as OID field it sets rest of the fields in the select query as OIDFields.</P><P>Its an Oracle database where the view is residing. I dont&nbsp;face similar issues with sql&nbsp;server database.</P></BODY></HTML> Tue, 12 Jun 2018 17:12:22 GMT https://community.esri.com/t5/911-gis-questions/creating-query-layer-sets-all-fields-in-select/m-p/705393#M7 JayN 2018-06-12T17:12:22Z