#28527: How rewrite query in Django ORM?
-------------------------------------+-------------------------------------
     Reporter:  Nikolas              |                    Owner:  nobody
         Type:  Uncategorized        |                   Status:  closed
    Component:  Database layer       |                  Version:  1.11
  (models, ORM)                      |
     Severity:  Normal               |               Resolution:  invalid
     Keywords:                       |             Triage Stage:
                                     |  Unreviewed
    Has patch:  0                    |      Needs documentation:  0
  Needs tests:  0                    |  Patch needs improvement:  0
Easy pickings:  0                    |                    UI/UX:  0
-------------------------------------+-------------------------------------

Comment (by Nikolas):

 i try


 {{{
 obs = Goods.objects\
         .annotate(data2=Func(
                     # F('data'),
                     F('data'),
                     Value("'-'"), Value("' '"),
                     function='replace',

                 ))\
         .filter(
             Q(data__contains="Andrew") |
             Q(
                 data2=Func(
                     F('data'),
                     Value("'-'"), Value("' '"),
                     function='replace',
                 ),
             ))
 }}}


 but cant compare to function (not field), this is not documented, can
 litle help please?
 and i think must be more examples in Docs, complex and big examples, very
 need.

 Thanks for great soft!

-- 
Ticket URL: <https://code.djangoproject.com/ticket/28527#comment:2>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/069.00eddd274639df30b0adfa3ccf7b8ca1%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to