id Summary Keywords Owner Type Status priority 11104 HAVING filter screws with extra() SQL parameter ordering QuerySet.extra Bug closed 11459 QuerySet.count() generates invalid sql when used with select_related() and extra(where=[customWhereClause]) QuerySet.extra nobody Bug closed 11671 Aggregations add extra values to ValuesQuerySets :: another usecase QuerySet.extra Bug closed 12890 extra() tables included twice do not generate aliases QuerySet.extra daveycrockett Bug closed 19434 "Some QuerySet methods not aware of fields added on ""extra""" QuerySet.extra nobody Bug closed 24142 extra() field overwritten when using union on two querysets QuerySet.extra nobody Bug closed 25240 "Add ""week"" lookup to DateField/DateTimeField" QuerySet.extra Mads Jensen New feature closed 25339 Aggregation and annotation by time period and intervals (by month, week, day, hour, etc) QuerySet.extra nobody New feature closed 25403 Subqueries: a common case where people get tempted to use .extra() QuerySet.extra nobody New feature closed 25427 Trying to do a full text search query on a database field (non model field), the .annotate(val=RawSQL(...)).filter(val=VAL1) doesn't work. QuerySet.extra nobody Bug closed 25676 Queryset.extra planned deprecation - Sorting a calculated field Queryset.extra nobody Uncategorized closed 25768 Cast Variable, and provide multiplication QuerySet.extra nobody Uncategorized closed 25789 Inefficient Queries Generated due to not using WHERE EXISTS QuerySet.extra nobody Cleanup/optimization new 25861 Performing two conditional counts on foreign key fields QuerySet.extra nobody Uncategorized closed 25977 Allow different filters on multiple aggregates QuerySet.extra nobody New feature closed 26010 I need to count objects in a queryset by year and month Queryset.extra nobody New feature closed 26100 Queryset.extra use case: iregex against regular expressions stored as fields Queryset.extra nobody Uncategorized closed 26194 WHERE EXISTS / WHERE NOT EXISTS clause without using QuerySet.extra QuerySet.extra nobody Uncategorized closed 26426 Add a way to customize a QuerySet's joins QuerySet.extra nobody New feature closed 26574 Need to do bitwise operations in where clause QuerySet.extra nobody New feature closed 26602 Provide a way to manage grouping with RawSQL QuerySet.extra Manav Agarwal New feature closed 26634 Add the ability to do subselects for querying versioned data QuerySet.extra nobody New feature closed 26641 Unable to concatenate 2 fields when filtering QuerySet.extra nobody Uncategorized closed 26649 Group by date_trunc (day, month, year) without extra Queryset.extra nobody Uncategorized closed 27429 had to use QuerySet.extra to do WHERE LIKE with arbitrary amount / placement of wildcard characters QuerySet.extra nobody New feature closed 27841 ORM 'join on' with extra restrictions QuerySet.extra nobody New feature closed 28107 Can't perform annotation on related table when un-managed model is backed by a DB view QuerySet.extra Vojtěch Boček Bug closed 28317 QuerySet.extra cannot reference a column name with a capital letter QuerySet.extra nobody Bug closed 28318 Django Doesn't Support Triple Joins Without Extra QuerySet.extra nobody New feature closed 28446 QuerySet.extra is required for using SQL functions in SELECT clause QuerySet.extra nobody Cleanup/optimization closed 28621 Crash in QuerySet.annotate() with OuterRef QuerySet.extra Mariusz Felisiak Bug closed 28756 QuerySet API .extra( ) usage for FIELD + ORDER BY of queryset QuerySet.extra nobody Uncategorized closed 28919 Add support for Common Table Expression (CTE) queries QuerySet.extra Genaro Camele New feature assigned 29422 "QuerySet.extra use case - ""earth_box"", ""ll_to_earth""" QuerySet.extra, queryset, extra, earth_box, ll_to_earth, models, function, expression, manager nobody Cleanup/optimization closed 29526 Use of QuerySet.extra() when excluding twice a string occurance QuerySet.extra nobody Uncategorized closed 29527 Multi-column comparisons QuerySet.extra nobody New feature closed 29551 My use-case of QuerySet.extra(): Join two models without explicit relation QuerySet.extra nobody Uncategorized closed 29555 Left outer join with extra condition Queryset.extra nobody Uncategorized closed 29996 QuerySet.extra using contains, startswith on integerfield QuerySet.extra nobody New feature closed 30074 Cannot Un-escape LIKE wildcards without .extra() QuerySet.extra nobody New feature closed 30650 Need QuerySet.extra for a where clause based on on a CharField value in a second model QuerySet.extra nobody New feature closed 30925 Missing queryset filter operator leads to extra operator use QuerySet.extra nobody New feature closed 31631 Use Django ORM Postgresql regex when the regex is in the database and the value is a string QuerySet.extra nobody New feature closed 32122 Querying GenericIPAddressField for inexact matches requires use of QuerySet.extra QuerySet.extra nobody Uncategorized closed 32525 Class Cast throws DataError when column contains numeric string or alphabet string in postgres QuerySet.extra nobody New feature closed 32636 "QuerySet.values()/values_list() crashes on a combined queryset ordered by ""extra"" select." queryset combined union difference intersection QuerySet.extra David Wobrock Bug closed 32879 Using extra instead annotate in ORM while using select_for_update QuerySet.extra nobody Uncategorized closed 33015 QuerySet.extra Use Case: filtering on large lists of tuples QuerySet.extra, Documentation nobody Cleanup/optimization closed 33138 Tuple comparison for efficient lexicographic ordering on multiple columns QuerySet.extra nobody New feature closed 33557 Traversing a reverse Generic Foreign Key QuerySet.extra nobody New feature closed 33792 Using QuerySet.extra works while RawSQL inside annotate fails QuerySet.extra nobody Uncategorized closed 33935 Support unaccent function in JSONField values QuerySet.extra nobody Uncategorized closed 33999 Efficient filter with join on soft link. QuerySet.extra nobody New feature closed 34029 Use case that require QuerySet.extra QuerySet.extra nobody New feature closed 34141 Prefetch querysets access to parent query through table QuerySet.extra nobody Uncategorized closed 34942 Add icontains support for PostgreSQL ArrayField QuerySet.extra, ArrayField, PostgreSQL, icontains nobody New feature closed 34962 Support for overriding result of model field values QuerySet.extra nobody New feature closed 35491 QuerySet.extra use case. Unnest array and make it lower. and make it an array again. QuerySet.extra nobody New feature closed 35568 Searching nested JSON values QuerySet.extra nobody Uncategorized closed 36218 allow annotate to override model's fields QuerySet.extra New feature closed 36690 Use case for EXTRA() QuerySet.extra Uncategorized closed