how to retrive values form RawQuerySet in django?
django, django-queryset, python
Solution
The result obtained by making raw queries using `raw` method of `Manager` generates instances similar to instances generated using `get` or `filter` method. To get a field simply do `obj_name.attr`. For eg:
class Tab(models.Model):
field1 = models.BooleanField()
field2 = models.PositiveIntegerField()
query = "select * from app_name_tab"
objs = Tab.objects.raw(query)
for obj in objs:
print obj.field1, obj.field2
For more info, refer to https://docs.djangoproject.com/en/dev/topics/db/sql/
Problem
my input query is ``` query = "select * from tab1 left join tab2 on tab2.patient_id =tab1.patient_id ,tab3 left join tab4 on tab4.patient_id =tab3.patient_id" data = model_name.objects.raw(query) ``` How do you retrieve values from a `RawQuerySet`?