Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
domainone2many
1 Odgovori
4740 Prikazi
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
Opusti
Avatar
Estudios, Procesos y Sistemas
Best Answer

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
Opusti
Related Posts Odgovori Prikazi Aktivnost
On_change domain on one2many field
domain one2many
Avatar
Avatar
2
jun. 15
4398
domain on a field in computed one2many
domain one2many computed-fields
Avatar
0
sep. 24
1989
dynamic domain in one2many Solved
domain one2many dynamic
Avatar
Avatar
Avatar
2
maj 24
10192
How to return domain on one2many field so that seleted values are not shown in next line
domain one2many onchange
Avatar
1
apr. 23
6012
onchange return domain for one2many product ID Field Solved
domain one2many onchange
Avatar
Avatar
Avatar
Avatar
7
apr. 23
19987