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\")"
},
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Boekhouding
- Voorraad
- PoS
- Project
- MRP
Deze vraag is gerapporteerd
1
Beantwoorden
2360
Weergaven
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"
}
},
Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!
Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!
AanmeldenGerelateerde posts | Antwoorden | Weergaven | Activiteit | |
---|---|---|---|---|
Spreadsheet Dashboard
Opgelost
|
|
2
mrt. 24
|
1952 | |
|
1
apr. 25
|
1525 | ||
|
1
feb. 24
|
2145 | ||
Odoo App
Opgelost
|
|
1
nov. 23
|
2110 | |
|
0
mei 24
|
1841 |