Is left-inner-join not working with JoinDataSource ?

132
0
01-22-2019 06:14 AM
SylvainKerdreux2
New Contributor II

Hello,

Using JS Api with JoinDataSource I did not succeed to do a left-inner-join.

On my left table I had 153 features

On my right table I had 51 features

however when I did a join data source I had 153 features with (102 null join value).

{
"source":{
"type":"dataLayer",
"dataSource":{
"type":"joinTable",
"leftTableSource":{
"type":"mapLayer",
"mapLayerId":3
},
"rightTableSource":{
"type":"dataLayer",
"dataSource":{
"type":"queryTable",
"workspaceId":"SenegalDataSource",
"query":"select * from cofiroute.arcgis.Alea where alea =2 and idalea in (1028,...,1180)",
"oidFields":"idalea"
}
},
"leftTableKey":"idalea",
"rightTableKey":"idalea",
"joinType":"esriLeftInnerJoin"
}
}
}

My table rightTableSource is correct (I create a dynamic layer to verify it and I had 51 features).

If i changed to left-outer-join I had the same results.

I found this previous question over Geonet but the solution is a little bit tricky because I must use this joindatasource with another joindatasource.

https://community.esri.com/thread/113663 

Any idea ? 

best regards,

sylvain.

0 Kudos
0 Replies