Passa al contenuto
È necessario essere registrati per interagire con la community.
Tutti gli articoli Persone Badge
Etichette (Mostra tutto)
odoo accounting v14 pos v15
Sul forum
La domanda è stata contrassegnata
domainone2many
1 Rispondi
4262 Visualizzazioni
Avatar
Tadeusz Jan Karpiński

I have a schema:

tnij.org/schema1

There are not all tables included in that project, but this should be enough.

I have a problem. I want to make that user can choose an attribute and then choose value (connected with attribue).

For example Color: Red, Blue, Green, Yellow Size: 21, 22, 23, 24.

How can I do this with that schema? By now I added third function field to product_attribute_value that gives me all releated_attributes connected with value in which I am,. Problem is that in OpenErp cant make domain="[('related_attributes','=',attribute_id)] "lists"="int"

Have you any idea how to solve it?

Avatar
Abbandona
Avatar
Estudios, Procesos y Sistemas
Risposta migliore

Try this


SELECT
PP.ID,
PP.NAME_TEMPLATE,
STRING_AGG(AV.NAME, ' ' ORDER BY AV.ATTRIBUTE_ID) ATT
FROM
PRODUCT_PRODUCT PP
INNER JOIN PRODUCT_TEMPLATE PT ON PP.PRODUCT_TMPL_ID = PT.ID
LEFT JOIN PRODUCT_ATTRIBUTE_VALUE_PRODUCT_PRODUCT_REL PR ON PP.ID = PR.PROD_ID
LEFT JOIN PRODUCT_ATTRIBUTE_VALUE AV ON PR.ATT_ID = AV.ID
WHERE
PP.ACTIVE = TRUE
GROUP BY PP.ID, PP.NAME_TEMPLATE
ORDER BY PP.NAME_TEMPLATE

Avatar
Abbandona
Post correlati Risposte Visualizzazioni Attività
On_change domain on one2many field
domain one2many
Avatar
Avatar
2
giu 15
3869
domain on a field in computed one2many
domain one2many computed-fields
Avatar
0
set 24
1411
dynamic domain in one2many Risolto
domain one2many dynamic
Avatar
Avatar
Avatar
2
mag 24
9517
How to return domain on one2many field so that seleted values are not shown in next line
domain one2many onchange
Avatar
1
apr 23
5352
onchange return domain for one2many product ID Field Risolto
domain one2many onchange
Avatar
Avatar
Avatar
Avatar
7
apr 23
19347