Related Records in Dashboard Data Expression

CANC-AndrewJohnsonGISS — Fri, 02 Jul 2021 17:47:17 GMT

Hello,

I am working to build a data expression that pulls an attribute from a related table. I am not seeing any global variables :

And when I filter to create a new featureset object, I cannot access its attributes within a for loop like I can when I use the unfiltered feature sets. Does anyone have some example code of this process?

// Write an expression that returns a FeatureSet. // Documentation: https://arcg.is/3c419TD //var plots = FeatureSetByPortalItem(Portal('https://geoplatform.maps.arcgis.com'), '88cf338d4ace40c099fe17fdab889537', '0') var Char = FeatureSetByPortalItem(Portal('https://geoplatform.maps.arcgis.com'), '88cf338d4ace40c099fe17fdab889537', '5') var SoilPit = FeatureSetByPortalItem(Portal('https://geoplatform.maps.arcgis.com'), '88cf338d4ace40c099fe17fdab889537', '15') Console(Char) var choicesDict = { fields:[ { name: "SoilKey", type: "esriFieldTypeString" }, { name: "Texture", type: "esriFieldTypeString" }, { name: "HorizonKey", type: "esriFieldTypeString" }, { name: "Office", type: "esriFieldTypeString" }, ], 'geometryType': '', 'features':[] }; var i = 0; for (var feature in SoilPit){ var Soil_Key = feature["SoilKey"] Console(Soil_Key) var filter_query = "PrimaryKey" + " ='" + Soil_Key + "'"; Console("filter query",filter_query) var officeFS = Filter(Char,filter_query) Console(officeFS) for (var f in officeFS){ choicesDict.features[i] = { attributes: { SoilKey: feature["SoilKey"], Texture: feature["Texture"], HorizonKey: feature["HorizonKey"], Office: f.Office, }, }; i++; } } return FeatureSet(Text(choicesDict))

Re: Related Records in Dashboard Data Expression

RobertBorchert — Wed, 07 Jul 2021 14:50:56 GMT

Create a VIEW instead

topic Re: Related Records in Dashboard Data Expression in ArcGIS Dashboards Questions

Related Records in Dashboard Data Expression

Re: Related Records in Dashboard Data Expression