DASH

Export Maps with Joins

Discussion created by DASH on Oct 3, 2011
Latest reply on Feb 8, 2012 by DASH
I've run into a bit of a stumbling block when trying to use a join within the context of a dynamic layer. I've included some details about my test environment; I've also included a working dynamic layers rendering request without a join and a broken request with a join. I am hoping someone is able to spot my error.

Environment:
    ArcServer 10.1 Beta 1
    ArcSDE 9.1
    Oracle 10gR2

The connection within the MapService is registered as the schema owner (VRIMSD_ADMIN); this user is not a DBA.

The VRIMSD_ADMIN.FOREST_COVER_OBJECT table is a spatially enabled SDO table; VRIMSD_ADMIN.FOREST_COVER_OBJECT.FOREST_COVER_OBJECT_ID is registered as the obid column.

The VRIMSD_ADMIN.VEGETATION_COVER_POLYGON_EST table does not have any spatial components and is registered with SDE. There is a 1-1 relationship from the FOREST_COVER_OBJECT table to the VEGETATION_COVER_POLYGON_EST table.

*** WORKS ***
[
  {
    "id": "VRIMSD_ADMIN.FOREST_COVER_OBJECT",
    "source": {
           "type": "dataLayer",
      "dataSource":
      {
            "type": "table",
            "workspaceId": "VegWrk",
            "dataSourceName": "VRIMSD_ADMIN.FOREST_COVER_OBJECT"
             }
    },
    "drawingInfo":
    {
      "renderer":
      {
        "type": "simple",
        "symbol":
        {
          "type" : "esriSFS",
          "style" : "esriSFSSolid",
          "color" : [166,36,0,255],
          "outline" :
          {
            "type" : "esriSLS",
            "style" : "esriSLSSolid",
            "color" : [0,255,0,255],
            "width" : 2
          }
        },
        "description": ""
      },
      "transparency": 60
    }
  }
]

*** RETURNS A WHITE IMAGE ***
[
  {
    "id": "VRIMSD_ADMIN.FOREST_COVER_OBJECT",
    "source": {
      "type": "joinTable",
      "leftTableSource":
      {
           "type": "dataLayer",
      "dataSource":
      {
            "type": "table",
            "workspaceId": "VegWrk",
            "dataSourceName": "VRIMSD_ADMIN.FOREST_COVER_OBJECT"
             }
      },
      "rightTableSource":
      {
           "type": "dataLayer",
            "dataSource":
            {
               "type": "table",
               "workspaceId": "VegWrk",
                "dataSourceName": "VRIMSD_ADMIN.VEGETATION_COVER_POLYGON_EST"
            }
      },  
      "leftTableKey": "VRIMSD_ADMIN.FOREST_COVER_OBJECT.FOREST_COVER_OBJECT_ID",
      "rightTableKey": "VRIMSD_ADMIN.VEGETATION_COVER_POLYGON_EST.FOREST_COVER_OBJECT_ID",
      "joinType": "esriLeftOuterJoin"
    },
    "drawingInfo":
    {
      "renderer":
      {
        "type": "simple",
        "symbol":
        {
          "type" : "esriSFS",
          "style" : "esriSFSSolid",
          "color" : [166,36,0,255],
          "outline" :
          {
            "type" : "esriSLS",
            "style" : "esriSLSSolid",
            "color" : [0,255,0,255],
            "width" : 2
          }
        },
        "description": ""
      }
    }
  }
]

Outcomes