Opened 4 years ago

Closed 4 years ago

#18569 closed New feature (wontfix)

Enable L expressions in `queryset.extra`

Reported by: jbzdak@… Owned by: nobody
Component: Database layer (models, ORM) Version: 1.4
Severity: Normal Keywords:
Cc: Triage Stage: Unreviewed
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no


Here is my problem: in a django queryset I need to call a stored procedure that does some spatial lookup. This procedure takes three parameters: two constants, and one SQL expression. This expression is equivalent to django queryset lookup: path, but as far as I know there is no way to pass L expression to queryset.extra (well, at least I tried).

It would be great if I could pass L expressions to queryset extra (somehow), could you enable it?

If it is indeed possible (well StackOverflow says it is not) please treat this ticked as a documentation update request.

Change History (2)

comment:1 Changed 4 years ago by jbzdak@…

Component: UncategorizedDatabase layer (models, ORM)
Needs documentation: unset
Needs tests: unset
Patch needs improvement: unset
Type: UncategorizedNew feature

Oh well forgot to set bug properties.

comment:2 Changed 4 years ago by Aymeric Augustin

Resolution: wontfix
Status: newclosed

extra often creates more problem than it solves. The current trend is to deprecate it rather than extend it.

The recommended way to achieve your goal is to use raw SQL.

Note: See TracTickets for help on using tickets.
Back to Top