AnsweredAssumed Answered

Failed Query from Joined Table with Query Widget (Developer Edition)

Question asked by mechaluce on Jun 24, 2015
Latest reply on Jun 26, 2015 by jskinner-esristaff

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"
    }

Outcomes