https://community.esri.com/t5/arcgis-pro-questions/expression-query-not-reliable/m-p/1114078#M47514 <P>Thanks for the reply Josh. Once I build the expression and switch to SQL, it does show the previous value. But, the error does not happen when I build the expression in SQL.&nbsp;</P> Thu, 04 Nov 2021 14:58:39 GMT SujanShrestha 2021-11-04T14:58:39Z https://community.esri.com/t5/arcgis-pro-questions/expression-query-not-reliable/m-p/1113807#M47478 <P>Something weird is going on with ArcGIS Pro. When build a expression in "Select by Attribute", the selection set keeps reverting back to the older/previous query, or the Value field becomes empty, erasing the options I selected. This is a real pain and a major source of data error. This even happens in the Def Queries I build.&nbsp;<BR /><BR />Would appreciate any help!&nbsp;<BR /><BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Issue1.png" style="width: 647px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/26732i7128FA6966619423/image-size/large?v=v2&amp;px=999" role="button" title="Issue1.png" alt="Issue1.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Issue2.png" style="width: 645px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/26731i9CD4E9EAEA49CA10/image-size/large?v=v2&amp;px=999" role="button" title="Issue2.png" alt="Issue2.png" /></span></P> Wed, 03 Nov 2021 21:40:20 GMT https://community.esri.com/t5/arcgis-pro-questions/expression-query-not-reliable/m-p/1113807#M47478 SujanShrestha 2021-11-03T21:40:20Z https://community.esri.com/t5/arcgis-pro-questions/expression-query-not-reliable/m-p/1113809#M47479 <P>Sounds like a bug, honestly. If you switch the query to SQL, is that <EM>also </EM>showing the previous value? I would attempt writing/modifying your query in SQL to see if it performs differently, to see if the issue is just with the clause builder, or the definition queries in general.</P> Wed, 03 Nov 2021 21:42:46 GMT https://community.esri.com/t5/arcgis-pro-questions/expression-query-not-reliable/m-p/1113809#M47479 jcarlson 2021-11-03T21:42:46Z https://community.esri.com/t5/arcgis-pro-questions/expression-query-not-reliable/m-p/1114078#M47514 <P>Thanks for the reply Josh. Once I build the expression and switch to SQL, it does show the previous value. But, the error does not happen when I build the expression in SQL.&nbsp;</P> Thu, 04 Nov 2021 14:58:39 GMT https://community.esri.com/t5/arcgis-pro-questions/expression-query-not-reliable/m-p/1114078#M47514 SujanShrestha 2021-11-04T14:58:39Z