Django QuerySet filter over string

Question

I have a models.py file with some rows and I would like to return on my HTML template all rows corresponding to my filter QuerySet.

#models.py

def Test(request) :

    CarCollection = MyModel.objects.filter(car="old")

    context = {
        "CarCollection" : CarCollection
    }

    return render(request, 'car.html', context)

My html template looks like :

<!-- car.html -->

{% block content %} 
<ul>
{% for car in CarCollection %}
  <li>{{ car }}</li>
{% endfor %}
</ul>

{% endblock %}

But my objects looks like :

Volvo_old_car
Audi_old_car
Nissan_new_car
old_Bentley

So I would like to isolate a string in my object (old for example) and return all objects with this string. But this string could be at the beginning, at the middle or at the end.

The filter will return :

Volvo_old_car
Audi_old_car
old_bentley

I need to use Regex to do that ?

Thank you by advance

Marine · Accepted Answer · 2021-07-08 15:48:05Z

6

Instead of

MyModel.objects.filter(car="old")

do

MyModel.objects.filter(car__icontains="old")

This will tell Django to filter out all MyModel objects where car fields contains old.

NB: You can also use car__contains="old" directly if you want a case sensitive search.

P.S. You should definitely check the PEP8 Python convention. This will help you to write code that is easy to read for Python developers.

edited Jul 8, 2021 at 15:48

Marine

52 bronze badges

answered Nov 25, 2016 at 9:59

Adilet Maratov

1,3922 gold badges14 silver badges24 bronze badges

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

1 Comment

user6051274 Over a year ago

Thank you very much, I didn't know this option !

Himavanth · Accepted Answer · 2016-11-25 10:04:23Z

1

You can use field lookups provided by Django to filter your queryset.

Django - Field lookups

MyModel.objects.filter(car__contains="old")

answered Nov 25, 2016 at 10:04

Himavanth

4101 gold badge6 silver badges15 bronze badges

Comments

Marin · Accepted Answer · 2016-11-25 09:59:07Z

0

You can use: endswith or istartswith in query.

CarCollection = MyModel.objects.filter(car__istartswith="old")

answered Nov 25, 2016 at 9:59

Marin

1,12114 silver badges34 bronze badges

Collectives™ on Stack Overflow

Django QuerySet filter over string

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related