Can someone tell me why the or in that query:
print Counter.on_medicos.filter(loc__isnull=True).only("id").query
""SELECT `web_counter`.`id` FROM `web_counter` LEFT OUTER JOIN
`locations_localidad` ON (`web_counter`.`loc` = `locations_localidad`.`id`)
WHERE (`web_counter`.`mode` = 1 AND `locations_localidad`.`id` IS NULL)"""
The orm is making a JOIN?? i can't understant!
The foreignkey loc is nullable and blank, i don't understant why making a
filter the orm is performing the join and making an exclude the ORM is not
performing the JOIN...
print Counter.on_medicos.exclude(loc__isnull=True).only("id").query
SELECT `web_counter`.`id` FROM `web_counter` WHERE (`web_counter`.`mode` =
1 AND NOT (`web_counter`.`loc` IS NULL))
Thank's!
--
Alex Perez
alex.pe...@bebabum.com
*bebabum* be successful
c/ Còrsega 301-303, Àtic 2
08008 Barcelona
http://www.bebabum.com
http://www.facebook.com/bebabum
http://twitter.com/bebabum
This message is intended exclusively for its addressee and may contain
information that is confidential and protected by professional privilege.
If you are not the intended recipient you are hereby notified that any
dissemination, copy or disclosure of this communication is strictly
prohibited by law.
Este mensaje se dirige exclusivamente a su destinatario y puede contener
información privilegiada o confidencial. Si no es vd. el destinatario
indicado,
queda notificado que la utilización, divulgación y/o copia sin autorización
está prohibida en virtud de la legislación vigente.
Le informamos que los datos personales que facilite/ha facilitado pasarán a
formar parte de un fichero responsabilidad de bebabum, S.L. y que tiene
por finalidad gestionar las relaciones con usted.
Tiene derecho al acceso, rectificación cancelación y oposición en nuestra
oficina ubicada en c/ Còrsega 301-303, Àtic 2 de Barcelona o a la dirección
de e-mail l...@bebabum.com
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
