Skip to content

Error with queryset.values #129

@brykov93

Description

@brykov93

Hi.
I needed to display data after applying queryset.values. As a result, instead of data, ??? in all columns.
Model:

class StudyUploadLog(models.Model):
study_instance_uid = models.CharField(max_length=150, verbose_name='Study Instance UID')
patient = models.CharField(max_length=150, verbose_name='Patient')
instance_uid = models.CharField(max_length=150, verbose_name='Instance UID')
upload_date = models.DateTimeField(verbose_name='Upload time')
completed = models.BooleanField(verbose_name='Completed', default=False)

View:

class UploadingStudies(AjaxDatatableView):
model = StudyUploadLog
title = 'Лог получения исследований'
#initial_order = [["upload_date", "desc"], ]
length_menu = [[50, 100, -1], [50, 100, 'Все']]
search_values_separator = '+'
disable_queryset_optimization_only = True
column_defs = [
{'name': 'id', 'visible': False, 'searchable': False, },
{'name': 'patient', 'title': 'Пациент', 'searchable': False, 'visible': True},
{'name': 'study_instance_uid', 'title': 'Идентификатор исследования', 'searchable': False, 'visible': True},
# {'name': 'progress', 'title': 'Прогресс', 'searchable': False, 'visible': True},
{'name': 'images_count', 'title': 'Количество файлов', 'searchable': False, 'visible': True},
{'name': 'start_date', 'title': 'Время начала приема', 'searchable': False, 'visible': True},
{'name': 'end_date', 'title': 'Время окончания приема', 'searchable': False, 'visible': True},
{'name': 'completed', 'title': 'Прием окончен', 'searchable': False, 'visible': True, 'boolean': True,},
]
def get_initial_queryset(self, request=None):
queryset = super().get_initial_queryset(request=request)
queryset = (queryset.values('patient', 'study_instance_uid', 'completed')
.annotate(images_count=Count('instance_uid'),
id=Max('id'),
start_date=Min('upload_date'),
end_date=Max('upload_date')))
return queryset

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions