id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
35413	FieldError: Unsupported lookup error message can be confusing.	Alex	wookkl	"On these example queries on DateTimeFields:

{{{
TestModel.objects.filter(created_at__gt__foo='2024-01-01')
TestModel.objects.filter(created_at__gt__='2024-01-01')  # I'm a bit surprised this one also has the same message.
TestModel.objects.filter(created_at__gt__lt='2024-01-01')
}}}
The error message is this
{{{
django.core.exceptions.FieldError: Unsupported lookup 'gt' for DateTimeField or join on the field not permitted, perhaps you meant gt or gte?
}}}

The error message should clarify better the issue."	Cleanup/optimization	closed	Database layer (models, ORM)	5.0	Normal	fixed		Alex	Ready for checkin	1	0	0	0	0	0