Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

limited choose list depented on another

By
Tadeusz Karpiński
on 6/20/13, 6:54 PM 694 views

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?

0

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

Your Answer

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

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

Asked: 6/20/13, 6:54 PM
Seen: 694 times
Last updated: 6/21/15, 5:36 PM