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.