topic Re: Get a value from a layer (with joined table) in a web map in ArcGIS Field Maps Questions

Get a value from a layer (with joined table) in a web map

WilsonLee — Mon, 24 Jul 2023 19:51:26 GMT

Hi, I am creating a form for a layer. In 1 field, I want to get get a value from another layer (with joined table, it's map service published from a ArcGIS Server) in a same web map.

var treeGrid = FeatureSetByName($map,"GROUNDS.SEQ")

var result = Intersects($feature, treeGrid)

return Upper(first(result)."GROUNDS.TI2_MAX_SEQ.SEQ")

Test execution error: Unexpected text literal.. Verify test data.

(It was fine if i am getting a value from another layer without joined table)

Does Field Maps support accessing values from a layer with joined table in Arcade? is my code correct for this?

thanks a lot!!!

Re: Get a value from a layer (with joined table) in a web map

DougBrowning — Tue, 25 Jul 2023 13:46:51 GMT

Your 3rd line there should not have the field name in quotes - that makes it a string. Also when sending a list of fields to FeatureSet you need to send a list in line 1. Also I do not see the layer name in line 1.

Then this part TI2_MAX_SEQ I have no idea what that is. The format should be record.fieldname

Try this

var treeGrid = FeatureSetByName($map, "NameOfLayerInMap", ["GROUNDS.SEQ"])
var result = Intersects($feature, treeGrid)
return Upper(first(result).GROUNDS.SEQ)

Hard to tell since I am not sure what you are trying to go.

Hope that helps

Re: Get a value from a layer (with joined table) in a web map

WilsonLee — Tue, 25 Jul 2023 16:28:19 GMT

thanks Doug!

i got the idea, thanks for your help