Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0052606 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 00. Application dictionary | major | always | 2023-05-30 00:38 | 2023-06-23 14:48 | |||
Reporter | axelmercado | View Status | public | |||||
Assigned To | Triage Platform Base | |||||||
Priority | high | Resolution | no change required | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | |||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Review Assigned To | ||||||||
Web browser | ||||||||
Modules | Core | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 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 | ![]() ![]() | |||||||
![]() |
||||||||
|
![]() |
|
(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 |
![]() |
|||
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 |
Copyright © 2000 - 2009 MantisBT Group |