"Platform" field doesn't fully support lookup expression #3746

New Issue

adam · 2025-12-29T18:30:53+01:00

adam commented

2025-12-29 18:30:53 +01:00

Originally created by @eshcheglov on GitHub (Jun 3, 2020).

Environment

Python version: 3.6.8
NetBox version: 2.8.5

Steps to Reproduce

Create Platform with any name. e.x: name: "Windows Server", slug:"windows-server"
Create device and set it platform to "Windows Server"
Try to apply "nic" lookup expression (__nic) to "platform" field:

GET /api/dcim/devices/?limit=0platform__nic=Windows

HTTP 200 OK
Allow: GET, POST, HEAD, OPTIONS
Content-Type: application/json
Vary: Accept

{
    "count": 1

However, regular "n" expression (__n) can be applied:

GET /api/dcim/devices/?limit=0&platform__n=windows-server

HTTP 200 OK
Allow: GET, POST, HEAD, OPTIONS
Content-Type: application/json
Vary: Accept

{
    "count": 0

Expected Behavior

Devices with "Windows" in "Platform" parameter filtered out

Observed Behavior

Devices with "Windows" in "Platform" parameter is still visible

Originally created by @eshcheglov on GitHub (Jun 3, 2020). ### Environment * Python version: 3.6.8 * NetBox version: 2.8.5 ### Steps to Reproduce 1. Create Platform with any name. e.x: name: "Windows Server", slug:"windows-server" 2. Create device and set it platform to "Windows Server" 3. Try to apply **"nic"** lookup expression (__nic) to "platform" field: ``` GET /api/dcim/devices/?limit=0platform__nic=Windows HTTP 200 OK Allow: GET, POST, HEAD, OPTIONS Content-Type: application/json Vary: Accept { "count": 1 ``` However, regular "**n**" expression (__n) can be applied: ``` GET /api/dcim/devices/?limit=0&platform__n=windows-server HTTP 200 OK Allow: GET, POST, HEAD, OPTIONS Content-Type: application/json Vary: Accept { "count": 0 ``` ### Expected Behavior Devices with "Windows" in "Platform" parameter filtered out ### Observed Behavior Devices with "Windows" in "Platform" parameter is still visible

adam closed this issue

2025-12-29 18:30:53 +01:00

adam commented

2025-12-29 18:30:54 +01:00

@jeremystretch commented on GitHub (Jun 3, 2020):

Per the docs:

Certain other fields, namely foreign key relationships support just the negation expression: n

platform is a ForeignKey field, from the Device model to the Platform model, as opposed to a CharField on the Device model. Thus, only basic negation is supported.

@jeremystretch commented on GitHub (Jun 3, 2020): Per [the docs](https://netbox.readthedocs.io/en/stable/api/filtering/): > Certain other fields, namely foreign key relationships support just the negation expression: n `platform` is a ForeignKey field, from the Device model to the Platform model, as opposed to a CharField on the Device model. Thus, only basic negation is supported.

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#3746