How to filter objects based on model fields in Django

Question

I have a Model named Order that has a foreign key pointed to the current user

class Order(models.Model):
customer_name = models.ForeignKey(
settings.AUTH_USER_MODEL,
on_delete=models.CASCADE,
related_name='customer_name',
)
order_individual_price = models.IntegerField(default=1)
order_default_price = models.IntegerField(default=1)
order_name = models.CharField(max_length=200)
order_quantity = models.IntegerField(default=1)
order_total_price = models.IntegerField(default=1)

I currently have 2 order objects from 2 different users. How would I filter the objects so that it only shows the one from a specific user?

I currently have the following code: Order.objects.filter(customer_name='chironsus')

It gives me this error: ValueError: Field 'id' expected a number but got 'chironsus'.

willeM_ Van Onsem · Accepted Answer · 2020-04-30 20:06:43Z

1

'chironsus' is not the primary key of a User, it is perhaps the username. You can filter that with:

Order.objects.filter(customer_name__username='chironsus')

Note: A ForeignKey does not store the string representation (or name) of the referenced object in the column, it stores the primary key of the record it references in a column with an _id suffix to a ForeignKey field. Therefore ForeignKeys usually do not end with a _name suffix. You might want to consider renaming the ~~customer_name~~ field to customer.

answered Apr 30, 2020 at 20:06

willeM_ Van Onsem

482k33 gold badges483 silver badges624 bronze badges

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

Collectives™ on Stack Overflow

How to filter objects based on model fields in Django

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related