How to create Django custom query?

Question

I have a model named UserInfo with the following fields: id, name, number

I want to create a custom search page. This will have the following elements: Search Box, Search Button Text field to match NAME Text field to match NUMBER

How it should work: Let's say I input 'John' as the name and '1234' as the number in the respective text boxes and click search. The result should show me the entries which has 'John' as the name and '1234' as the number.

The query is something like the following I guess: UserInfo.objects.filter(name='John').filter(number='1234')

I have made this kind of queries in PHP before, but that doesn't work in Django. I want to know what code can I use to associate multiple FILTERS in a query so that if there is data input in both name and number text boxes I get a query like the above but if I search for name only then the query becomes: UserInfo.object.filter(name='John') instead of

UserInfo.object.filter(name='John').filter(number='')

There should be an easy solution for this, I dunno. Very confused. :-/

laffuste · Accepted Answer · 2014-07-16 09:50:46Z

1

Filter methods are chainable, immutable :)

def search_user(name=None, number=None):

    # Uncomment the following lines to return NO records when no input.
    # if not name and not number:
    #    return  UserInfo.objects.none()

    qs = UserInfo.objects.all()
    if name:
        qs = qs.filter(name=name)
    if number:
        qs = qs.filter(number=number)
    return qs

This example would return all records if no input.

(Note that QS are lazy, and all() would not retrieve all records unless accessed later on.)

edited Jul 16, 2014 at 9:50

answered Jul 16, 2014 at 8:54

laffuste

17.2k8 gold badges90 silver badges94 bronze badges

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

2 Comments

MiniGunnR Over a year ago

This looks like what I'm looking for. Thanks a lot. I'll give this a try. However, I don't understand what you mean by the sentence in brackets. :-/

ruddra Over a year ago

You will understand what ladduste meant by reading this: docs.djangoproject.com/en/dev/topics/db/queries/… :)

Rafael · Accepted Answer · 2014-07-16 11:18:34Z

1

Q is a powerful feature in Django. see Q class

from django.db.models import Q

# you cand do a lot of crazy things here 
query = Q(name__iexact=name) & Q(number=number)

users =  UserInfo.object.filter(query)

answered Jul 16, 2014 at 11:18

Rafael

2,2082 gold badges17 silver badges10 bronze badges

Comments

Pawan · Accepted Answer · 2014-07-16 08:51:15Z

0

The solution according to your example is...

MatchedUsers = UserInfo.object.filter(name='John',number='1234')
return MatchedUsers

answered Jul 16, 2014 at 8:51

Pawan

4,4397 gold badges32 silver badges32 bronze badges

Comments

cor · Accepted Answer · 2014-07-16 08:56:52Z

0

I would do something like that

if name and number:
    UserInfo.object.filter(name='John',number='1234')

edited Jul 16, 2014 at 8:56

answered Jul 16, 2014 at 8:46

cor

3,39329 silver badges48 bronze badges

Collectives™ on Stack Overflow

How to create Django custom query?

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related