Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0003976Openbravo ERP00. Application dictionarypublic2008-06-14 02:032008-12-02 13:02
Reportergalderromo 
Assigned Toalostale 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionGentoo 2.6.24
Product Version2.35MP4 
Target Version2.40Fixed in Versionpi 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0003976: identifier&isselectioncolumn on foreign keys when generating windows.
DescriptionIt looks like when generating a window, if there is a foreign key, WAD gets the column matching the lowest sequence and isselectioncolumn='Y' even if this column is not an identifier. Although the application is looking for an identifier.
Steps To ReproduceUsing the standard configuration.
1- Trough the application dictionary go to table: C_BPARTNER.
2- Column: TaxID
3- Get the lowest sequence and mark as isselectioncolumn, make sure it is not an identifier.
4- Compile Bank Statement window (for example)
ERROR:
     [java] 1535 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/BankStatement/Lines_data.xsql processed
     [java] 1726 [main] ERROR org.openbravo.data.Sqlc - SQL error in query:
     [java] SELECT FROM C_BPartner WHERE isActive='Y' AND C_BPartner_ID = ?
     [java] Exception:java.sql.SQLException: ORA-00936: missing expression
5- Mark TaxID column as identifier and compile Bank Statement window: NO ERROR
6- Mark TaxID column as no identifier and get a higher sequence and compile Bank Statement window: NO ERROR
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0003985 closed alostale identifier&isselectioncolumn on foreign keys when generating windows. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-06-14 02:03galderromoNew Issue
2008-06-14 02:03galderromoAssigned To => cromero
2008-06-16 11:14psarobeStatusnew => scheduled
2008-06-16 11:14psarobeAssigned Tocromero => alostale
2008-06-16 11:15psarobePrioritynormal => high
2008-06-16 11:15psarobeTarget Version => 2.40
2008-06-16 11:15psarobeStatusscheduled => feedback
2008-06-16 11:16psarobeStatusfeedback => scheduled
2008-06-17 10:21alostaleNote Added: 0007761
2008-06-17 10:23alostaleNote Added: 0007762
2008-06-17 10:24svnbotCheckin
2008-06-17 10:24svnbotNote Added: 0007763
2008-06-17 10:24svnbotStatusscheduled => resolved
2008-06-17 10:24svnbotResolutionopen => fixed
2008-06-17 10:24svnbotsvn_revision => 5084
2008-08-21 17:00psarobeRegression testing => No
2008-08-21 17:00psarobeStatusresolved => closed
2008-08-21 17:00psarobeFixed in Version => trunk
2008-12-02 13:02jaimetorresf_bug_id0 => 2377061

Notes
(0007761)
alostale   
2008-06-17 10:21   
The problem actually happens when:
1. There is a table (table A) that doesn't have any column set as identifier which sequence number is 1.
2. There is a tab with an action button with at least one of its parameters referencing to the table A.
(0007762)
alostale   
2008-06-17 10:23   
Solution: the identifier in case 2 is not going to be the column with seqno=1 but the lowest one.
(0007763)
svnbot   
2008-06-17 10:24   
Repository: openbravo
Revision: 5084
Author: alostale
Date: 2008-06-17 10:24:15 +0200 (Tue, 17 Jun 2008)

fixed bug 0003976: Identifier for parameters in action button are not taken with the column with seqno=1 but the lowest one set as identifier

---
U trunk/src-wad/src/org/openbravo/wad/Fields_data.xsql
U trunk/src-wad/src/org/openbravo/wad/datasource.xsqlxml
---

https://dev.openbravo.com/websvn/openbravo/?rev=5084&sc=1 [^]