topic Data Reviewer SQL Check with layer join information? in ArcGIS Data Reviewer Questions https://community.esri.com/t5/arcgis-data-reviewer-questions/data-reviewer-sql-check-with-layer-join/m-p/438555#M656 <HTML><HEAD></HEAD><BODY><P>I'm wanting to create an "Execute SQL Check" in the Data Reviewer that queries a feature in my current TOC in ArcMap, based on data that comes from a layer join. I've noticed that in the Select by Attributes dialog, that it will see the joined table attributes and allow me to query off of them, however the Execute SQL Check/Query dialog does not recognize table joins that exist in the TOC. Am I missing something or is this just a limitation of this type of check? </P><P></P><P>I investigated the Table to Table check as an alternative, however the table I want to query off of is a virtual table that is generated via our ArcFM application, so there isn't a 'real' table that I can go directly too, I only have access to the data through the join that is created. </P><P></P><P>Hope that makes sense, thanks in advance for any help!</P></BODY></HTML> Tue, 28 Oct 2014 21:19:45 GMT LisaClark 2014-10-28T21:19:45Z Data Reviewer SQL Check with layer join information? https://community.esri.com/t5/arcgis-data-reviewer-questions/data-reviewer-sql-check-with-layer-join/m-p/438555#M656 <HTML><HEAD></HEAD><BODY><P>I'm wanting to create an "Execute SQL Check" in the Data Reviewer that queries a feature in my current TOC in ArcMap, based on data that comes from a layer join. I've noticed that in the Select by Attributes dialog, that it will see the joined table attributes and allow me to query off of them, however the Execute SQL Check/Query dialog does not recognize table joins that exist in the TOC. Am I missing something or is this just a limitation of this type of check? </P><P></P><P>I investigated the Table to Table check as an alternative, however the table I want to query off of is a virtual table that is generated via our ArcFM application, so there isn't a 'real' table that I can go directly too, I only have access to the data through the join that is created. </P><P></P><P>Hope that makes sense, thanks in advance for any help!</P></BODY></HTML> Tue, 28 Oct 2014 21:19:45 GMT https://community.esri.com/t5/arcgis-data-reviewer-questions/data-reviewer-sql-check-with-layer-join/m-p/438555#M656 LisaClark 2014-10-28T21:19:45Z Re: Data Reviewer SQL Check with layer join information? https://community.esri.com/t5/arcgis-data-reviewer-questions/data-reviewer-sql-check-with-layer-join/m-p/438556#M657 <HTML><HEAD></HEAD><BODY><P>Yes, this is a limitation to the Execute SQL check.&nbsp; It does not support joins in ArcMap.&nbsp; But it sounds like a really good enhancement request! <IMG src="https://community.esri.com/legacyfs/online/emoticons/wink.png" /></P></BODY></HTML> Fri, 03 Apr 2015 18:29:50 GMT https://community.esri.com/t5/arcgis-data-reviewer-questions/data-reviewer-sql-check-with-layer-join/m-p/438556#M657 MichelleJohnson 2015-04-03T18:29:50Z