Ad
Non-relational Field Given In Select_related: ' '. Choices Are: (none)
I have two models from different apps:
class Measure(models.Model):
date = models.DateTimeField(default="2018-01-23 15:55")
average = models.FloatField(default=0)
class Sensor(models.Model):
measure=models.ForeignKey(Measure, on_delete=models.CASCADE)
value= models.FloatField(default=0)
I'm calling all data coming from sensors as follow:
new_context = Sensor.objects.select_related('measure__date')
However, I receive this error:
django.core.exceptions.FieldError: Non-relational field given in select_related: 'date'. Choices are: (none)
from documentation, I should be using select_related instead of prefetch_related, and the call seems to be coherent.
Am I missing something?
Ad
Answer
In select_related
only fields that are ForeignKey
should be set. In your case the issue it that date
field is a DateTimeField
and not ForeignKey
.
So in order to solve it just do it:
new_context = Sensor.objects.select_related('measure')
You can see examples of using syntax in docs.
Ad
source: stackoverflow.com
Related Questions
- → What are the pluses/minuses of different ways to configure GPIOs on the Beaglebone Black?
- → Django, code inside <script> tag doesn't work in a template
- → React - Django webpack config with dynamic 'output'
- → GAE Python app - Does URL matter for SEO?
- → Put a Rendered Django Template in Json along with some other items
- → session disappears when request is sent from fetch
- → Python Shopify API output formatted datetime string in django template
- → Can't turn off Javascript using Selenium
- → WebDriver click() vs JavaScript click()
- → Shopify app: adding a new shipping address via webhook
- → Shopify + Python library: how to create new shipping address
- → shopify python api: how do add new assets to published theme?
- → Access 'HTTP_X_SHOPIFY_SHOP_API_CALL_LIMIT' with Python Shopify Module
Ad