Skip to Content
This question has been flagged
dashboardodoospreadsheetodoo16features
1 Reply
2175 Views
Avatar
Muthaiyan 
In sale order spreadsheet dashboard - How to get the quotation records data from this code: ODOO.LIST(1,1,\"name\")". 
what does the meaning of the 
"content": "=ODOO.LIST(1,1,\"name\")" and 
"content": "=ODOO.PIVOT.HEADER(5,\"#country_id\",2)"

"A19": {
    "style": 1,
    "content": "[Top Quotations](odoo://view/{\"viewType\":\"list\",\"action\":{\"domain\":[[\"state\",\"in\",[\"draft\",\"sent\"]]],\"context\":{\"group_by\":[]},\"modelName\":\"sale.order\",\"views\":[[false,\"list\"],[false,\"kanban\"],[false,\"form\"],[false,\"calendar\"],[false,\"pivot\"],[false,\"graph\"],[false,\"activity\"],[false,\"search\"]]},\"threshold\":0,\"name\":\"Quotations\"})",
    "border": 1
},
"A20": {
    "style": 2,
    "content": "=_t(\"Quotation\")",
    "border": 2
},
"A21": {
    "style": 3,
    "content": "=ODOO.LIST(1,1,\"name\")"
},


Avatar
Discard
Avatar
Muthaiyan
Author Best Answer

There is a lists and pivots available in sales_dashboard.json file ODOO.LIST(1,1,\"name\")"  Means : From this list records from the lIsts.  "1" is identify the code of records list, "1" is a From this list first record.


ODOO.LIST This value getting from this code :

"lists": {
      "1": {
          "columns": [
              "name",
              "partner_id",
              "user_id",
              "amount_untaxed"
          ],
          "domain": [
              "|",
              [
                  "state",
                  "=",
                  "draft"
              ],
              [
                  "state",
                  "=",
                  "sent"
              ]
          ],
          "model": "sale.order",
          "context": {},
          "orderBy": [
              {
                  "name": "amount_untaxed",
                  "asc": false
              }
          ],
          "id": "1",
          "name": "Quotations by Untaxed Amount"
      }
  },

As we ll as ODOO.PIVOTS also:

"pivots": {
    "3": {
        "colGroupBys": [],
        "context": {
            "params": {
                "action": 1275,
                "model": "sale.report",
                "view_type": "pivot",
                "menu_id": 878,
                "cids": 1
            },
            "group_by_no_leaf": 1,
            "group_by": []
        },
        "domain": [
            [
                "categ_id",
                "!=",
                false
            ], [
                "state",
                "not in",
                [
                    "draft",
                    "sent",
                    "cancel"
                ]
            ]
        ],
        "id": "3",
        "measures": [
            {
                "field": "order_id"
            },
            {
                "field": "price_subtotal"
            }
        ],
        "model": "sale.report",
        "rowGroupBys": [
            "categ_id"
        ],
        "name": "Sales Analysis by Product Category",
        "sortedColumn": {
            "groupId": [
                [],
                []
            ],
            "measure": "price_subtotal",
            "order": "desc"
        }
    },


Avatar
Discard
Related Posts Replies Views Activity
Spreadsheet Dashboard Solved
dashboard odoo spreadsheet odoo16features
Avatar
Avatar
Avatar
2
Mar 24
1806
haw to link purchase order with its payments?
odoo odoo16features
Avatar
Avatar
1
Apr 25
1371
How to dynamically pass the ID in willStart function
javascript custom dashboard odoo odoo16features
Avatar
Avatar
1
Feb 24
2020
Odoo App Solved
odoo odoo16features
Avatar
Avatar
1
Nov 23
1939
Work Order Timer Losing Sync - Odoo.sh 16
odoo odoo16features
Avatar
0
May 24
1665