Hi,

I am creating small django application which holds some few questions (and answers for them)

What I want to do is to show user random question, but only from those which was not solved by him yet. I wonder how to do this.

For now, I defined user profile model this way:

class UserProfile(models.Model):
    rank = models.IntegerField(default = 1)
    solvedQ = models.ManyToManyField(Question)
    user = models.ForeignKey(User, unique=True)

So solved problems are added this way:

if user.is_authenticated():
    profile = user.get_profile()
    profile.rank += 1
    profile.solvedQ.add(Question.objects.get(id=id))

Now if the view must show random question, but not from already solved list...

Is there a good way to intersect Questions and solvedQuestions.... so question is chosen from the unsolved list?