python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - annotate

Django how to get the value of other fields in annotate Max？

I want to get the value of other fields('status') in annotate Max or Min，how can I do it？ DB user time status name_a 2022-01-03 11:23:40.000000 3 name_a 2022-01-03 17:56:41.000000 4 name_a...
test-img

yuong

django

filter

max

min

annotate

Votes: 0

Answers: 1

Latest Answer

You can use Attendance.objects.order_by('time').first().status - get status of min date. And use Attendance.objects.order_by('time').last().status - get status of max date.
test-img

Airat Ahunov

Django annotate with frequency

(django 3.2.12, python 3.9.3, MySQL 8.0.28) Imagine models like the following: class User(models.Model): email = models.EmailField(...) created_datetime = models.DatetimeField(...) class User...
test-img

Hal

mysql

django

frequency

annotate

Votes: 0

Answers: 1

Latest Answer

Found a workaround: users = User.objects.filter( Q(...) ).annotate( login_count=Count('userlog', filter=Q(userlog__login=True)), login_duration_over=Now() - F('created_datetime'), logi...
test-img

Hal

R - Filled area using geom_rect or annotate rect, returning errors

I'm trying to create a colored/shaded horizontal band across my graph in RStudio. I want the filled band between 60 and 100 on the y axis, the entire length of the x axis. x axis is a date range y axi...
test-img

Angela Malzow

r

date

shapes

annotate

geom

Votes: 0

Answers: 0

Cannot resolve keyword annotated field django

this is my model class ExchangeReportTime(models.Model): creator = models.ForeignKey('accounts.Account', on_delete=models.CASCADE, null=True, verbose_name=_('Creator')) create_time = models.Da...
test-img

hn_tired

django

annotate

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs