Node-red x Odoo : Display shippings (model = stock.picking) in a table

General
1

Hello, I am currently trying to display data from Odoo in a table. I managed to do it for the orders as well as the invoices. Now I want to display the shippings, and the model is stock.picking:

Here is my flow :

[
    {
        "id": "9ff503477380ceac",
        "type": "inject",
        "z": "486198275b562947",
        "name": "Customer",
        "props": [
            {
                "p": "payload"
            },
            {
                "p": "topic",
                "vt": "str"
            }
        ],
        "repeat": "",
        "crontab": "",
        "once": false,
        "onceDelay": 0.1,
        "topic": "",
        "payload": "Axelor",
        "payloadType": "str",
        "x": 120,
        "y": 60,
        "wires": [
            [
                "6514e55c727eed49"
            ]
        ]
    },
    {
        "id": "3d9a78fab3041c7f",
        "type": "ui_etable",
        "z": "486198275b562947",
        "payload": "[{\"title\":\"Name\",\"field\":\"name\",\"width\":\"10%\",\"editor\":false},{\"title\":\"Order Id\",\"field\":\"origin\",\"width\":\"10%\",\"editor\":false},{\"title\":\"Date Schedules\",\"field\":\"scheduled_date\",\"width\":\"20%\",\"editor\":true},{\"title\":\"Effective date\",\"field\":\"date_done\",\"width\":\"20%\",\"editor\":true},{\"title\":\"State\",\"field\":\"state\",\"width\":\"20%\",\"editor\":\"select\",\"editorParams\":{\"values\":[\"SALE\",\"DONE\",\"CANCELLED\"]}}]",
        "payloadType": "json",
        "options": "{\"movableColumns\":true,\"resizableColumns\":true,\"autoResize\":true,\"layout\":\"fitColumns\",\"pagination\":\"local\",\"height\":\"400px\",\"groupStartOpen\":true}",
        "group": "2084046d8009b725",
        "name": "etable",
        "order": 1,
        "width": 0,
        "height": 0,
        "columns": [],
        "outputs": 1,
        "cts": false,
        "x": 110,
        "y": 220,
        "wires": [
            []
        ]
    },
    {
        "id": "37eceb52227c5cc9",
        "type": "ui_button",
        "z": "486198275b562947",
        "name": "",
        "group": "f9835d7b536b6dd7",
        "order": 2,
        "width": 0,
        "height": 0,
        "passthru": false,
        "label": "DISPLAY STOCK.PICKING",
        "tooltip": "",
        "color": "",
        "bgcolor": "",
        "className": "",
        "icon": "",
        "payload": "",
        "payloadType": "num",
        "topic": "payload",
        "topicType": "msg",
        "x": 180,
        "y": 140,
        "wires": [
            [
                "a2a293783948fa50"
            ]
        ]
    },
    {
        "id": "a2a293783948fa50",
        "type": "change",
        "z": "486198275b562947",
        "name": "stock.picking",
        "rules": [
            {
                "t": "set",
                "p": "filters",
                "pt": "msg",
                "to": "[\t   [\t       ['partner_id', '=', msg.payload]\t      \t   ],\t   ['name', 'partner_id', 'scheduled_date', 'date_done', 'origin', 'state' ]\t]",
                "tot": "jsonata"
            }
        ],
        "action": "",
        "property": "",
        "from": "",
        "to": "",
        "reg": false,
        "x": 410,
        "y": 140,
        "wires": [
            [
                "5ba5bb9beba07731"
            ]
        ]
    },
    {
        "id": "5ba5bb9beba07731",
        "type": "odoo-xmlrpc-search-read",
        "z": "486198275b562947",
        "name": "",
        "host": "eff09f3d6f4be3f8",
        "model": "stock.picking",
        "filter": "",
        "offset": 0,
        "limit": 100,
        "x": 710,
        "y": 140,
        "wires": [
            [
                "3d9a78fab3041c7f"
            ]
        ]
    },
    {
        "id": "6514e55c727eed49",
        "type": "change",
        "z": "486198275b562947",
        "name": "res.partner",
        "rules": [
            {
                "t": "set",
                "p": "filters",
                "pt": "msg",
                "to": "[\t   [\t       ['name', '=', msg.payload]\t   ],\t   ['name']\t]",
                "tot": "jsonata"
            }
        ],
        "action": "",
        "property": "",
        "from": "",
        "to": "",
        "reg": false,
        "x": 390,
        "y": 60,
        "wires": [
            [
                "98ea76434f797123"
            ]
        ]
    },
    {
        "id": "98ea76434f797123",
        "type": "odoo-xmlrpc-search-read",
        "z": "486198275b562947",
        "name": "search read res.partner",
        "host": "eff09f3d6f4be3f8",
        "model": "res.partner",
        "filter": "",
        "offset": 0,
        "limit": 100,
        "x": 730,
        "y": 60,
        "wires": [
            [
                "37eceb52227c5cc9"
            ]
        ]
    },
    {
        "id": "2084046d8009b725",
        "type": "ui_group",
        "name": "etable",
        "tab": "a2250e2facce1eef",
        "order": 3,
        "disp": true,
        "width": 20,
        "collapse": false,
        "className": ""
    },
    {
        "id": "f9835d7b536b6dd7",
        "type": "ui_group",
        "name": "buttons",
        "tab": "a2250e2facce1eef",
        "order": 2,
        "disp": true,
        "width": 4,
        "collapse": false,
        "className": ""
    },
    {
        "id": "eff09f3d6f4be3f8",
        "type": "odoo-xmlrpc-config",
        "url": "http://edu-heclausanne-terre.odoo.com/xmlrpc/2/common",
        "db": "edu-heclausanne-terre",
        "username": "EstelleValerie.TsagueMbialeu@unil.ch",
        "password": "Etoile"
    },
    {
        "id": "a2250e2facce1eef",
        "type": "ui_tab",
        "name": "TG2Livraisons",
        "icon": "local_shipping",
        "order": 5,
        "disabled": false,
        "hidden": false
    }
]

I did the same I did it for the orders and invoices but it doesn't work for the stock.picking model and I don't understand why. Would anyone be able to help ?

2

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.