Arcade: Use related DB views as FeatureSets

Bud

 

It would be great if we could use related DB views as FeatureSets in Arcade scrips (just like we do with related FCs).

 

JohannesLindner

You can do that.

Simple view:

SELECT Shape, BauwerkID, CONCAT('I am building ', BauwerkID) AS "TextID"
FROM database.dataowner.Bauwerke

 

Popup Arcade expression:

var view_fs = FeatureSetByName($datastore, "database.dataowner.TestView")
var bw_id = $feature.BauwerkID
var v = First(Filter(view_fs, "BauwerkID = <a href="https://community.esri.com/t5/user/viewprofilepage/user-id/78455">@BW</a>_id"))
if(v == null) { return "nothing here" }
return v.TextID

 

Popup:

 

 

You just can't use FeatureSetByRelationshipName(), because that relies on Relationship Classes, which you can't create for a view.