topic Examples of expressions for query layers that use attributes and geometries?; Query layers responsive to user input in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/examples-of-expressions-for-query-layers-that-use/m-p/847268#M5049 <HTML><HEAD></HEAD><BODY><P>Good morning,</P><P></P><P>I am looking for examples of SQL expressions to use in Make Query Layer that have WHERE statements that include conditions based on attribute values and geometries.&nbsp; The SDE from which I am pulling is an Oracle database.</P><P></P><P>Question 2: Who in a ModelBuilder tool or script tool asked an user to supply a geometry that is then used in a Query Layer SQL statement?</P><P></P><P></P><P>Thank you for your help.</P></BODY></HTML> Fri, 23 Jun 2017 13:42:27 GMT BrooksBreece 2017-06-23T13:42:27Z Examples of expressions for query layers that use attributes and geometries?; Query layers responsive to user input https://community.esri.com/t5/geodatabase-questions/examples-of-expressions-for-query-layers-that-use/m-p/847268#M5049 <HTML><HEAD></HEAD><BODY><P>Good morning,</P><P></P><P>I am looking for examples of SQL expressions to use in Make Query Layer that have WHERE statements that include conditions based on attribute values and geometries.&nbsp; The SDE from which I am pulling is an Oracle database.</P><P></P><P>Question 2: Who in a ModelBuilder tool or script tool asked an user to supply a geometry that is then used in a Query Layer SQL statement?</P><P></P><P></P><P>Thank you for your help.</P></BODY></HTML> Fri, 23 Jun 2017 13:42:27 GMT https://community.esri.com/t5/geodatabase-questions/examples-of-expressions-for-query-layers-that-use/m-p/847268#M5049 BrooksBreece 2017-06-23T13:42:27Z Re: Examples of expressions for query layers that use attributes and geometries?; Query layers responsive to user input https://community.esri.com/t5/geodatabase-questions/examples-of-expressions-for-query-layers-that-use/m-p/847269#M5050 <HTML><HEAD></HEAD><BODY><P>Talking in too abstract of terms is always difficult.&nbsp; For your question 1, it would be helpful if you could provide a couple examples of what you are trying to achieve, e.g., I have three fields (<SPAN style="font-family: courier new,courier,monospace;">field1 (str), field2 (dbl), field3 (date), field4 (geom)</SPAN>) where I want to select all rows <SPAN style="font-family: courier new,courier,monospace;">where field1 = 'x' and field2 &gt; 100. and area(field4) &gt; 10 acres</SPAN>.</P><P></P><P>I don't think providing you with random examples relevant to my work will be useful for you in your work.</P></BODY></HTML> Fri, 23 Jun 2017 18:53:14 GMT https://community.esri.com/t5/geodatabase-questions/examples-of-expressions-for-query-layers-that-use/m-p/847269#M5050 JoshuaBixby 2017-06-23T18:53:14Z