Boolean query in Django

Question

I have a "Job" object when I do

   jobs=Job.objects.exclude(end_time__lte =datetime.now(), isActive=True)

or

   jobs.filter( isActive=True)

isAvtive query doesn't wotk at all. What can be the problem? I use MySQL, in job table True register as 1 , Fakse Register as 0 , nad the Job model :

class Job(models.Model):
title=models.CharField(max_length=40)
genre=models.ManyToManyField(JobGenre)  
location=models.TextField()
start_time=models.DateTimeField()             
end_time=models.DateTimeField()
description=models.TextField()
reward=models.TextField(null=True)
isActive=models.BooleanField(default=True)


def __unicode__(self):
    return self.title

class meta:
    ordering=['-end_time','creator']

Why do you think it's not working? It should work, look for the problem somewhere else. Also look at this question: stackoverflow.com/questions/2221247/… — alex vasi
– alex vasi, Commented Apr 17, 2013 at 14:36

Aya · Accepted Answer · 2013-04-17 15:02:40Z

2

It's not clear what you're trying to achieve. If you want all records where isActive is TRUE, then...

jobs = Job.objects.filter(isActive=True)

...should work. If you want to exclude all records where isActive is TRUE, then you want...

jobs = Job.objects.filter(isActive=False)

One of these two should return some results, unless your DB table has no data in it.

edited Apr 17, 2013 at 15:02

answered Apr 17, 2013 at 14:37

Aya

42.5k6 gold badges60 silver badges56 bronze badges

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

5 Comments

hln Over a year ago

This time nothing is return :(

Aya Over a year ago

@hln Then perhaps there are no records in the database where isActive is TRUE. It might help to include the code for your Django Job model, and a small sample of the data for that database table in your question.

hln Over a year ago

there are false and true job objects,

Aya Over a year ago

@hln Are you certain the Django is connecting to the correct database? If you're making a unit test, Django will create a temporary database with no content, so you'll have to provide a fixture.

hln Over a year ago

Sorry it works, i dont know why suddently all data in datbase was dispeared. :( and it cant use jobs=Job.objects.exclude(end_time__lte =datetime.now(), isActive=True)

Collectives™ on Stack Overflow

Boolean query in Django

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related