Say for example, I have a list of users, and all of their profiles have a birthdate, which is a private field.
Is there a way I can search based on their birthdate without exposing the birthdate to the user?
For example, I might want to get a list of users with birthdays in January, or a list of users older than 45, or a list of users born in the first half of the month, etc.
If User's birthdate is protected by privacy rules, the only way to get a list of Users filtered by that field is in the backend, with an API workflow, checking the Ignore privacy rules option.
An alternative is using a role and permissions architecture where you give users a special permission to access the field. But since you mentioned that it shouldn’t be accesible by any User, this won’t be an option for you.