/Python/Django/Queryset.raw() in django rest framework joining tables

Queryset.raw() in django rest framework joining tables

class MyModelViewSet(viewsets.ModelViewSet):
    # The usual stuff here
    model = MyModel

    def list(self, request):
        queryset = MyModel.objects.raw('... your SQL here...')
        serializer = MyModelSerializer(queryset, many=True)
        return Response(serializer.data)

Similar codes

1 vote217 views1 answer
Select realted for foreign key table in django
Python Django
0 vote244 views1 answer
Field 'id' expected a number but got <django.db.models.fields.related_descriptors.create_forward_many_to_many_manager.<locals>.ManyRelatedManager object at 0x7fb02044de80>
Python Django
0 vote198 views1 answer
Get list of users django
Python Django
0 vote200 views2 answers
Django-filter
Python Django
0 vote203 views1 answer
Select default option django form
Python Django
1 vote194 views1 answer
Django sites framework
Python Django
0 vote244 views1 answer
Django database connection isn't set to UTC postgresql
Python Django
0 vote201 views1 answer
Django.db.utils.ProgrammingError: relation "users" does not exist in django 3.0
Python Django
4 votes201 views1 answer
Django objects.create()
Python Django
4 votes208 views1 answer
Django forms set class
Python Django