Template based on related data?

[sandermarechal]

Is it possible to filter/template based on related data? Here is my use-case. Suppose I have an M:N user-group relation like so:

users:
* id (int)
* username (varchar)
* password_hash (varchar)

groups:
* id (int)
* name (varchar)
* anonymize (bool)

user_group:
* user_id (int)
* group_id (int)

Now, I want to anonymize all users, except if they belong to a group that has anonymize: false. Is that possible?

[borisershov]

Hi! To make sure I understand your issue, could you provide an example with data and result you expect after anonymization?

[sandermarechal]

Sure. Before anonymization:

users

id	username	password_hash
1	joe	xxxx
2	jack	xxxx
3	amy	xxxx
4	alexa	xxxx

groups

id	name	anonymize
1	users	1
2	admins	0

user_group

user_id	group_id
1	1
2	1
2	2
3	1
4	2

So, jack is both a user and admin, and alexa is just an admin. Want to anonymize like so:

users

id	username	password_hash
1	user_1	anonymized
2	jack	xxxx
3	user_3	anonymized
4	alexa	xxxx

(the other tables remain the same)

The use case is that we provide anonymized QA environments to our clients, but the people in the admin group still need to be able to login in order to test the QA environment.