Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0052606
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 00. Application dictionarymajoralways2023-05-30 00:382023-06-23 14:48
ReporteraxelmercadoView Statuspublic 
Assigned ToTriage Platform Base 
PriorityhighResolutionno change requiredFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket65000
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0052606: Unable to create a computed column for m_offer_product table

DescriptionThe 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 Reproduce1-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.
TagsNo tags attached.
Attached Filespng file icon img1.png [^] (141,275 bytes) 2023-05-30 00:39


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

- Relationships [ Relation Graph ] [ Dependency Graph ]
duplicate of defect 0052859 closedAugustoMauch It is not possible to have computed columns both in m_product and m_offer_product 

-  Notes
(0150758)
ivazquez (viewer)
2023-06-05 23:19

 Hello Team

There is any update related to this issue?

Regards,
Ignacio Vazquez
(0151061)
AugustoMauch (administrator)
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 (viewer)
2023-06-12 15:08

 Why? If it's not normally required.
(0151567)
AugustoMauch (administrator)
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 OBNetwork customer => OBPS
2023-05-30 00:38 axelmercado Modules => Core
2023-05-30 00:38 axelmercado Support ticket => 65000
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
Powered by Mantis Bugtracker