Django Q Objects / Filtering with OR and NOT Conditions / Pattern Matching and Regex Lookups

Показать описание

In this video, we'll look at how to use Q Objects in Django. These can be used to build complex lookups that can be composed with logical AND, OR and NOT conditions in SQL, and can also be used to extract parts of complex queries into dedicated objects.

We'll also look at how to do pattern matching with the SQL "LIKE" operator, and Django's 'icontains' and 'endswith' lookup; as well as how to do more complex pattern matching with regular expressions, using the 'regex' lookup.

☕️ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲:
To support the channel and encourage new videos, please consider buying me a coffee here:

▶️ Full Playlist:

𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:

📚 𝗙𝘂𝗿𝘁𝗵𝗲𝗿 𝗿𝗲𝗮𝗱𝗶𝗻𝗴 𝗮𝗻𝗱 𝗶𝗻𝗳𝗼𝗿𝗺𝗮𝘁𝗶𝗼𝗻:

#python #django #webdevelopment #database #sql

BugBytes

Рекомендации по теме

Комментарии

This guy is unique and exceptional that people who want to go deep into Django must have to go through topics he has explained in his playlist. Thankyou for helping the community.

noorzaibchohan

A great tutorial as usual. Thank you Master for the effort put in the service of people !

seydinaoumarsamabaly

Again, a great tutorial. Q and F objects are really powerful. When I have a frontend where I can search/filter over several fields I take the request and build a list of Q objects from the request and then unpack them in queryset filter i.e. Restaurants.objects, filter(reduce(operator.and_, q_query_list)).

khunjohn

Hi, thank you so much for many amazing tutorials. I have watched most of them, and they have been very very useful! Would you be able to create a tutorial on displaying a network graph in Django?

wisemify

Great explanation and Great content best for you bro

JoseLuisMorales

Great tutorial. Any tips for how to implement a captcha to check if human in forms?

mizzlehd

i learn django while i learn english, thanks lasdasd

ssgto

Lesson learned, if you want to make a profit, don't add a number in your restaurant name.

syedazeemjaved

Django Q Objects / Filtering with OR and NOT Conditions / Pattern Matching and Regex Lookups

Django Q Objects / Filtering with OR and NOT Conditions / Pattern Matching and Regex Lookups

Django search form [filter with Q object] - Build A Blog With Django (part 11)

Complex Lookups using Q Objects in Django | Ep-26

DjangoCon 2019 - Building effective Django queries with expressions by Vanessa Barreiros

How do I do a not equal in Django queryset filtering?

Build a dynamic filtering form with Django // 5 - Filtering by search

Django : Filtering for multiple ForeignKey matches using Q objects

Django ORM - QuerySet Filtering and Lookups / Ordering and Slicing QuerySets

Django ORM Basics Series: Part 9 (Q filters)

Django : django dynamically filtering with q objects

Django Full Course - 2.2 - Making queries. Querying and filtering related objects

Django : Django filter OR - q objects performance vs I performance

Django 2 Complex Lookup Using Q Object #35

Django : The right way to make Q object, which filter all entries in Django QuerySet?

Django : filter using Q object with dynamic from user?

Django : Django, having Q object filter by function in model

Django Trick: Using Q Objects for Complex Queries

Advanced Django ORM Features (Q-Objects, F-Expressions, Aggregations and Annotations)

Django Conditional Expressions / Case() and When() objects

46 - Complex Search using Django Q Lookups - Python & Django 3.2 Tutorial Series

Django ORM - How to perform a NOT query on a database - including Q Objects

Introduction to Django: Complex filtering

16 Django Query, filter() Single table ‘WHERE’ clause ‘AND’, What is ‘Q’ in Django?

Django Full Course - 2.3 - Making queries. Complex lookups with Q (combining or, and operators)