I am trying to create a manager for a model so that only objects with a
status of 0 or 1 show up in the admin.

Could someone please let me know how to write a "where" clause in the
manager
(e.g  "current_status < 2" or something like "current_status=0 or
current_status=1")

Here's what I tried...

#-------------------------------------------------
class Repair(models.Model):
    # some code...

    class Admin:
        manager = EditableRepairsManager()
#-------------------------------------------------

I tried this...

#-------------------------------------------------
class EditableRepairsManager(models.Manager):
    def get_query_set(self):
        from django.db import connection
        cursor = connection.cursor()
        cursor.execute("""
            SELECT r.id
            FROM pra_repair r
            WHERE current_status < 2
            ORDER BY r.tail_number
        """)
        result_list = []
        for row in cursor.fetchall():
            id = row[0]
            repair = Repair.objects.get(pk=id)
            result_list.append(repair)
        return result_list
#-------------------------------------------------

I got this error in the template:

AttributeError at /admin/pra/repair/
'list' object has no attribute 'filter'
Request Method:         GET
Request URL:    http://127.0.0.1:8000/admin/pra/repair/
Exception Type:         AttributeError
Exception Value:        'list' object has no attribute 'filter'

I tried this:

#-------------------------------------------------
class EditableRepairsManager(models.Manager):
    def get_query_set(self):
        return super(EditableRepairsManager,
self).get_query_set().filter(current_status=0,current_status=1)
#-------------------------------------------------

I got this error from the dev server terminal window:
SyntaxError: duplicate keyword argument

I understand why I got the errors but I don't understand how to create
the manager I need.


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-users
-~----------~----~----~----~------~----~------~--~---

Reply via email to