Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0013977 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| feature request | [Openbravo ERP] 00. Application dictionary | minor | always | 2010-07-15 17:04 | 2022-02-01 08:08 | |||||||
| Reporter | networkb | View Status | public | |||||||||
| Assigned To | Triage Platform Base | |||||||||||
| Priority | high | Resolution | open | Fixed in Version | ||||||||
| Status | scheduled | 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 | 2.50MP19 | 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 | 0013977: problem when adding a "DocumentNo" field in a table from an external module | |||||||||||
| Description | If you want to add a "DocumentNo" field in a table allocated in another different module, the application does not recognize it as "DocumentNo" (due to needed name "EM_PREFIX_DocumentNo") and does not generate the sequence associated (as it does when you create a "DocumentNo" field in a table of your module) | |||||||||||
| Steps To Reproduce | 1. Create new module "in development", depending of core and set a DB Prefix for it (PREFIX) 2. In Database: add new column in a_amortization table called "EM_PREFIX_DocumentNo" 3. In AD Amortization table add a new column and choose recently created "EM_PREFIX_DocumentNo". Set ApplicationElement=DocumentNo 4. In AD Amortization window, go to Header tab and press "Create Field" button to add your new field. 5. ant smartbuild 6. Access to Amortization window and realize that your new DocumentNo field does not work as a normal "DocumentNo" field, as it has not been recognized by the application Usually when you add a "DocumentNo" field to a table of you module using name DocumentNo (instead of EM_PREFIX_DocumentNo) a sequence associated is generated | |||||||||||
| Proposed Solution | Modify selectDocumentsNo in Fields_data.xsql to support "EM_*_DocumentNo" | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0029663) alostale (manager) 2010-07-29 12:27 |
This issue is similar to 0009016 It will be fixed as a feature request. Meanwhile the workaround is to create the sequence manually. |
|
(0044099) egoitz (developer) 2012-01-03 12:12 |
Posible solution: MOdify the file src-wad/src/org/openbravo/wad/Fields_data.xsql On selectDocumentsNo method replace and ad_column.columnname = 'DocumentNo' with and ad_column.columnname = 'DocumentNo' OR ad_column.columnname like 'EM_%_DocumentNo' |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2010-07-15 17:04 | networkb | New Issue | |
| 2010-07-15 17:04 | networkb | Assigned To | => alostale |
| 2010-07-19 08:24 | alostale | Status | new => scheduled |
| 2010-07-29 12:25 | alostale | Relationship added | related to 0009016 |
| 2010-07-29 12:25 | alostale | Type | defect => feature request |
| 2010-07-29 12:25 | alostale | Target Version | 2.50MP21 => |
| 2010-07-29 12:27 | alostale | Note Added: 0029663 | |
| 2010-08-27 09:38 | networkb | Proposed Solution updated | |
| 2012-01-03 12:12 | egoitz | Note Added: 0044099 | |
| 2017-04-10 14:38 | alostale | Assigned To | alostale => platform |
| 2022-02-01 08:08 | alostale | Assigned To | platform => Triage Platform Base |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |