tickets: 8283
This data as json
| id | created | changetime | last_pulled_from_trac | stage | status | component | type | severity | version | resolution | summary | description | owner | reporter | keywords | easy | has_patch | needs_better_patch | needs_tests | needs_docs | ui_ux |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8283 | 2008-08-13 12:49:39 | 2011-09-28 16:12:17 | 2022-03-06 03:41:50.667027 | Accepted | closed | Database layer (models, ORM) | dev | fixed | .filter() is ignored after (query | query) construction | Model: {{{ from django.db import models from django.contrib.auth.models import User class Asset(models.Model): public = models.BooleanField(default=True) owner = models.ForeignKey(User) def __unicode__(self): return "%s, %d (%s)" % (self.owner.username, self.id, "public" if self.public else "private") }}} Let's create several assets: {{{ >>> from testqsbug.models import Asset >>> from django.contrib.auth.models import User >>> user1 = User.objects.get(username = "user1") >>> user2 = User.objects.get(username = "user2") >>> Asset.objects.create(public=True, owner=user1) <Asset: user1, 1 (public)> >>> Asset.objects.create(public=False, owner=user1) <Asset: user1, 2 (private)> >>> Asset.objects.create(public=True, owner=user2) <Asset: user2, 3 (public)> >>> Asset.objects.create(public=False, owner=user2) <Asset: user2, 4 (private)> }}} Let's query all public assets OR assets that belong to some user: {{{ >>> Asset.objects.filter(public=True) | Asset.objects.filter(owner=user1) [<Asset: user1, 1 (public)>, <Asset: user1, 2 (private)>, <Asset: user2, 3 (public)>] }}} Let's filter from the result assets owned by user again (silly, I know): {{{ >>> (Asset.objects.filter(public=True) | Asset.objects.filter(owner=user1)).filter(owner=user1) [<Asset: user1, 1 (public)>, <Asset: user1, 2 (private)>, <Asset: user2, 3 (public)>] }}} Uhm. Does not work. Both requests resulted in the same query: {{{ >>> q = (Asset.objects.filter(public=True) | Asset.objects.filter(owner=user1)) >>> print q.query SELECT "testqsbug_asset"."id", "testqsbug_asset"."public", "testqsbug_asset"."owner_id" FROM "testqsbug_asset" WHERE ("testqsbug_asset"."public" = True OR "testqsbug_asset"."owner_id" = 1 ) >>> q2 = (Asset.objects.filter(public=True) | Asset.objects.filter(owner=user1)).filter(owner=user1) >>> print q2.query SELECT "testqsbug_asset"."id", "testqsbug_asset"."public", "testqsbug_asset"."owner_id" FROM "testqsbug_asset" WHERE ("testqsbug_asset"."public" = True OR "testqsbug_asset"."owner_id" = 1 ) }}} Filtering by another user works fine: {{{ >>> (Asset.objects.filter(public=True) | Asset.objects.filter(owner=user1)).filter(owner=user2) [<Asset: user2, 3 (public)>] >>> q3 = (Asset.objects.filter(public=True) | Asset.objects.filter(owner=user1)).filter(owner=user2) >>> print q3.query SELECT "testqsbug_asset"."id", "testqsbug_asset"."public", "testqsbug_asset"."owner_id" FROM "testqsbug_asset" WHERE (("testqsbug_asset"."public" = True OR "testqsbug_asset"."owner_id" = 1 ) AND "testqsbug_asset"."owner_id" = 2 ) }}} | mtredinnick | dottedmag | 0 | 0 | 0 | 0 | 0 | 0 |