starred/netbox
1
0
Fork 0
mirror of https://github.com/netbox-community/netbox.git synced 2026-01-13 22:03:32 +01:00
Code Issues 273 Packages Projects Releases 10 Wiki Activity

GraphQL: NOT-Filter (here for tenants_list) not honored for group(_id) and results includes the filtered group #10546

New Issue
Closed
opened 2025-12-29 21:32:59 +01:00 by adam · 2 comments
adam commented 2025-12-29 21:32:59 +01:00
Owner
Copy Link

Originally created by @dxks on GitHub (Dec 5, 2024).

Deployment Type

Self-hosted

Triage priority

N/A

NetBox Version

v4.1.7

Python Version

3.12

Steps to Reproduce

All verified on demo.netbox.dev (so assumption is that Tenant-Group Customers exists)

  1. Create a new Tenant-Group (i.e. Partners)
  2. Create a new Tenant and make it a member of Partners

Fire the folling graphql query:

query MyQuery {
  tenant_list(filters:{NOT:{group:"customers"}}) {
    id
    name
    group {
      id
      name
      slug
    }
  }
}

Expected Behavior

Getting a list of all Tenants that are not member of the group Customers:

{
  "data": {
    "tenant_list": [
      {
        "id": "15",
        "name": "NetBoxLabs",
        "group": {
          "id": "2",
          "name": "Partners",
          "slug": "partners"
        }
      }
    ]
  }
}

Observed Behavior

Getting a list of all Tenants that are member of the group Customers:

{
  "data": {
    "tenant_list": [
      {
        "id": "7",
        "name": "Cyberdyne Systems",
        "group": {
          "id": "1",
          "name": "Customers",
          "slug": "customers"
        }
      },
      {
        "id": "5",
        "name": "Dunder-Mifflin, Inc.",
        "group": {
          "id": "1",
          "name": "Customers",
          "slug": "customers"
        }
      },
      {
        "id": "1",
        "name": "Initech",
        "group": {
          "id": "1",
          "name": "Customers",
          "slug": "customers"
        }
      },
      {
        "id": "10",
        "name": "Jimbob's Banking & Trust",
        "group": {
          "id": "1",
          "name": "Customers",
          "slug": "customers"
        }
      },
      {
        "id": "13",
        "name": "NC State University",
        "group": {
          "id": "1",
          "name": "Customers",
          "slug": "customers"
        }
      },
      {
        "id": "9",
        "name": "Nakatomi Corportation",
        "group": {
          "id": "1",
          "name": "Customers",
          "slug": "customers"
        }
      },
      {
        "id": "3",
        "name": "Pied Piper",
        "group": {
          "id": "1",
          "name": "Customers",
          "slug": "customers"
        }
      },
      {
        "id": "4",
        "name": "Stark Industries",
        "group": {
          "id": "1",
          "name": "Customers",
          "slug": "customers"
        }
      },
      {
        "id": "2",
        "name": "Strickland Propane",
        "group": {
          "id": "1",
          "name": "Customers",
          "slug": "customers"
        }
      },
      {
        "id": "8",
        "name": "Umbrella Corporation",
        "group": {
          "id": "1",
          "name": "Customers",
          "slug": "customers"
        }
      },
      {
        "id": "6",
        "name": "Wayne Enterprises",
        "group": {
          "id": "1",
          "name": "Customers",
          "slug": "customers"
        }
      }
    ]
  }
}
Originally created by @dxks on GitHub (Dec 5, 2024). ### Deployment Type Self-hosted ### Triage priority N/A ### NetBox Version v4.1.7 ### Python Version 3.12 ### Steps to Reproduce All verified on demo.netbox.dev (so assumption is that Tenant-Group Customers exists) 1. Create a new Tenant-Group (i.e. Partners) 2. Create a new Tenant and make it a member of Partners Fire the folling graphql query: ``` query MyQuery { tenant_list(filters:{NOT:{group:"customers"}}) { id name group { id name slug } } } ``` ### Expected Behavior Getting a list of all Tenants that are not member of the group Customers: ``` { "data": { "tenant_list": [ { "id": "15", "name": "NetBoxLabs", "group": { "id": "2", "name": "Partners", "slug": "partners" } } ] } } ``` ### Observed Behavior Getting a list of all Tenants that are member of the group Customers: ``` { "data": { "tenant_list": [ { "id": "7", "name": "Cyberdyne Systems", "group": { "id": "1", "name": "Customers", "slug": "customers" } }, { "id": "5", "name": "Dunder-Mifflin, Inc.", "group": { "id": "1", "name": "Customers", "slug": "customers" } }, { "id": "1", "name": "Initech", "group": { "id": "1", "name": "Customers", "slug": "customers" } }, { "id": "10", "name": "Jimbob's Banking & Trust", "group": { "id": "1", "name": "Customers", "slug": "customers" } }, { "id": "13", "name": "NC State University", "group": { "id": "1", "name": "Customers", "slug": "customers" } }, { "id": "9", "name": "Nakatomi Corportation", "group": { "id": "1", "name": "Customers", "slug": "customers" } }, { "id": "3", "name": "Pied Piper", "group": { "id": "1", "name": "Customers", "slug": "customers" } }, { "id": "4", "name": "Stark Industries", "group": { "id": "1", "name": "Customers", "slug": "customers" } }, { "id": "2", "name": "Strickland Propane", "group": { "id": "1", "name": "Customers", "slug": "customers" } }, { "id": "8", "name": "Umbrella Corporation", "group": { "id": "1", "name": "Customers", "slug": "customers" } }, { "id": "6", "name": "Wayne Enterprises", "group": { "id": "1", "name": "Customers", "slug": "customers" } } ] } } ```
adam added the type: bugstatus: duplicatetopic: GraphQL labels 2025-12-29 21:32:59 +01:00
adam closed this issue 2025-12-29 21:32:59 +01:00
adam commented 2025-12-29 21:33:00 +01:00
Author
Owner
Copy Link

@dxks commented on GitHub (Dec 5, 2024):

Looks like OR also not working:

query MyQuery {
  tenant_list(filters:{group:"customers", OR:{group:"partners"}}) {
    id
    name
    group {
      id
      name
      slug
    }
  }
}

brings an empty list:

{
  "data": {
    "tenant_list": []
  }
}

so only the last group value is used for filtering

@dxks commented on GitHub (Dec 5, 2024): Looks like OR also not working: ``` query MyQuery { tenant_list(filters:{group:"customers", OR:{group:"partners"}}) { id name group { id name slug } } } ``` brings an empty list: ``` { "data": { "tenant_list": [] } } ``` so only the last group value is used for filtering
adam commented 2025-12-29 21:33:00 +01:00
Author
Owner
Copy Link

@arthanson commented on GitHub (Dec 5, 2024):

Closing as a dupe of #17688

@arthanson commented on GitHub (Dec 5, 2024): Closing as a dupe of #17688
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
beta
breaking change
complexity: high
complexity: low
complexity: medium
needs milestone
netbox
pending closure
plugin candidate
pull-request
Mirrored from GitHub Pull Request
 severity: high
severity: low
severity: medium
status: accepted
status: backlog
status: blocked
status: duplicate
status: needs owner
status: needs triage
status: revisions needed
status: under review
topic: GraphQL
topic: Internationalization
topic: OpenAPI
topic: UI/UX
topic: cabling
topic: event rules
topic: htmx navigation
topic: industrialization
topic: migrations
topic: plugins
topic: scripts
topic: templating
topic: testing
type: bug
type: deprecation
type: documentation
type: feature
type: housekeeping
type: translation
No Label status: duplicate topic: GraphQL type: bug
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
adam
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/netbox#10546
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?