Re: Q search with foreign key

2009-03-04 Thread Jesse
Thanks! That worked. --~--~-~--~~~---~--~~ 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 django-user

Re: Q search with foreign key

2009-03-03 Thread felix
use two underscores to address the other table/model institution_institution vs institution__institution django querysets rock ! On Tue, Mar 3, 2009 at 10:19 PM, Jesse wrote: > > I tried that option and received this error: > > Cannot resolve keyword 'institution_institution' into field

Re: Q search with foreign key

2009-03-03 Thread Jesse
I tried that option and received this error: Cannot resolve keyword 'institution_institution' into field However, I think I may have it. I used this statement: qset2 = ( Q(institution__icontains=queryr) ) resultsi = Institution.objects.filter(qset2).distinct()

Re: Q search with foreign key

2009-03-03 Thread Tim
If you want to look up an Institution using the Project model, you should be able to use "institution__institution__icontains" --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this grou

Q search with foreign key

2009-03-03 Thread Jesse
I have a Project model with a foreign key to institution. I want to do a Q(institution_icontains)=queryr on the institution field in the institution table, but the filter needs to go through the Projects model. I need all institutions associated with a Project. class Project(models.Model):