How to filter by location, excluding child locations?

[llamafilm]

I have a hierarchy of locations like this:

• Floor 1
  • Room 1
  • Room 2
• Floor 2
  • Room 3
  • Room 4

Some devices don't belong in a specific room, like access points, so we put them in the 'Floor 1' location. If I filter like /dcim/devices/?location_id=10138 that includes all the child locations too. Is there a way to include only devices which are directly in Floor 1, excluding everything in a room?

[llamafilm]

I figured out how to do this in GraphQL, but that doesn't help me in the UI.

{
  device_list(
    filters: {
      location_id: {
        id: "10138",
        match_type: EXACT
      }
    }
  ) {id}
}

[zmaster7]

The latest releases of NetBox added filters options for is_not in the UI for most fields, and if you were to filter on is_not you can see it uses the location_id__n=# formatting. I believe if you string both together in the URI you can achieve what you're looking for (e.g. /dcim/devices/?location_id=#&location_id__n=# ) by negating child location ids, while specifying the parent.

[zmaster7]

I just tried this with success in my own test environment. I have location id 7 as the parent and location id 8 as the child. The parent has 12 devices directly assigned, and the child has 1, for 13 total under the parent umbrella. I used ?location_id=7&location_id__n=8 and it correctly returned ONLY the 12 devices directly assigned to the parent location.

While you can use location__name='Floor 1' as an exact match filter in nbshell, it does not appear to work in the URI.

[llamafilm]

Thanks! That could be useful sometimes. But I have hundreds of child locations so it's not really practical in this case.