idea Arcade: Use related DB views as FeatureSets in ArcGIS Pro Ideas

Arcade: Use related DB views as FeatureSets

Bud — Fri, 18 Mar 2022 03:36:43 GMT

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

Re: Arcade: Use related DB views as FeatureSets

JohannesLindner — Fri, 18 Mar 2022 10:26:28 GMT

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.

Re: Arcade: Use related DB views as FeatureSets

Bud — Fri, 18 Mar 2022 11:04:16 GMT

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

This idea can be closed.

Re: Arcade: Use related DB views as FeatureSets - Status changed to: Already Offered

KoryKramer — Fri, 18 Mar 2022 12:26:00 GMT