limited choose list depented on another

Question

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

Estudios, Procesos y Sistemas · 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

관련 게시물	답글	화면
On_change domain on one2many field domain one2many	2 6월 15	3970
domain on a field in computed one2many domain one2many computed-fields	0 9월 24	1508
dynamic domain in one2many 해결 완료 domain one2many dynamic	2 5월 24	9655
How to return domain on one2many field so that seleted values are not shown in next line domain one2many onchange	1 4월 23	5474
onchange return domain for one2many product ID Field 해결 완료 domain one2many onchange	7 4월 23	19501

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!