Using variable in django queryset in a filter or empty the filter

Question

Question 1. how could I use a variable in this queryset,

def function(request):
    qset1 = BigTable.objects.values(
        'deb_nr_f__dcountry__wcode_f__code',
        'deb_nr_f__dcountry__wcode_f__code_name',
        ).filter(id_nr_f__ie_code__unomer_f__nomer=iteration_result,
        )

I mean something like that

def function(request):

    x1 = 'id_nr_f__ie_code__unomer_f__nomer'

    qset1 = BigTable.objects.values(
        'deb_nr_f__dcountry__wcode_f__code',
        'deb_nr_f__dcountry__wcode_f__code_name',
        ).filter(x1 = iteration_result,
        )

Question 2. How can I empty the filter with a varianbe, so the the filter in the query does not filter the records. I mean something like that

def function(request):

    x1 = 'id_nr_f__ie_code__unomer_f__nomer'
    x2 = True

    qset1 = BigTable.objects.values(
        'deb_nr_f__dcountry__wcode_f__code',
        'deb_nr_f__dcountry__wcode_f__code_name',
        ).filter(x1 = x2,
        )

Thank you.

Sajad · Accepted Answer · 2020-03-30 18:19:51Z

2

you can define a dict, then pass it to filter as kwargs

attr1 = 'some attr'
attr2 = 'some attr'
filter_dict = {
    attr1:filter1,
    attr2:filter2,
     ...
}
queryset.filter(**filter_dict)

edited Mar 30, 2020 at 18:19

answered Mar 30, 2020 at 18:13

Sajad

5212 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

willeM_ Van Onsem · Accepted Answer · 2020-03-30 18:18:44Z

1

You can make use of a Q object where you pass a 2-tuple you aim to filter:

from django.db.models import Q

def function(request):

    x1 = 'id_nr_f__ie_code__unomer_f__nomer'

    qset1 = BigTable.objects.values(
        'deb_nr_f__dcountry__wcode_f__code',
        'deb_nr_f__dcountry__wcode_f__code_name',
    ).filter(
        Q((x1, iteration_result))
    )

or with a value:

from django.db.models import Q

def function(request):

    x1 = 'id_nr_f__ie_code__unomer_f__nomer'
    x2 = True

    qset1 = BigTable.objects.values(
        'deb_nr_f__dcountry__wcode_f__code',
        'deb_nr_f__dcountry__wcode_f__code_name',
    ).filter(
        Q((x1, x2))
    )

edited Mar 30, 2020 at 18:18

answered Mar 30, 2020 at 18:12

willeM_ Van Onsem

482k33 gold badges483 silver badges624 bronze badges

Collectives™ on Stack Overflow

Using variable in django queryset in a filter or empty the filter

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related