I have a standalone table joined with a feature layer. I have set up a query from one of the fields of that joined standalone table but the query fails. Does it not allow for it to return queries from joined tables? I have the configuration in the config_Query.json similar to the other queries, except all other queries are feature layers without a join. Below is the config for the particular query from the feature layer with the joined table. Please ignore the "............" in place of the urls.
{
"name": "Search by Case Status",
"url": "http://....................rest/25",
"infoWindowTemplate":"<b>${VECTOR.PLAN_PENDING.NAME}</b><hr><b>Case Number</b>: <a target='_blank' href='http://egcap.........../${VECTOR.PLAN_PENDING.CASE_}'>${VECTOR.PLAN_PENDING.CASE_}</a><br><b>Case Type:</b> ${VECTOR.PLAN_PENDING.CASETYPE}<br><b>Case Status:</b> ${gisdb.vector.pending_plan_data.status}<br><b>Staff Report:</b><a target ='_blank' href='${VECTOR.PLAN_PENDING.CASELINK}'>Click Here</a><br><b>Acreage:</b> ${VECTOR.PLAN_PENDING.ACREAGE}<br><b>Planner:</b> ${gisdb.vector.pending_plan_data.pln_case_planner}<br><br><a href='mailto:${gisdb.vector.pending_plan_data.mail}?subject=Question%20about%20case%20${VECTOR.PLAN_PENDING.CASE_} '>Email Planner</a>",
"filter": {
"logicalOperator": "AND",
"parts": [
{
"fieldObj": {
"name": "gisdb.vector.pending_plan_data.status",
"label": "gisdb.vector.pending_plan_data.status",
"shortType": "string",
"type": "esriFieldTypeString"
},
"operator": "stringOperatorIs",
"valueObj": {
"isValid": true,
"type": "unique",
"value": "Accepted"
},
"interactiveObj": {
"prompt": "Case Status",
"hint": "Enter Case Status"
},
"caseSensitive": false,
"expr": "gisdb.vector.pending_plan_data.status = 'Accepted'"
}
],
"expr": "gisdb.vector.pending_plan_data.status = 'Accepted'"
},
"popup": {
"title": "${VECTOR.PLAN_PENDING.NAME}",
"fields": [
{
"name": "VECTOR.PLAN_PENDING.NAME",
"type": "esriFieldTypeString",
"alias": "NAME",
"length": 39,
"domain": null,
"specialType": "none",
"visibility": false,
"showInInfoWindow": false
},
{
"name": "VECTOR.PLAN_PENDING.CASE_",
"type": "esriFieldTypeString",
"alias": "Case Number",
"length": 13,
"domain": null,
"specialType": "none",
"visibility": false,
"showInInfoWindow": true
},
{
"name": "VECTOR.PLAN_PENDING.CASETYPE",
"type": "esriFieldTypeString",
"alias": "Case Type",
"length": 13,
"domain": null,
"specialType": "none",
"visibility": false,
"showInInfoWindow": true
},
{
"name": "gisdb.vector.pending_plan_data.status",
"type": "esriFieldTypeString",
"alias": "Case Status",
"length": 13,
"domain": null,
"specialType": "none",
"visibility": false,
"showInInfoWindow": false
},
{
"name": "VECTOR.PLAN_PENDING.CASELINK",
"type": "esrifieldtypestring",
"alias": "Staff Report",
"length": 255,
"domain": null,
"specialType": "link",
"visibility": false,
"showInInfoWindow": false
},
{
"name": "VECTOR.PLAN_PENDING.ACREAGE",
"type": "esriFieldTypeString",
"alias": "Acreage",
"length": 13,
"domain": null,
"specialType": "none",
"visibility": false,
"showInInfoWindow": false
},
{
"name": "gisdb.vector.pending_plan_data.pln_case_planner",
"type": "esriFieldTypeString",
"alias": "Planner",
"length": 13,
"domain": null,
"specialType": "none",
"visibility": false,
"showInInfoWindow": false
},
{
"name": "gisdb.vector.pending_plan_data.mail",
"type": "esriFieldTypeString",
"alias": "Email",
"length": 13,
"domain": null,
"specialType": "none",
"visibility": false,
"showInInfoWindow": false
}
]
},
"resultsSymbol": {
"color": [
155,
187,
89,
128
],
"outline": {
"color": [
115,
140,
61,
255
],
"width": 1.5,
"type": "esriSLS",
"style": "esriSLSSolid"
},
"type": "esriSFS",
"style": "esriSFSSolid"
},
"objectIdField": "VECTOR.PLAN_PENDING.OBJECTID"
}
