Search on Private Data Field

Is there a way to search on private data fields?

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.