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 13261 SQL Update VS extra() or filter() Stephane nobody "Hi, I add one of this two filters on the query with a get_query_set() in a manager: * {{{qset = qset.filter(site=settings.SITE_ID)}}} * {{{qset = qset.extra(where=['site_id = %s' % settings.SITE_ID])}}} All fine when I try to perform a SELECT, but when I do an UPDATE, the site_id are in the SET ({{{UPDATE ... SET site_id = 1 WHERE ...}}}) of the query and not in the WHERE ({{{UPDATE ... SET ... WHERE site_id = 1}}}). Stéphane" closed Database layer (models, ORM) dev worksforme sql update extra filter Accepted 0 0 0 0 0 0