AnsweredAssumed Answered

JS API JoinDataSource - JoinType

Question asked by mahtab.gis on Sep 19, 2014
Latest reply on Jun 17, 2015 by mahtab.gis

I am working on a JavaScrip app using https://developers.arcgis.com/javascript/jsapi/joindatasource.html

 

The purpose of this app is to show the polygon features from Table A ( it's a map service layer ) that matches records in Table B ( non spatial table).

 

The source for this map service and table are both in a FGDB which is also a dynamic workspace. I am able to join the results and see the features in my map but it is returning all the features in the join from table A. Following is a sample request:

 

.../MapServer/export?dynamicLayers=[{"id":0,"source":{"type":"dataLayer","dataSource":{"type":"joinTable","leftTableSource":{"type":"mapLayer","mapLayerId":0},"rightTableSource":{"type":"dataLayer","dataSource":{"type":"table","workspaceId":"TestWorkSpace","dataSourceName":"_test_bc512580_3dbf_11e4_813c_005056802617"}},"leftTableKey":"ID","rightTableKey":"ID","joinType":"esriLeftInnerJoin"}},"drawingInfo":{"renderer":{"type":"simple","symbol":{"color":[128,0,128,102],"outline":{"color":[128,0,128,255],"width":1.5,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSNull"}}},"minScale":0,"maxScale":0}]&dpi=96&transparent=true&format=png8&layers=show:0&bbox=-10181538.954185508,4115378.1803393513,-9790181.369365595,4279259.16898269&bboxSR=102100&imageSR=102100&size=1280,536&f=image

 

I am using left-inner-join as JoinType which has been translated to esriLeftInnerJoin. I was assuming that it should return only the matching records.

 

Am I doing something wrong or is it a bug ?

Outcomes