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
26641	Unable to concatenate 2 fields when filtering	FoxPotato	nobody	"The docs said I should file a ticket when using the extra API.

I just need a way to use the icontains field lookup on 2 fields at once, for example the full name (first_name + last_name) of a user.

I managed it using the extra API like this:
{{{
User.objects.extra(where=['upper(concat(first_name, "" "", last_name)) LIKE upper(%s)'], params=[query])
}}}

"	Uncategorized	closed	Database layer (models, ORM)	1.9	Normal	invalid	QuerySet.extra	foxpotato5@…	Unreviewed	0	0	0	0	0	0