[Answered ]-How to compare 2 columns of a table through dynamic querying

2👍

For a non-dynamic filter field, I would use:

from django.db.models import F

Model.objects.filter(some_col=F(kwargs.get('predicted_value')))

But if you need it all dynamically, you can try with:

kwargs = {'predicted_value':F('actual_value')}
Model.objects.filter(**kwargs)

You can even access related fields:

kwargs = {'fk_field__somefield':F('actual_value')}
Model.objects.filter(**kwargs)
👤Gocht

Leave a comment