I have a schema:
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?
STRING_AGG(AV.NAME, ' ' ORDER BY AV.ATTRIBUTE_ID) ATT
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
PP.ACTIVE = TRUE
GROUP BY PP.ID, PP.NAME_TEMPLATE
ORDER BY PP.NAME_TEMPLATE
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 6/20/13, 6:54 PM|
|Seen: 693 times|
|Last updated: 6/21/15, 5:36 PM|