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
8784	Add HAVING-clauses to QuerySets	Johntron	Johntron	"We need some way to include HAVING clauses in QuerySets. The HAVING clause allows aliases to be used as operands in conditionals. The db.models.QuerySet.extra() looks like the best method to use for something like this, so I've added some code to db.models.QuerySet.extra() method and the corresponding db.models.sql.query.Query class. See patch.

A use case:
{{{
locations = Location.objects.extra( select={'distance': 'SQRT(POW(69.1 * (lattitude - %f), 2) + POW(69.1 * (longitude - %f) * COS(lattitude/57.3), 2))' % (lat, lng)} )
locations = locations.extra( having=['distance < %f' % maxdist] )
}}}"	Uncategorized	closed	Database layer (models, ORM)	dev	Normal	wontfix	db query having clause extra database	klemens@…	Unreviewed	1	1	1	0	0	0