topic Re: Failed Query from Joined Table with Query Widget (Developer Edition) in ArcGIS Web AppBuilder Questions https://community.esri.com/t5/arcgis-web-appbuilder-questions/failed-query-from-joined-table-with-query-widget/m-p/564265#M15015 <HTML><HEAD></HEAD><BODY><P>Malcolm,</P><P></P><P>&nbsp;&nbsp; I am throwing together a joined service for testing and will let you know the results.</P></BODY></HTML> Wed, 24 Jun 2015 17:49:28 GMT RobertScheitlin__GISP 2015-06-24T17:49:28Z Failed Query from Joined Table with Query Widget (Developer Edition) https://community.esri.com/t5/arcgis-web-appbuilder-questions/failed-query-from-joined-table-with-query-widget/m-p/564262#M15012 <HTML><HEAD></HEAD><BODY><P>I have a standalone table joined with a feature layer.&nbsp; I have set up a query from one of the fields of that joined standalone table but the query fails.&nbsp; Does it not allow for it to return queries from joined tables?&nbsp; I have the configuration in the config_Query.json similar to the other queries, except all other queries are feature layers without a join.&nbsp; Below is the config for the particular query from the feature layer with the joined table.&nbsp; Please ignore the "............" in place of the urls.</P><P></P><PRE class="lia-code-sample line-numbers language-none">{ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "name": "Search by Case Status", <SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "url": "</SPAN><A class="jive-link-external-small" href="http://....................rest/25" rel="nofollow noopener noreferrer" target="_blank">http://....................rest/25</A><SPAN>",</SPAN> <SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "infoWindowTemplate":"&lt;b&gt;${VECTOR.PLAN_PENDING.NAME}&lt;/b&gt;&lt;hr&gt;&lt;b&gt;Case Number&lt;/b&gt;: &lt;a target='_blank' href='</SPAN><A class="jive-link-external-small" href="http://egcap.........../$" rel="nofollow noopener noreferrer" target="_blank">http://egcap.........../$</A><SPAN>{VECTOR.PLAN_PENDING.CASE_}'&gt;${VECTOR.PLAN_PENDING.CASE_}&lt;/a&gt;&lt;br&gt;&lt;b&gt;Case Type:&lt;/b&gt; ${VECTOR.PLAN_PENDING.CASETYPE}&lt;br&gt;&lt;b&gt;Case Status:&lt;/b&gt; ${gisdb.vector.pending_plan_data.status}&lt;br&gt;&lt;b&gt;Staff Report:&lt;/b&gt;&lt;a target ='_blank' href='${VECTOR.PLAN_PENDING.CASELINK}'&gt;Click Here&lt;/a&gt;&lt;br&gt;&lt;b&gt;Acreage:&lt;/b&gt; ${VECTOR.PLAN_PENDING.ACREAGE}&lt;br&gt;&lt;b&gt;Planner:&lt;/b&gt; ${gisdb.vector.pending_plan_data.pln_case_planner}&lt;br&gt;&lt;br&gt;&lt;a href='mailto:${gisdb.vector.pending_plan_data.mail}?subject=Question%20about%20case%20${VECTOR.PLAN_PENDING.CASE_} '&gt;Email Planner&lt;/a&gt;",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN> &nbsp;&nbsp; "filter": { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "logicalOperator": "AND", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "parts": [ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "fieldObj": { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "name": "gisdb.vector.pending_plan_data.status", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "label": "gisdb.vector.pending_plan_data.status", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "shortType": "string", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "type": "esriFieldTypeString" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "operator": "stringOperatorIs", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "valueObj": { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "isValid": true, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "type": "unique", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "value": "Accepted" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "interactiveObj": { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "prompt": "Case Status", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "hint": "Enter Case Status" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "caseSensitive": false, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "expr": "gisdb.vector.pending_plan_data.status = 'Accepted'" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ], &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "expr": "gisdb.vector.pending_plan_data.status = 'Accepted'" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "popup": { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "title": "${VECTOR.PLAN_PENDING.NAME}", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "fields": [ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "name": "VECTOR.PLAN_PENDING.NAME", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "type": "esriFieldTypeString", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "alias": "NAME", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "length": 39, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "domain": null, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "specialType": "none", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "visibility": false, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "showInInfoWindow": false &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }, &nbsp;&nbsp; { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "name": "VECTOR.PLAN_PENDING.CASE_", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "type": "esriFieldTypeString", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "alias": "Case Number", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "length": 13, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "domain": null, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "specialType": "none", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "visibility": false, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "showInInfoWindow": true &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }, &nbsp;&nbsp; { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "name": "VECTOR.PLAN_PENDING.CASETYPE", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "type": "esriFieldTypeString", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "alias": "Case Type", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "length": 13, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "domain": null, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "specialType": "none", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "visibility": false, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "showInInfoWindow": true &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }, &nbsp;&nbsp; { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "name": "gisdb.vector.pending_plan_data.status", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "type": "esriFieldTypeString", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "alias": "Case Status", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "length": 13, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "domain": null, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "specialType": "none", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "visibility": false, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "showInInfoWindow": false &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }, &nbsp;&nbsp; { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "name": "VECTOR.PLAN_PENDING.CASELINK", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "type": "esrifieldtypestring", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "alias": "Staff Report", &nbsp; "length": 255, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "domain": null, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "specialType": "link", &nbsp; "visibility": false, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "showInInfoWindow": false &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }, &nbsp;&nbsp; { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "name": "VECTOR.PLAN_PENDING.ACREAGE", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "type": "esriFieldTypeString", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "alias": "Acreage", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "length": 13, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "domain": null, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "specialType": "none", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "visibility": false, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "showInInfoWindow": false &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }, &nbsp;&nbsp; { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "name": "gisdb.vector.pending_plan_data.pln_case_planner", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "type": "esriFieldTypeString", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "alias": "Planner", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "length": 13, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "domain": null, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "specialType": "none", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "visibility": false, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "showInInfoWindow": false &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }, &nbsp;&nbsp;&nbsp;&nbsp; { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "name": "gisdb.vector.pending_plan_data.mail", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "type": "esriFieldTypeString", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "alias": "Email", &nbsp; "length": 13, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "domain": null, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "specialType": "none", &nbsp; "visibility": false, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "showInInfoWindow": false &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } &nbsp; ] &nbsp;&nbsp;&nbsp; }, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "resultsSymbol": { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "color": [ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 155, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 187, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 89, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 128 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ], &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "outline": { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "color": [ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 115, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 140, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 61, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 255 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ], &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "width": 1.5, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "type": "esriSLS", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "style": "esriSLSSolid" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "type": "esriSFS", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "style": "esriSFSSolid" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "objectIdField": "VECTOR.PLAN_PENDING.OBJECTID" &nbsp;&nbsp;&nbsp; }</PRE></BODY></HTML> Sun, 12 Dec 2021 00:19:12 GMT https://community.esri.com/t5/arcgis-web-appbuilder-questions/failed-query-from-joined-table-with-query-widget/m-p/564262#M15012 MalcolmEchaluce 2021-12-12T00:19:12Z Re: Failed Query from Joined Table with Query Widget (Developer Edition) https://community.esri.com/t5/arcgis-web-appbuilder-questions/failed-query-from-joined-table-with-query-widget/m-p/564263#M15013 <HTML><HEAD></HEAD><BODY><P>Malcolm,</P><P></P><P>&nbsp;&nbsp; What does the web console report as far as any errors?</P></BODY></HTML> Wed, 24 Jun 2015 15:59:35 GMT https://community.esri.com/t5/arcgis-web-appbuilder-questions/failed-query-from-joined-table-with-query-widget/m-p/564263#M15013 RobertScheitlin__GISP 2015-06-24T15:59:35Z Re: Failed Query from Joined Table with Query Widget (Developer Edition) https://community.esri.com/t5/arcgis-web-appbuilder-questions/failed-query-from-joined-table-with-query-widget/m-p/564264#M15014 <HTML><HEAD></HEAD><BODY><P>Robert,</P><P></P><P>The error from the web console is below.&nbsp; My apologies for not having anything beyond this.&nbsp; I'm stumped.</P><P></P><PRE class="lia-code-sample line-numbers language-none"> Error: Failed to execute query. &nbsp;&nbsp;&nbsp; at Error (native) &nbsp;&nbsp;&nbsp; at Object.h.load (<A href="http://js.arcgis.com/3.13/init.js:897:343" rel="nofollow noopener noreferrer" target="_blank">http://js.arcgis.com/3.13/init.js:897:343</A>) &nbsp;&nbsp;&nbsp; at <A href="http://js.arcgis.com/3.13/init.js:191:69" rel="nofollow noopener noreferrer" target="_blank">http://js.arcgis.com/3.13/init.js:191:69</A> &nbsp;&nbsp;&nbsp; at c (<A href="http://js.arcgis.com/3.13/init.js:76:221" rel="nofollow noopener noreferrer" target="_blank">http://js.arcgis.com/3.13/init.js:76:221</A>) &nbsp;&nbsp;&nbsp; at d (<A href="http://js.arcgis.com/3.13/init.js:76:10" rel="nofollow noopener noreferrer" target="_blank">http://js.arcgis.com/3.13/init.js:76:10</A>) &nbsp;&nbsp;&nbsp; at b.Deferred.resolve.callback (<A href="http://js.arcgis.com/3.13/init.js:77:350" rel="nofollow noopener noreferrer" target="_blank">http://js.arcgis.com/3.13/init.js:77:350</A>) &nbsp;&nbsp;&nbsp; at c (<A href="http://js.arcgis.com/3.13/init.js:76:436" rel="nofollow noopener noreferrer" target="_blank">http://js.arcgis.com/3.13/init.js:76:436</A>) &nbsp;&nbsp;&nbsp; at d (<A href="http://js.arcgis.com/3.13/init.js:76:10" rel="nofollow noopener noreferrer" target="_blank">http://js.arcgis.com/3.13/init.js:76:10</A>) &nbsp;&nbsp;&nbsp; at b.Deferred.resolve.callback (<A href="http://js.arcgis.com/3.13/init.js:77:350" rel="nofollow noopener noreferrer" target="_blank">http://js.arcgis.com/3.13/init.js:77:350</A>) &nbsp;&nbsp;&nbsp; at <A href="http://js.arcgis.com/3.13/init.js:195:300x" rel="nofollow noopener noreferrer" target="_blank">http://js.arcgis.com/3.13/init.js:195:300x</A> @ init.js:192(anonymous function) @ init.js:191c @ init.js:76d @ init.js:76b.Deferred.resolve.callback @ init.js:77c @ init.js:76d @ init.js:76b.Deferred.resolve.callback @ init.js:77c @ init.js:76d @ init.js:76b.Deferred.resolve.callback @ init.js:77c @ init.js:76d @ init.js:76b.Deferred.resolve.callback @ init.js:77(anonymous function) @ init.js:195k @ init.js:199m @ init.js:199f.resolve @ init.js:201a @ init.js:200k @ init.js:200m @ init.js:199f.resolve @ init.js:201a @ init.js:200k @ init.js:200m @ init.js:199f.resolve @ init.js:201a @ init.js:200k @ init.js:200m @ init.js:199f.resolve @ init.js:201q @ init.js:160f @ init.js:164 Widget.js:751 Error: Failed to execute query. &nbsp;&nbsp;&nbsp; at Error (native) &nbsp;&nbsp;&nbsp; at Object.h.load (<A href="http://js.arcgis.com/3.13/init.js:897:343" rel="nofollow noopener noreferrer" target="_blank">http://js.arcgis.com/3.13/init.js:897:343</A>) &nbsp;&nbsp;&nbsp; at <A href="http://js.arcgis.com/3.13/init.js:191:69" rel="nofollow noopener noreferrer" target="_blank">http://js.arcgis.com/3.13/init.js:191:69</A> &nbsp;&nbsp;&nbsp; at c (<A href="http://js.arcgis.com/3.13/init.js:76:221" rel="nofollow noopener noreferrer" target="_blank">http://js.arcgis.com/3.13/init.js:76:221</A>) &nbsp;&nbsp;&nbsp; at d (<A href="http://js.arcgis.com/3.13/init.js:76:10" rel="nofollow noopener noreferrer" target="_blank">http://js.arcgis.com/3.13/init.js:76:10</A>) &nbsp;&nbsp;&nbsp; at b.Deferred.resolve.callback (<A href="http://js.arcgis.com/3.13/init.js:77:350" rel="nofollow noopener noreferrer" target="_blank">http://js.arcgis.com/3.13/init.js:77:350</A>) &nbsp;&nbsp;&nbsp; at c (<A href="http://js.arcgis.com/3.13/init.js:76:436" rel="nofollow noopener noreferrer" target="_blank">http://js.arcgis.com/3.13/init.js:76:436</A>) &nbsp;&nbsp;&nbsp; at d (<A href="http://js.arcgis.com/3.13/init.js:76:10" rel="nofollow noopener noreferrer" target="_blank">http://js.arcgis.com/3.13/init.js:76:10</A>) &nbsp;&nbsp;&nbsp; at b.Deferred.resolve.callback (<A href="http://js.arcgis.com/3.13/init.js:77:350" rel="nofollow noopener noreferrer" target="_blank">http://js.arcgis.com/3.13/init.js:77:350</A>) &nbsp;&nbsp;&nbsp; at <A href="http://js.arcgis.com/3.13/init.js:195:300" rel="nofollow noopener noreferrer" target="_blank">http://js.arcgis.com/3.13/init.js:195:300</A></PRE></BODY></HTML> Sun, 12 Dec 2021 00:19:15 GMT https://community.esri.com/t5/arcgis-web-appbuilder-questions/failed-query-from-joined-table-with-query-widget/m-p/564264#M15014 MalcolmEchaluce 2021-12-12T00:19:15Z Re: Failed Query from Joined Table with Query Widget (Developer Edition) https://community.esri.com/t5/arcgis-web-appbuilder-questions/failed-query-from-joined-table-with-query-widget/m-p/564265#M15015 <HTML><HEAD></HEAD><BODY><P>Malcolm,</P><P></P><P>&nbsp;&nbsp; I am throwing together a joined service for testing and will let you know the results.</P></BODY></HTML> Wed, 24 Jun 2015 17:49:28 GMT https://community.esri.com/t5/arcgis-web-appbuilder-questions/failed-query-from-joined-table-with-query-widget/m-p/564265#M15015 RobertScheitlin__GISP 2015-06-24T17:49:28Z Re: Failed Query from Joined Table with Query Widget (Developer Edition) https://community.esri.com/t5/arcgis-web-appbuilder-questions/failed-query-from-joined-table-with-query-widget/m-p/564266#M15016 <HTML><HEAD></HEAD><BODY><P>Malcolm,</P><P></P><P>&nbsp;&nbsp; So based on my testing joined data is not the issue. My recommendation is to remove some fields until you can get the query to work.</P></BODY></HTML> Wed, 24 Jun 2015 17:59:25 GMT https://community.esri.com/t5/arcgis-web-appbuilder-questions/failed-query-from-joined-table-with-query-widget/m-p/564266#M15016 RobertScheitlin__GISP 2015-06-24T17:59:25Z Re: Failed Query from Joined Table with Query Widget (Developer Edition) https://community.esri.com/t5/arcgis-web-appbuilder-questions/failed-query-from-joined-table-with-query-widget/m-p/564267#M15017 <HTML><HEAD></HEAD><BODY><P>Are you referring to fields in my data or the fields in the pop-up configuration from the code snippet I provided? Unfortunately, I'm not going to be able to remove fields from the data itself.&nbsp; </P></BODY></HTML> Wed, 24 Jun 2015 19:36:05 GMT https://community.esri.com/t5/arcgis-web-appbuilder-questions/failed-query-from-joined-table-with-query-widget/m-p/564267#M15017 MalcolmEchaluce 2015-06-24T19:36:05Z Re: Failed Query from Joined Table with Query Widget (Developer Edition) https://community.esri.com/t5/arcgis-web-appbuilder-questions/failed-query-from-joined-table-with-query-widget/m-p/564268#M15018 <HTML><HEAD></HEAD><BODY><P>Malcolm,</P><P></P><P>&nbsp;&nbsp; No I am talking about removing fields from the Query widgets json (not the actual data).</P></BODY></HTML> Wed, 24 Jun 2015 19:38:42 GMT https://community.esri.com/t5/arcgis-web-appbuilder-questions/failed-query-from-joined-table-with-query-widget/m-p/564268#M15018 RobertScheitlin__GISP 2015-06-24T19:38:42Z Re: Failed Query from Joined Table with Query Widget (Developer Edition) https://community.esri.com/t5/arcgis-web-appbuilder-questions/failed-query-from-joined-table-with-query-widget/m-p/564269#M15019 <HTML><HEAD></HEAD><BODY><P>Hi Malcolm,</P><P></P><P>I'm running into the same issue with a CSV joined to a File Geodatabase feature class.&nbsp; I found the following bug:</P><P></P><P><A href="http://support.esri.com/en/bugs/nimbus/QlVHLTAwMDA4Njc3Nw==" title="http://support.esri.com/en/bugs/nimbus/QlVHLTAwMDA4Njc3Nw==">BUG-000086777 - The Query widget in Web AppBuilder generates a "Qu..</A> </P><P></P><P><A href="https://community.esri.com/migrated-users/14085">Robert Scheitlin</A>, what type of feature class/table are you using for the join?</P></BODY></HTML> Fri, 26 Jun 2015 19:40:51 GMT https://community.esri.com/t5/arcgis-web-appbuilder-questions/failed-query-from-joined-table-with-query-widget/m-p/564269#M15019 JakeSkinner 2015-06-26T19:40:51Z Re: Failed Query from Joined Table with Query Widget (Developer Edition) https://community.esri.com/t5/arcgis-web-appbuilder-questions/failed-query-from-joined-table-with-query-widget/m-p/564270#M15020 <HTML><HEAD></HEAD><BODY><P>Jake,</P><P></P><P>&nbsp;&nbsp; I am using a standard SDE table.</P></BODY></HTML> Fri, 26 Jun 2015 19:43:44 GMT https://community.esri.com/t5/arcgis-web-appbuilder-questions/failed-query-from-joined-table-with-query-widget/m-p/564270#M15020 RobertScheitlin__GISP 2015-06-26T19:43:44Z Re: Failed Query from Joined Table with Query Widget (Developer Edition) https://community.esri.com/t5/arcgis-web-appbuilder-questions/failed-query-from-joined-table-with-query-widget/m-p/564271#M15021 <HTML><HEAD></HEAD><BODY><P>Looks like this bug isn't an issue if both the feature class and table reside in the same geodatabase.&nbsp; I imported the CSV file I am using into the same File Geodatabase as my feature class, and I am now able to query on the joined records.</P></BODY></HTML> Fri, 26 Jun 2015 19:59:37 GMT https://community.esri.com/t5/arcgis-web-appbuilder-questions/failed-query-from-joined-table-with-query-widget/m-p/564271#M15021 JakeSkinner 2015-06-26T19:59:37Z