I am getting this error message:
raise FieldError("Cannot resolve keyword '%s' into field. "
django.core.exceptions.FieldError: Cannot resolve keyword 'date' into
field. Choices are: bad, created, doa, entered, id, non, para, received,
released, slabel, specie, specie_id, supplier, supplier_id
these are my models:
Shipment:
class Shipment(models.Model):
supplier = models.ForeignKey(Supplier, on_delete=models.CASCADE)
created = models.DateTimeField(default=timezone.now)
slabel = models.CharField(max_length=10)
specie = models.ForeignKey(Specie, on_delete=models.CASCADE)
received = models.PositiveIntegerField(default=0)
bad = models.PositiveIntegerField(default=0)
non = models.PositiveIntegerField(default=0)
doa = models.PositiveIntegerField(default=0)
para = models.PositiveIntegerField(default=0)
released = models.PositiveIntegerField(default=0)
entered = models.BooleanField(default=False)
def get_absolute_url(self):
return reverse("shipments:detail", kwargs={"pk": self.pk})
def __str__(self):
return
f"{self.specie.name}-{self.created.strftime('%Y/%m/%d')}-{self.supplier.name}"
suppliers:
class Supplier(models.Model):
supplierID = models.PositiveIntegerField(default=1)
name = models.CharField(max_length=120)
logo = models.ImageField(upload_to="suppliers", default="no_picture.png")
phone = models.CharField(max_length=15, null=True)
email = models.CharField(max_length=120)
country = models.CharField(max_length=120, null=True, blank=True)
address = models.CharField(max_length=120, null=True, blank=True)
city = models.CharField(max_length=120, null=True, blank=True)
state = models.CharField(max_length=120, null=True, blank=True)
zipCode = models.CharField(max_length=10, null=True, blank=True)
def __str__(self):
return self.name
species:
class Specie(models.Model):
name = models.CharField(max_length=50)
image = models.ImageField(upload_to="species", default="no_picture.png")
created = models.DateTimeField(default=timezone.now)
def __str__(self):
return self.name
class Meta:
ordering = [
"name",
]
everything is working the way I want but when I try to get data into a
variable I get the above error and I don't have a clue where to start to
resolve this. As from the models I have no field named date so I am
confused.
The error is generated by this line:
qs = Shipment.objects.filter(date__range=[date_from, date_to])
even if I enter strings for testing, for example
qs = Shipment.objects.filter(date__range=['2021-01-01', '2021-02-01'])
I been all over the web looking for possible solutions but I am at a loss.
Thanks for any thoughts or suggestions you may have.
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/d4cbd3a1-92eb-48b1-8669-8e2b2a2196dan%40googlegroups.com.
