Как сделать фильтрацию одни запросом по 5 полям модели?

Question

[paevlk2007]

Все привет!

Как сделать фильтр одним запросом по 5 полям модели "accessories_material"

class Accessories(models.Model):
created_on = models.DateTimeField(u"Дата создания", auto_now_add=True, blank=True, null=True)
posted_by = models.ForeignKey(User, blank=True, null=True)
edited_by = models.CharField(max_length=255, blank=True)
accessories_plot = models.ForeignKey(Accessories_plot, verbose_name='Участок')
accessories_material = models.ForeignKey(Accessories_material)
accessories_material2 = models.ForeignKey(Accessories_material)
accessories_material3 = models.ForeignKey(Accessories_material)
accessories_material4 = models.ForeignKey(Accessories_material)
accessories_material5 = models.ForeignKey(Accessories_material)

Answer 1

[Andrey K]

https://docs.djangoproject.com/en/dev/topics/db/qu...

Answer 2

[Алексей Букин]

См в сторону select_related()

Пример: qs = Accessories.objects.all().select_related('accessories_material', 'accessories_material2', 'accessories_material3', 'accessories_material4', 'accessories_material5')