Is there a way to annotate django query with non-expression?

Question

I have use case where I need to get all objects where existing_field is the beginning of some string.

some string changes dynamically so I need a smart way to filter out objects.

My idea is to create annotated query like this:

MyModel.objects.annotate(annotated_field='some string').filter(annotated_field__startswith=F('existing_field'))

Currently it is failing with: QuerySet.annotate() received non-expression(s): some string

Is there a way to annotate objects with string value?

makozaki · Accepted Answer · 2019-10-16 11:59:23Z

18

Not sure what you're asking but try Value expression.

MyModel.objects.annotate(annotated_field=Value('some string', output_field=CharField())).filter(annotated_field__startswith=F('existing_field'))

edited Oct 16, 2019 at 11:59

makozaki

4,4367 gold badges31 silver badges56 bronze badges

answered Oct 16, 2019 at 10:25

kyore

8425 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

makozaki Over a year ago

Great thanks. Solved it in the meantime like you said but first annotated then filtered. annotated_field needs to be created first.

rahulg · Accepted Answer · 2022-02-25 00:13:52Z

2

For those who are still facing the problem with newer versions of Django will have to use ExpressionWrapper and probably F

from django.db.models import ExpressionWrapper, F
MyModel.objects.annotate(annotated_field=ExpressionWrapper(Value('some string', output_field=CharField()))).filter(annotated_field__startswith=F('existing_field'))

answered Feb 25, 2022 at 0:13

rahulg

2,2794 gold badges36 silver badges47 bronze badges

Collectives™ on Stack Overflow

Is there a way to annotate django query with non-expression?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related