filter on foreign keys with None doesn't return anything

[Patrick Lauber <patrick.lauber@…>]

At the moment you have to do it like this:

class Category(models.Model):
    name = models.CharField(core=True, maxlength=64)
    parent = models.ForeignKey('self', blank=True, null=True, related_name='child')

def getNavigation(request,parent):
    if parent==None:
        return Category.objects.filter(parent__id__isnull=True).order_by('-priority')
    else:
        return Category.objects.filter(parent__id=parent).order_by('-priority')

I think for a newbie to Databases like me this not very intuitive. Wouldn't it be possible to make the isnull check automatically behind the scenes if the argument is None or an empty String?

[mir@…]

Hi Patrick, you're a bit late: We had this discussion already months ago. People who know SQL find it actually more intuitive as it is, and that's a pretty basic knowledge for writing database applications.

You can use the django developers mailing list in case you want to continue discussing this.

BTW, you probably meant {{filter(parent_id...)}} with only a single underscore ;-)