User/UserProfile Queryset problem

Hello Django Nerds!

So I have a (somewhat) complicated lookup I'm trying to do; here's the
gist of it:

1. I have a Store class, with a User ManyToManyField, Store.users
2. I have a user profile class associated with each user,
UserProfile, accessible through the usual User.get_profile()
3. UserProfile has a status variable, UserProfile.status, which can
be 'Active', 'Inactive', or 'Deleted'

I'm trying to display a list of users for a particular store;
currently I generate this list using the following line:

userList = request.session['currentStore'].users.all()

Works great; however, now I'd like to filter out all users with a
status of 'Deleted'. Now, if status were a User attribute, I could
just try this:

userList =
request.session['currentStore'].users.exclude(status=='Deleted')

or something similar.

THE PROBLEM: How do I generate this no-deleted-users list for the
given store, using the ManyToManyField Store.users, but based on the
store.users UserProfile.status? I know there's some kinky django
black magic reverse-lookup way to do it in a single magnificent
line...just haven't a clue what it might be. Ideas?

First person with the right answer: thank you - please treat yourself
to a donut...

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.