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 = @BW_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.

[Bud]

@JohannesLindner   Good call. I didn’t think it was possible.

This idea can be closed.