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
29168	Document how to write a custom lookup where the rhs comes before the lhs	JJ Gutierrez	nobody	"The page for creating custom field lookups is incomplete. I am referring to the doc at https://docs.djangoproject.com/en/2.0/howto/custom-lookups/. The documentation is unclear about how to use the left-hand side value (lhs) and right-hand side value (rhs) properly. For example, lets say you have a lookup like 
{{{
id__custom='abc123'
}}}
The lhs is the ID field and the rhs is the 'abc123'. I want to create a query like 
{{{
WHERE 'abc123' LIKE id||%
}}}
However the documentation is unclear about how to reference the lhs in the as_sql method. Users would like to know how to reference the rhs BEFORE the LIKE and the lhs AFTER the LIKE in the sql query above. The documentation only shows examples where the lhs comes first and the rhs last. This would help users create a custom lookup with the sql above."	Cleanup/optimization	closed	Documentation	2.0	Normal	invalid	lookup		Unreviewed	0	0	0	0	0	0