topic Duplicate definition queries appearing for a specific query in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/duplicate-definition-queries-appearing-for-a/m-p/350048#M15453 <HTML><HEAD></HEAD><BODY><P>For a specific feature class/feature layer, every time I close the Layer Properties-&gt;Definition Query dialog and then reopen it, I get a duplicate definition query. It's the same exact query, just another one. Every time I close and reopen, a new one appears.</P><P></P><P>I'm on Pro 2.3.3.&nbsp;</P><P></P><P>It appears that it has something to do with the&nbsp;query itself since this is only happening for a specific query, but happens on a&nbsp;fgdb feature class and a hosted feature layer (basically same FC but published to AGOL).</P><P></P><P>The query is</P><P></P><P>(polygon_id NOT LIKE 'FY19-Rapid-_____-____-_' AND<BR />polygon_id NOT LIKE 'FY19-Rapid-_____-____-__' AND polygon_id NOT LIKE 'FY19-Intensive-_____-____-_' AND polygon_id NOT LIKE 'FY19-Intensive-_____-____-__') OR polygon_id IS NULL</P><P></P><P>Has anyone else seen this behavior? Anything wrong with this WHERE clause?</P><DIV dir="ltr"><DIV dir="ltr"></DIV></DIV></BODY></HTML> Thu, 30 May 2019 21:05:42 GMT JimmyKnowles 2019-05-30T21:05:42Z Duplicate definition queries appearing for a specific query https://community.esri.com/t5/arcgis-pro-questions/duplicate-definition-queries-appearing-for-a/m-p/350048#M15453 <HTML><HEAD></HEAD><BODY><P>For a specific feature class/feature layer, every time I close the Layer Properties-&gt;Definition Query dialog and then reopen it, I get a duplicate definition query. It's the same exact query, just another one. Every time I close and reopen, a new one appears.</P><P></P><P>I'm on Pro 2.3.3.&nbsp;</P><P></P><P>It appears that it has something to do with the&nbsp;query itself since this is only happening for a specific query, but happens on a&nbsp;fgdb feature class and a hosted feature layer (basically same FC but published to AGOL).</P><P></P><P>The query is</P><P></P><P>(polygon_id NOT LIKE 'FY19-Rapid-_____-____-_' AND<BR />polygon_id NOT LIKE 'FY19-Rapid-_____-____-__' AND polygon_id NOT LIKE 'FY19-Intensive-_____-____-_' AND polygon_id NOT LIKE 'FY19-Intensive-_____-____-__') OR polygon_id IS NULL</P><P></P><P>Has anyone else seen this behavior? Anything wrong with this WHERE clause?</P><DIV dir="ltr"><DIV dir="ltr"></DIV></DIV></BODY></HTML> Thu, 30 May 2019 21:05:42 GMT https://community.esri.com/t5/arcgis-pro-questions/duplicate-definition-queries-appearing-for-a/m-p/350048#M15453 JimmyKnowles 2019-05-30T21:05:42Z