I wonder how other people have solved the issue I’m facing with Users being Managers and Clients.
I have a number of Things that Client Users create so when dealing with that data I can use the Creator field. However, in a number of cases I have a Manager User making changes to things ‘owned’ by a Client User.
So when I create an admin panel and want to show all things created by users I’d like to show all users and filter out the ‘Manager = yes’ fields as those are by far the least. However, this will not be possible because Managers have been the User for certain Things and not the Clients themselves.
Would the solution be to create a Client (User) Thing on each Type that I have this issue with and always Create a Thing with Client=Current user or Client=client dropdown’s value (to select the client if a Manager is Current User)
Or would I just be able to use the User type for both Clients and Managers and only for the Things created/updated by Managers on behalf of a Client add that data with a filter? (meaning I would only populate the Client Thing when a Manager has been doing the updating/creating)
From a data management perspective, what would your preferred solution be?