Custom script, filter on tags to VLAN

[Mats Brorson]

This have to be simple. Use case:

- A bunch of VLANs are reserved

- We use tags to define for what purpouse we have reserved them, and what system they are reserved for etc

- We have therefore a need in our automation to filter on more than one tag with no user input

Filter on one tag i simple (using nbshell to mess about):

VLAN.objects.filter(status='reserved', tags__name='eBGP')

But how do I filter in this case, so I get all VLANs that have bothe the 'eBGP' tag AND for example 'OpenStack'?

[Brian Candler]

For the OR condition, do this:

VLAN.objects.filter(tags__name__in=['eBGP', 'OpenStack'])

For the AND condition, do this:

VLAN.objects.filter(tags__name='eBGP').filter(tags__name=OpenStack')

[Mats Brorson]

Dang it, I was thinking about nested filters, but dismissed it before trying. Brian, you are a hero!