How to filter django python object with list

Question

I have the following django models

class Article(models.Model): 
article_tags = models.CharField(max_length=200, blank=True, null=True)

class UserProfile(models.Model): 
user_interests = models.CharField(max_length=200, blank=True, null=True)

I have a feed feature for my users and want to filter articles based on user_interests.

For example I have a user with user_interests = ['horror', 'comedy', 'fiction'].

And I have articles with article_tags which are also lists = ['funny', 'comedy', 'new york']

I want to filter my users' feeds by comparing their user_interests with the article_tags of all the articles.

I had tried this:

user_interested_articles =  Article.objects.filter(case_tags__in =
user_interests)

But it doesn't work, I believe this is because I'm trying to compare a list with a list. Is there another way to do this?

Daniel Roseman · Accepted Answer · 2017-05-08 21:11:21Z

2

You shouldn't be storing lists in a char field - or indeed at all. These are tags, and should be stored in a separate model. You can use an app like django-taggit for this.

edited May 8, 2017 at 21:11

answered May 8, 2017 at 21:04

Daniel Roseman

602k68 gold badges911 silver badges924 bronze badges

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

Comments

pleasedontbelong · Accepted Answer · 2017-05-08 21:04:20Z

1

you could normalize your models, and create a new model Tag. (ManyToMany to UserProfile and Article

Then you'll be able to query something like:

Article.objects.filter(case_tags__in =user.user_interests)

Hope this helps

answered May 8, 2017 at 21:04

pleasedontbelong

20.1k12 gold badges55 silver badges79 bronze badges

Collectives™ on Stack Overflow

How to filter django python object with list

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related