Changeset 7625 for django/trunk/docs/db-api.txt

Timestamp:

06/12/08 08:19:37 (5 months ago)

Author:

russellm

Message:

Fixed #7327 -- Added documentation and test case for defining subqueries. Thanks, Sebastian Noack.

Files:

• django/trunk/docs/db-api.txt (modified) (1 diff)

django/trunk/docs/db-api.txt

@@ -1374 +1374 @@
-    SELECT ... WHERE id IN (1, 3, 4);
-
+You can also use a queryset to dynamically evaluate the list of values
+instead of providing a list of literal values. The queryset must be
+reduced to a list of individual values using the ``values()`` method, 
+and then converted into a query using the ``query`` attribute::
+
+    Entry.objects.filter(blog__in=Blog.objects.filter(name__contains='Cheddar').values('pk').query)
+
+This queryset will be evaluated as subselect statement::
+
+    SELET ... WHERE blog.id IN (SELECT id FROM ... WHERE NAME LIKE '%Cheddar%')
+
-startswith
-~~~~~~~~~~