You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The problem
So, basically, i'm trying to filter a m2m related field, the m2m related field has profit and volume.
I created annotations for max_volume and max_profit, and also i wanna filter by the annotated field to exclude those rows where max_profit or max_volume is null, but i get the "column doesn't exist" error, which is clearly false.
Moreover, i've run the raw query on the database itself and it worked.
this method .filter(max_volume__isnull=False) basically triggers the error
Expected behavior
I'm a bit confused here, it should just perform the filtering, but somehow it just won't.
Moreover, due to a lack of exeperience with Tortoise i can't even write my own query and convert it to QuerySet, well, i can, but it ain't gonna look pretty.
The text was updated successfully, but these errors were encountered:
The problem
So, basically, i'm trying to filter a m2m related field, the m2m related field has profit and volume.
I created annotations for max_volume and max_profit, and also i wanna filter by the annotated field to exclude those rows where max_profit or max_volume is null, but i get the "column doesn't exist" error, which is clearly false.
Moreover, i've run the raw query on the database itself and it worked.
this method
.filter(max_volume__isnull=False)
basically triggers the errorExpected behavior
I'm a bit confused here, it should just perform the filtering, but somehow it just won't.
Moreover, due to a lack of exeperience with Tortoise i can't even write my own query and convert it to QuerySet, well, i can, but it ain't gonna look pretty.
The text was updated successfully, but these errors were encountered: