0052606: Unable to create a computed column for m_offer_product table

Description

The partner Practics has reported that they are trying to create a computed column in the m_offer_product table which generates the attached error (img1).

For our part, we have investigated and also reproduced the problem in a clean environment, also can not create the computed column in a pristine, always in the m_offer_product table, it generates the second attached error (img2).

Steps To Reproduce

1-In the backoffie, create a computed column in the m_offer_products table. For example with the following query: (select pricelist from m_productprice where m_productprice.m_product_id=m_product_id limit 1).

2- Create a new field for the computed column in the "Products" tab for the "discount and promotions" window.

3- Export the changes, compile and build the environment.

4- Login to the client, go to the Discount and promotions window, select a value and try to open the "Products" tab.

5- Verify that it shows an error, whatever the query is.

Tags

No tags attached.

Attached Files

img1.png [^] (141,275 bytes) 2023-05-30 00:39

img2.png [^] (203,795 bytes) 2023-05-30 00:39

Relationships [ Relation Graph ] [ Dependency Graph ]

duplicate of

defect

0052859

closed

AugustoMauch

It is not possible to have computed columns both in m_product and m_offer_product

Notes
(0150758) ivazquez (developer) 2023-06-05 23:19	Hello Team There is any update related to this issue? Regards, Ignacio Vazquez

(0151061) AugustoMauch (manager) 2023-06-12 15:06	There is no issue, the query just requires to use an alias, replace select pricelist from m_productprice where m_productprice.m_product_id=m_product_id limit 1 with select pp.pricelist from m_productprice pp where pp.m_product_id=m_product_id limit 1

(0151062) Practics (reporter) 2023-06-12 15:08	Why? If it's not normally required.

(0151567) AugustoMauch (manager) 2023-06-23 14:48	Why? If it's not normally required -> I reviewed all the computed columns currently defined in our standard modules and all of them have aliases

Issue History
Date Modified	Username	Field	Change
2023-05-30 00:38	axelmercado	New Issue
2023-05-30 00:38	axelmercado	Assigned To	=> Triage Platform Base
2023-05-30 00:38	axelmercado	Modules	=> Core
2023-05-30 00:38	axelmercado	Triggers an Emergency Pack	=> No
2023-05-30 00:39	axelmercado	File Added: img1.png
2023-05-30 00:39	axelmercado	File Added: img2.png
2023-05-30 07:16	Practics	Issue Monitored: Practics
2023-06-02 01:37	ivazquez	Issue Monitored: ivazquez
2023-06-05 23:19	ivazquez	Note Added: 0150758
2023-06-12 15:06	AugustoMauch	Note Added: 0151061
2023-06-12 15:06	AugustoMauch	Status	new => closed
2023-06-12 15:06	AugustoMauch	Resolution	open => no change required
2023-06-12 15:08	Practics	Note Added: 0151062
2023-06-23 14:48	AugustoMauch	Note Added: 0151567
2023-06-27 18:14	AugustoMauch	Relationship added	duplicate of 0052859