How to create a join using a reference field

[iehoshia (Josías)]

I want to join move.shipment and shipment.id

    if 'move.shipment' not in tables:
        shipment = Shipment.__table__()
        tables['move.shipment'] = shipment
        from_item = (from_item
            .join(shipment, condition=move.shipment == shipment.id))

I receive this error.

psycopg2errorsUndefinedFunction: operator does not exist: character varying = integer
LINE 1: IN “stock_shipment_out” AS “k” ON (“b”“shipment” = “k”“id”
^
HINT: No operator matches the given name and argument types You might need to add explicit type casts

Also is related with this

@classmethod
def _where(cls, tables, withs):
    Shipment = Pool().get('stock.shipment.out')
    
    context = Transaction().context
    shipment = Shipment.__table__()
    move = tables['move']
    where = super()._where(tables, withs)
    customer = context.get('customer')
    
    if customer:
        where &= shipment.customer == customer
    return where

I receive this error

psycopg2errorsUndefinedTable: missing FROM-clause entry for table “k”
LINE 1: “b”“effective_date” <= ‘2023-10-04’::date)) AND (“k”"custo

[maxx (Maxime Richez)]

move.shipment is a tuple with: shipment_model, id

Try something like this:

from_item = (from_item
        .join(shipment, (Concat(Shipment.__name__ + ',', shipment.id)) == move.shipment))

[iehoshia (Josías)]

It works like a charm! Thanks