Nebojša Đorđević schreef:
> On Feb 9, 2007, at 09:32 , Benedict Verheyen wrote:
>
<snip>
>
> Have you tried `limit_choices_to` (http://www.djangoproject.com/
> documentation/model_api/#many-to-one-relationships) to filter out all
> of the used beds from the select list.
>
> Do you use Django admin interface or the custom form?
>
I couldn't figure out how to use Q objects to get what i want.
This is the sql that makes a list of all the free beds:
select * from main_room where id not in (select room_id from
main_patient where room_id IS NOT NULL )
I tried adding it to a manager that
i already have but i can't figure out how i should add it to my model.
class PatientManager(models.Manager):
...
def empty_rooms(self):
....
return result_list
class Patient(models.Model):
....
kamer = models.ForeignKey(Room, blank=True, null=True,
limit_choices_to = objects.empty_rooms() )
objects = PatientManager()
....
This doesn't work. How can i make it work via the PatientManager or
directly in a view?
Thanks,
Benedict
--~--~---------~--~----~------------~-------~--~----~
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?hl=en
-~----------~----~----~----~------~----~------~--~---
