topic Re: Filter Attachments in Data Management Questions

Filter Attachments

Andrew-Bowne — Thu, 23 Feb 2017 15:44:52 GMT

I have a point feature class with several photo attachments. There are situations where I may want to filter which photos a user can/should be able to view. For instance, A user may only want to view "Finish Phase" photos and not "Construction Phase" photos. I have thought about adding a field to the attachment table and populating with the phase type. However, I don't know if there's a way to apply this filter, or definition query, to the end user. All my data and photos are stored in SQLServer.

Any ideas how I might be able to accomplish this?

-Andrew

Re: Filter Attachments

TedKowal — Thu, 23 Feb 2017 16:38:45 GMT

I see no reason why it would not be doable? You are able to get users name / roles and if you have a foreign key within the photo table a filterable relationship could be established or handled by code.

This looked promising ... How To: Get the current user name and roles using a server object extension

Re: Filter Attachments

Trippetoe — Wed, 18 Apr 2018 18:32:33 GMT

Did you ever figure out how to do this? I have the same (or roughly the same) use-case. I have a feature with many photos and in the feature's popup i want to display only the pictures with the name 'before' and 'after' while not showing any others.

Re: Filter Attachments

Andrew-Bowne — Fri, 03 Aug 2018 17:14:05 GMT

Nope, never figured it out. It would be nice if this was functionality that was added in at some point!