limit_choices_to with A or B logic

Question

I've got a model named MyUser with a user_type field which can be of the following different user types

USER_TYPE_STUDENT

USER_TYPE_TEACHER

USER_TYPE_DIRECTOR

In one of the models, I've got the following field

student = models.ForeignKey(MyUser, null=True, related_name='requests',
                            limit_choices_to={'user_type': MyUser.USER_TYPE_STUDENT}, ...)

As you can read, it uses

limit_choices_to={'user_type': MyUser.USER_TYPE_STUDENT}

Thing is, in a OneToOneField field (students_or_teachers), I would like to declare that field is limited to user_type USER_TYPE_STUDENT or USER_TYPE_TEACHER.

How can that be done?

Maybe this can help? https://stackoverflow.com/questions/30181079/django-limit-choices-to-for-multiple-fields-with-or-condition — Alexander Lekontsev, Apr 20 '20 at 05:38
I've seen that before. In that specific case the OR is used between different fields, instead of different possible choices of the same field. — Tiago Martins Peres, Apr 20 '20 at 05:44

score 1 · Accepted Answer · answered Apr 20 '20 at 07:14

1

Use a __in lookup:

limit_choices_to = {
    "user_type__in": (MyUser.USER_TYPE_STUDENT, MyUser.USER_TYPE_TEACHER)
    }

answered Apr 20 '20 at 07:14

bruno desthuilliers

75,974
6
88
118

limit_choices_to with A or B logic

1 Answers1