Re: Search in a ManyToManyField in Admin interface

2009-01-29 Thread João Olavo Baião de Vasconcelos
On Wed, Jan 28, 2009 at 7:36 PM, Ian wrote: > Yes, that's the problem. The admin automatically adds .distinct() to the > queryset whenever one of the search fields is in a related model, which > would trigger the error. Ok, got it. > This is a limitation of Oracle, and there's not a whole

Re: Search in a ManyToManyField in Admin interface

2009-01-28 Thread Ian
On Jan 28, 1:25 pm, João Olavo Baião de Vasconcelos wrote: > I think that I realised what is the problem. > > Karen, just add a TextField to the Book model (say, "description = > models.TextField()"), try to search for something and you'll see that error > message. I'm not 100% sure about it, coz

Re: Search in a ManyToManyField in Admin interface

2009-01-28 Thread João Olavo Baião de Vasconcelos
I think that I realised what is the problem. Karen, just add a TextField to the Book model (say, "description = models.TextField()"), try to search for something and you'll see that error message. I'm not 100% sure about it, coz I tested this at work and then came home. Probably is the same bug r

Re: Search in a ManyToManyField in Admin interface

2009-01-28 Thread Ian
On Jan 28, 9:46 am, João Olavo Baião de Vasconcelos wrote: > On Wed, Jan 28, 2009 at 1:31 PM, Karen Tracey wrote: > > You are including the __name in your manual search but you left it out of > > the search_fields you listed in your ModelAdmin.  So what happens if you > > make search_fields = ['

Re: Search in a ManyToManyField in Admin interface

2009-01-28 Thread Karen Tracey
On Wed, Jan 28, 2009 at 11:46 AM, João Olavo Baião de Vasconcelos < joaool...@gmail.com> wrote: > On Wed, Jan 28, 2009 at 1:31 PM, Karen Tracey wrote: > >> You are including the __name in your manual search but you left it out of >> the search_fields you listed in your ModelAdmin. So what happen

Re: Search in a ManyToManyField in Admin interface

2009-01-28 Thread João Olavo Baião de Vasconcelos
On Wed, Jan 28, 2009 at 1:31 PM, Karen Tracey wrote: > You are including the __name in your manual search but you left it out of > the search_fields you listed in your ModelAdmin. So what happens if you > make search_fields = ['title', 'authors__name']? > I did it, and got this error message: *

Re: Search in a ManyToManyField in Admin interface

2009-01-28 Thread Karen Tracey
On Wed, Jan 28, 2009 at 6:19 AM, João Olavo Baião de Vasconcelos < joaool...@gmail.com> wrote: > Hi all, > > I'd like to search in a m2mfield using the search_fields trick in admin > interface (django 1.0.2). > > A simple example of models: > """ > class Book(models.Model): > title = models.Char

Search in a ManyToManyField in Admin interface

2009-01-28 Thread João Olavo Baião de Vasconcelos
Hi all, I'd like to search in a m2mfield using the search_fields trick in admin interface (django 1.0.2). A simple example of models: """ class Book(models.Model): title = models.CharField(...) authors = models.ManyToManyField('author') class Author(models.Model): name = models.CharField(.