fetching multiple rows from database in django?

Question

I have to fetch multiple rows from database based on some condition. There may be one row in database for matching query or multiple rows. I can use get() for one row but it does not fetch multiple rows.

Here is my code:

value=table.objects.get(col_name=1) then i can access its data as value.col but as i said it gives me error if this query returns more then one row.

I have also tried filter() , value=table.objects.filter(col_name=1) but then i can't access its data as value.col.

So please suggest me some way how i can fetch multiple rows from database and access columns one by one of those rows.

Thanks !!

i think i have to use for loop for accessing data if i am using filter , Is i am right ?? — user1746291
– user1746291, Commented Jan 29, 2013 at 9:19

Rudy Mutter · Accepted Answer · 2013-01-29 09:37:35Z

3

values = table.objects.filter(col_name=1)
for value in values.all():
    # Do something with value.col

answered Jan 29, 2013 at 9:37

Rudy Mutter

9661 gold badge6 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

user1746291 Over a year ago

Can you tell me one thing.....I have updated some fields from update function and it successfully updated the database and i can see the updated fields in back end but from admin dashboard it shows me the previous value not updated value , any idea why??

Rudy Mutter Over a year ago

It is possible your django admin is caching - checkout docs.djangoproject.com/en/dev/topics/cache and try turning off your cache in your settings.py to see if it updates correctly.

user1746291 Over a year ago

it doesn't work ..... I have update the database through handlers...is this the reason or not ??

Rudy Mutter Over a year ago

It's hard for me to diagnose the issue without more information. It may be best to ask a new question on StackOverflow for this new issue with a bit more detail.

Lukasz Koziara · Accepted Answer · 2013-01-29 09:36:48Z

1

yes, you must iterate over items from queryset:

for item in value:
    item.col

answered Jan 29, 2013 at 9:36

Lukasz Koziara

4,3225 gold badges34 silver badges45 bronze badges

Comments

Leman Kirme · Accepted Answer · 2020-08-07 15:09:06Z

0

value=table.objects.filter(col_name=1)

will return a "django.db.models.query.QuerySet" type which can iterated using 'for' loop

answered Aug 7, 2020 at 15:09

Leman Kirme

5501 gold badge6 silver badges19 bronze badges

Collectives™ on Stack Overflow

fetching multiple rows from database in django?

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related