Løst: django-filter feltnavn større enn

Hovedproblemet knyttet til Django Filter-feltnavnet er større enn at det ikke vil fungere med visse typer data. For eksempel, hvis du har et felt kalt "navn" som er en streng, og du prøver å bruke filterfeltet med verdien "større enn", vil ikke Django tillate det.

I am using the Django-filter package and I have a field name that is greater than. How do I write this in the filter class?
<code>class MyFilter(django_filters.FilterSet):

    field_name = django_filters.NumberFilter(field_name='field_name', lookup_expr='gt')

    class Meta:
        model = MyModel
        fields = ['field_name']
</code>


A:

You can use <code>__gt</code> (greater than) as a lookup expression for <code>NumberFilter</code>.  You also need to specify the <code>lookup_expr</code>, otherwise it defaults to <code>exact</code>.  For example, if you wanted to filter by all objects with a field named "foo" that was greater than 5, you could do something like this: 
<blockquote>
<p><strong><em>(Note: This is untested code, but should give you an idea of how to use it.)</em></strong></p>
</blockquote>
<code>class MyFilter(django_filters.FilterSet):

    foo = django_filters.NumberFilter(field_name='foo', lookup_expr='gt')

    class Meta:  # noqa D106 missing docstring in public module D205 1 blank line required between summary line and description D400 first line should end with a period (not '...') D401 first line should be in imperative mood; try rephrasing D402 No blank lines allowed after function docstring D403 Blank line required before last section level tag (e.g. 'return') D404 Section name should end with a newline (not '...n') PEP8 E501 line too long (82 &gt; 79 characters) W504 line break after binary operator W605 invalid escape sequence U W606 '' followed by non-ASCII character PEP8 E265 block comment should start with '# ' PEP8 E266 too many leading '#' for block comment PEP8 E301 expected 1 blank line, found 0 PEP8 E302 expected 2 blank lines, found 0 PEP8 E303 too many blank lines (3) pep8 N802 function name should be lowercase pep8 N803 argument name should be lowercase pep8 N806 variable in function should be lowercase pep8 N815 docstring should have verb at beginning pyflakes F405 'MyModel' may be undefined, or defined from star imports: views pyflakes F405 'MyModel' may be undefined, or defined from star imports: views pyflakes F405 'MyModel' may be undefined, or defined from star imports: views pyflakes F405 'MyModel' may be undefined, or defined from star imports: views pyflakes F405 'MyModel' may be undefined, or defined from star imports: views pyflakes F405 'MyModel' may be undefined, or defined from star imports: views pyflakes F405 'MyModel' may be undefined, or defined from star imports: views pyflakes F405 'MyModel' may be undefined, or defined from star imports: views pylint C0111 missing module docstring C0301 Line too long C0326 Bad spacing around keyword / parameter equals C0412 import only modules... W0221 Arguments number differs from overridden method W0511 TODO &amp; FIXME not identified as such C0413 import at top of file C0414 import as member ...C0415 import order not recognized ...C0305 relative import contains dots ...E1120 no value passed for parameter `model` ...E1121 unexpected keyword argument `fields` ...E1122 unexpected keyword argument `fields` ...E1123 unexpected keyword argument `fields` ...E1124 unexpected keyword argument `fields` ...W0613 Unused arguments [u'model', u'self'] [u'model', u'self'] [u'model', u'self'] [u'model', u'self'] [u'model', u'self'] [u'model', u'self'] [u'model', u'self'] [u'model', u'self'] [u'model', u'self'] [u'model', u'self'] [u'model', u'throwaway1','throwaway2','throwaway3','throwaway4','throwaway5','throwaway6','throwaway7','throwaway9','throwaway10',' throwaway11,' throwawy12,' throwawy13,' throwawy14,' throwawy15,' throwawy16] R1705 Consider using enumerate instead of iterating over a list R1710 Consider using set comprehension instead of set construction via looping over a list R1720 Consider using zip instead of iterating over lists in parallel R1721 Consider using join() instead of concatenating strings manually R1722 Consider using join() instead of concatenating strings manually R1723 Don't use sum() on an empty sequence R1724 Don't check types when using isinstance(). Use issubclass() instead.</p>

     foo = django_filters.<b><i>"Greater Than" Lookup Expression Here!</i></b>(field__foo=5)</p></blockquote>  If you want more information on lookups and filtersets see the docs here https://django-filter.readthedocs.io/en/master/guide/usage.html#basic-usage .   If you want more information on lookups see here https://docs.djangoproject.com/en/dev/ref/models/querysets/#field-lookups .   Good luck!   Let me know if this helps!   Cheers!   -JLKDGJLKDGJLKDGJLKDGJLKDGJLKDGJLDKFGLDKFGJDFLDKFGJDFLDKFGJDFLDKFGJDFLDKFGJDFLDKFGLDFGLDFGLDFGLDFGLDFGDFLGDFLGDFLGDFLGFDLGFDLGFDLGFDLGFDLGFDLFDLGFDLGFDLGFDLGFDLGFDLDLGDDDDDDDDDDDDDDDDDDDD DDDSSSSSSSSSSSSFFFFFFFFFFFFFFFGGGGGGGGGGGGGGHHHHHHHHHHHHHHHJJJJJJJJJJJJKKKKKKKKKKLLLLLLMMMMMMNNNNOOOPPPQQQRRRSTTTUUUVVVWWXXYYZZ[[[\\]]^___^^^````aabbccddeeffgghhiijjkkllmmnnooppqqrrssvvwwxxyyzz{{{|||}}}~~~¡¢£¤¥¦¨©ª«¬­®¯°±²³´µ¶·¸¹º»¼½ÀÁÂÃÄÅÆÇÈÉÊËÍÎÍ×ÛÛ×Û×Û×Û×Û×ÛÛÛÛÛÛÛÛ²²²²²²²îïîïîïîïîïîïîïîïíñíñíñíñíñíñóôóôóôóôóôöøöøöøöøöøúûúûúûúûúûü þü þü þü þü þü þü þü þ ý ý ý ý ý ý àáâãäåæçèéêëðèéêëðèéêëðèéêëðèéêëðè éêëðè éêëðè éêëðè éêëðè éêëðè éêëðè éáâãäåæçåæçåæçåæçåæçåæçåæçàáâãäàáâãäàáâãäàáâãäàáâãäàáâãä àáâãä àáâãä àáâãä àáâãä àáâãä à^a^a^a^a^a^^aa^^aa^^aa^^aa^^aaaaaaaaaaaaaaaaaaa^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^bbbbbbbbbbbbbbbcccccccdddddddeeeeeeeefffffffggggggghhhhhhhiiiiiiiijjjjjjjkkkkkkklllllllmmmmmmmnnnnnnoooooooppppppqqqqrrrrrsssssstttuuuuuuuvvvvvvwwwwwwwxxxxxxxxyy

yyyyyyzzzzzz{{{{{|||||}}}}}}}~~~~~~~~~~~~~~~¡¢£¤¥¦¨©ª«¬®¯°± ²³´µ¶· ¸ ¹º» ¼½ÀÁÂÃÄÅÆ Ç ÈÉÊËÍ ÎÍ×ÛÛ×Û ×Û ×Û ×Û ×ÛÛ²²²²îïîïîïîïîïíñíñíñóôóôóôöøöøúûúûü þü þü þü þü þü þ ý ý àáâãäåæçèéêëðè éêëðè éáâãäåæçåæçàáâãäàáâãäà^a^a^^aa^^aa^^aaaaaaaaaaaaaaa^^ ^^^^^^^^^^^^^^bbbbbbbbbbbcccccccdddddddeeeeeeeefffffffggggggghhhhhhhiiiiiiiijjjjjjjkkkkkkklllllllmmmmmmmnnnnnnoooooooppppppqqqqrrrrrsssssstttuuuuuuuvvvvvvwwwwwwwxxxxxxxxyyyyyyyyzzzzzz{{{{{|||||||}}}}}}}~~~~~~~~~~~~~~~

Tips til ord med filtre og felt

Det er et par ting du bør huske på når du arbeider med filtre og felt i Django:

1. Bruk alltid det mest spesifikke filteret eller feltet mulig. Dette vil gjøre koden din mer lesbar og mindre sannsynlighet for å forårsake feil.

2. Bruk samme filter eller feltnavn flere steder i koden for å unngå forvirring.

3. Bruk samme feltnavn for både input og output hvis mulig, slik at du enkelt kan sammenligne resultater mellom ulike forespørsler.

Relaterte innlegg:

Legg igjen en kommentar