Dashboard Details - Data Expression to Filter for Attachments

Question

Hi! I am trying to create a Dashboard data expression that will let me filter out features without attachments on a feature layer. I'm a noob when it comes to loops and dictionaries. Any suggestions??  I was thinking I'd just add a field to the feature set and store the counts and filter off of that. I've got as far as below, but just doesn't seem to work. I think I'm mixing feature sets with arrays and not pushing correctly.

Otherwise Details shows all the features whether they have attachments or not which is awkward. This would be for an ongoing editing project so doing a one time calculation won't be the trick.

Thanks!!

var responses = FeatureSetByPortalItem(Portal('https://www.arcgis.com'),'e5f9d47a5ee84f0e97a377912cdae9f6',0,['*'],false)

var responses = {
  'fields': [{
    'attributes': {
      'name': 'counts', 
      'alias': 'Attachment Count', 
      'type': 'esriFieldTypeInteger'
    }
  }]
}

for (var nf in responses){
  var counts = Count(Attachments(nf))}
  responses.counts = {
    'attributes':{
      'counts': nf.counts
    }
}
return responses

Teresa_Blader · Answer

Sadly wrapping it in FeatureSet doesn't work because I don't have the loop set up correctly.

DarraghOSullivan · Answer

Hi Teresa, I'm new to FeatureSets as well. Maybe in the meantime we can keep trying between us! I notice from the documentation here:

https://developers.arcgis.com/arcade/guide/featuresets/#:~:text=You%20can%20also%20create%20a,sources%20into%20a%20single%20FeatureSet.

and here:

https://doc.arcgis.com/en/dashboards/latest/reference/authoring-data-expressions.htm

That they usually return a FeatureSet()  ... might return FeatureSet(responses) work in your case?

Teresa_Blader · Answer

I did get a count to return at least when I wrapped the FeatureSetByPortalItem with the First() function - but that would be on a single feature - a good start though. For dashboard data expression, we want a feature set obviously... so a loop has to be involved and it has to push the features with the attachments. So I think it's possible I just have no experience with loops and how to use the loop to filter a feature set. Hoping someone jumps in and helps!

var responses = First(FeatureSetByPortalItem(Portal('https://www.arcgis.com'),'e5f9d47a5ee84f0e97a377912cdae9f6',0,['*'],false)))

var counts = Count(Attachments(responses))

return counts