Prefilter list based on usergroup of the post author

[schacke]

I'm building a membership site for psychologists where they can post a business card (build with Fabrik). When their membership expires they autmatically change usergroup.

My question is: I would like to prefilter the business card list so only posts from users belonging to a certain usergroup are displayed (so the expired members card don't show up). Is this posible?

 

[troester]

Assuming author is your element holding the userid and you want to show only records of users belonging to group 11

Add a prefilter
WHERE author IN
value:
SELECT user_id FROM #_user_usergroup_map WHERE group_id = 11
Type: Query

 

[schacke]

Works like a charm! THANX