Subqueries

2011-04-06 Thread bernatbonet
Data Model: class A(models.model): desc: model.CharField() class B(models.model): a: model.ForeignKey('A') desc: models.CharField() I need to do this select in a view: select max(num_a) as max_num_a from (select a, count(desc) as num_a from B group by a) as x; I've tried this: result

Uso de subconsultas

2011-04-06 Thread bernatbonet
Tengo el siguiente modelo de datos: class A(models.model): desc: model.CharField() class B(models.model): a: model.ForeignKey('A') desc: models.CharField() Tengo una vista que quiere sacar la siguiente select: select max(num_a) as max_num_a from (select a, count(desc) as num_a from B

Re: Inline Foreign Key Filter

2011-03-23 Thread bernatbonet
Talla.objects.filter(tallaje=self.padre.tallaje) but it doesn't work. Thanks. On 23 mar, 14:51, bernatbonet wrote: > Hi, I've been trying to solve one probleme, and I'll explain what I > want to do. > > First I'll show my models; > > class Tallaje(models.Model)

Inline Foreign Key Filter

2011-03-23 Thread bernatbonet
Hi, I've been trying to solve one probleme, and I'll explain what I want to do. First I'll show my models; class Tallaje(models.Model): cod = models.CharField(max_length=5) desc = models.CharField(max_length=60) class Talla(models.Model): tallaje = models.ForeignKey('Tall