Calling filter with a variable for field name

Question

Is there a way to call filter on a queryset where one of the fieldnames is a variable?

For example I have something like:

models.py

class Playlist(models.Model):
    video = ...

views.py

field_name = 'video'
Playlist.objects.filter(field_name=v)

Which of course results in an error that field_name is not an attribute upon which Playlist can be filtered.

Common, I need Internet points! – nisc Feb 03 '12 at 13:08 — nisc, Feb 03 '12 at 13:08

score 84 · Answer 1 · answered Feb 03 '12 at 00:39

84

Playlist.objects.filter(**{field_name: v})

answered Feb 03 '12 at 00:39

nisc

1

how do i use __icontains with the field_name? it gives an error – Naveen Feb 05 '19 at 12:14
2

Try with: field_name = 'video__icontains' , it worked for me – gmarsi Apr 13 '20 at 11:21

score 10 · Answer 2 · edited May 31 '20 at 16:59

10

To use field name string with icontains.

Try this

field_name = 'video'
field_name_icontains = field_name + '__icontains'
Playlist.objects.filter(**{field_name_icontains: v})

edited May 31 '20 at 16:59

Sina Khelil

answered Sep 07 '19 at 18:33

shafik

Is there a way to pass the model name as a **variable** in a queryset? eg. in a queryset like `var_duty_cond = DutyHdr.objects.get(duty_hdr_component = varMainDutyType).duty_main`, how may I pass a variable `varDutyHdr` in place of **model** `DutyHdr`? – Love Putin Not War Jun 11 '20 at 19:54

2 Answers2