MultiValueNumberFilter does not support custom field integer values #5585

New Issue

adam · 2025-12-29T19:29:47+01:00

adam commented

2025-12-29 19:29:47 +01:00

Originally created by @jeremystretch on GitHub (Oct 29, 2021).

Originally assigned to: @jeremystretch on GitHub.

NetBox version

v3.0.8

Python version

3.7

Steps to Reproduce

The following script can be pasted into the NetBox shell (manage.py nbshell) for a demonstration of the root issue.

import django_filters
from dcim.models import Site
from utilities.filters import MultiValueNumberFilter


class MyFilterSet(django_filters.FilterSet):
    asn = MultiValueNumberFilter()
    cf_foo = MultiValueNumberFilter(
        field_name='custom_field_data__foo'
    )
    class Meta:
        model = Site
        fields = ['asn']


filterset1 = MyFilterSet({'asn': ['123', '456']}, Site.objects.all())
filterset2 = MyFilterSet({'cf_foo': ['123', '456']}, Site.objects.all())

print(filterset1.qs.query)
print(filterset2.qs.query)

This issue was observed during work on #6615. See my comment here.

Expected Behavior

The WHERE clause of the second query should match on the integer values 123 and 456.

WHERE (("dcim_site"."custom_field_data" -> foo) = 123 OR ("dcim_site"."custom_field_data" -> foo) = 456)

Observed Behavior

The query instead matches on the string representations of these values:

WHERE (("dcim_site"."custom_field_data" -> foo) = "123" OR ("dcim_site"."custom_field_data" -> foo) = "456")

Originally created by @jeremystretch on GitHub (Oct 29, 2021). Originally assigned to: @jeremystretch on GitHub. ### NetBox version v3.0.8 ### Python version 3.7 ### Steps to Reproduce The following script can be pasted into the NetBox shell (`manage.py nbshell`) for a demonstration of the root issue. ``` import django_filters from dcim.models import Site from utilities.filters import MultiValueNumberFilter class MyFilterSet(django_filters.FilterSet): asn = MultiValueNumberFilter() cf_foo = MultiValueNumberFilter( field_name='custom_field_data__foo' ) class Meta: model = Site fields = ['asn'] filterset1 = MyFilterSet({'asn': ['123', '456']}, Site.objects.all()) filterset2 = MyFilterSet({'cf_foo': ['123', '456']}, Site.objects.all()) print(filterset1.qs.query) print(filterset2.qs.query) ``` This issue was observed during work on #6615. See my comment [here](https://github.com/netbox-community/netbox/pull/7678#issuecomment-954811979). ### Expected Behavior The `WHERE` clause of the second query should match on the integer values `123` and `456`. ``` WHERE (("dcim_site"."custom_field_data" -> foo) = 123 OR ("dcim_site"."custom_field_data" -> foo) = 456) ``` ### Observed Behavior The query instead matches on the string representations of these values: ``` WHERE (("dcim_site"."custom_field_data" -> foo) = "123" OR ("dcim_site"."custom_field_data" -> foo) = "456") ```

adam added the type: bug status: accepted labels 2025-12-29 19:29:47 +01:00

adam closed this issue

2025-12-29 19:29:47 +01:00

Sign in to join this conversation.

Branches Tags

main

update-changelog-comments-docs

feature-removal-issue-type

20911-dropdown

20239-plugin-menu-classes-mutable-state

21097-graphql-id-lookups

feature

fix_module_substitution

20923-dcim-templates

20044-elevation-stuck-lightmode

feature-ip-prefix-link

v4.5-beta1-release

20068-import-moduletype-attrs

20766-fix-german-translation-code-literals

20378-del-script

7604-filter-modifiers-v3

circuit-swap

12318-case-insensitive-uniqueness

20637-improve-device-q-filter

20660-script-load

19724-graphql

20614-update-ruff

14884-script

02496-max-page

19720-macaddress-interface-generic-relation

19408-circuit-terminations-export-templates

20203-openapi-check

fix-19669-api-image-download

7604-filter-modifiers

19275-fixes-interface-bulk-edit

fix-17794-get_field_value_return_list

11507-show-aggregate-and-rir-on-api

9583-add_column_specific_search_field_to_tables

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: starred/netbox#5585