exclude does not support nested ForeignKey relationship

[ftamy9]

There is a problem on exclude. you can not use nested ForeignKey. I tested on 4.2.1 and 4.1.
for example if you need to find trips that are not trip__method__title=ShippingChoice.ORGANIZATION
Here is the code:

    working_shipments = Shipment.objects.exclude(
        state__in=[
            ShipmentStateChoices.CANCELLED,
            ShipmentStateChoices.DELIVERED
        ],
        trip__method__title=ShippingChoice.ORGANIZATION
    ).filter(
        updated_at__lt=time_threshold,
    )

So you are forced to use a big list on filter instead to use the exclude. like this:

    working_shipments = Shipment.objects.exclude(
        state__in=[
            ShipmentStateChoices.CANCELLED,
            ShipmentStateChoices.DELIVERED
        ]
    ).filter(
        updated_at__lt=time_threshold,
        trip__method__title__in=(ShippingChoice.ALO,  ShippingChoice.SNAP, ShippingChoice.MIAREH)  
    )

the objects.exclude bug need to fixed

[David Sanders]

formatted description

[Mariusz Felisiak]

It's not clear to me what you're trying to report, however, it appears to be a support question. If you're having trouble understanding how Django works, see TicketClosingReasons/UseSupportChannels for ways to get help.

If you believe there is an issue in Django, then please follow our ​bug reporting guidelines and include a clear, concise description of the problem.

[David Sanders]

Also I just tested exclude with nested fks and it's working ok.

[David Sanders]

Hi ftamy9

Please don't reopen the ticket unless more information is provided. You'll need to paste your models (only the necessary bits required for testing) + the query you tried that wasn't working.

[Simon Charette]

There are a few known limitations / bugs with exclude (#14645, #27867, #25991) that could be the cause here but it's impossible to tell without the exact model definition and test setup to reproduce.

[ftamy9]

the model files attached

[Mariusz Felisiak]

The following query works for me:

working_shipments = Shipment.objects.exclude(
    trip__method__title=ShippingChoice.ORGANIZATION
).filter(
    updated_at__lt=datetime.datetime.now(),
)

Again, please try to use support channels.