How to return unique values from the field/column of table fgdB?

[BSBlagojevic]

How to return unique values from the field/column of table fgdB which participates in the relationship 1:M? I need unique values for the related report. Distinct keyword in Arcade does not do this on field/column (only on array, tested), and in SQL for file geodatabase this keyword is not supported!

Thanks for any help!

[KenBuja]

This goes back to my previous post

How you get the features variable depends on where you're using the Arcade code. It could be using the variable $datastore or $layer. Or you might need to get it from a function like FeatureSetByName or FeatureSetByPortalItem

What happens when you use "$datastore"?

[BSBlagojevic]

Thanx! NOT PASS!

Regards!

[KenBuja]

That code should be

var features = FeatureSetByName($map, 'Kartirane geoloske jedinice', ['PreferisanaStarost'], true);
Distinct(features, 'PreferisanaStarost');

[BSBlagojevic]

Thank you! Again problem!