BUG: API get stockmovements sqlfilter - Unknown column 't.product_id'

[JonBendtsen]

Bug

BUG: when I try to use the API to get stockmovements for a product the text says:

Other criteria to filter answers separated by a comma. Syntax example "(t.product_id:=:1) and (t.date_creation:

but when I actually use it with this sqlfilter (t.product_id:=:128)

I get the error message

{
  "error": {
    "code": 503,
    "message": "Service Unavailable: Error when retrieve stock movement list : Unknown column 't.product_id' in 'WHERE'"
  }
}

Dolibarr Version

21.0.1

Environment PHP

8.2.28

Environment Database

mariadb latest

Steps to reproduce the behavior and expected behavior

No response

Attached files

No response