We need to find all user profiles who have access to a folder to send notification to them when any asset is uploaded in that folder.
What's the best and most efficient way of achieveing this?
Currently we get all users and then loop through them to filter users with access. Is there an alternate way because i think this way it's expensive.(if there are 10000 users, it will loop 10000 times and maybe only 2 users have access to that folder)
Thanks