Django to have conditional column based on another column

[Nathaniel Brown]

I am looking to do a pre-fetch on a data model that conditionally loads either of two columns based on what's in another column.

Simply put, if the title tag has <file> in it, then the model should load the file_value column. If it does not, then load the body column.

I'd like to use it with the get object or 404 if possible.

poem = get_object_or_404(Poem, pk=poem_id)

[Mariusz Felisiak]

You can add an annotation based on Case() expression to the ​base queryset.

Please use one of support channels if you have further questions.