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

**URL:** <https://discourse.nodered.org/t/node-red-x-odoo-display-shippings-model-stock-picking-in-a-table/61436>\
**Category:** General\
**Created:** [18 April 2022 12:49 UTC](https://discourse.nodered.org/t/node-red-x-odoo-display-shippings-model-stock-picking-in-a-table/61436 "2022-04-18T12:49:40Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![cpedroni](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/cpedroni/32/59502_2.png) [@cpedroni](https://discourse.nodered.org/u/cpedroni)\
**Post date:** [18 April 2022 12:49 UTC](https://discourse.nodered.org/t/node-red-x-odoo-display-shippings-model-stock-picking-in-a-table/61436/1 "2022-04-18T12:49:40Z")

</div>

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 :

```auto
[
    {
        "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 ?

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [17 June 2022 12:50 UTC](https://discourse.nodered.org/t/node-red-x-odoo-display-shippings-model-stock-picking-in-a-table/61436/2 "2022-06-17T12:50:32Z")

</div>

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