Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011569Openbravo ERP00. Application dictionarypublic2009-12-01 12:382010-01-21 00:00
Reporternetworkb 
Assigned Tomtaal 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP8 
Target Version2.50MP11Fixed in Version 
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
Summary0011569: The dataset's SQL Where Clause doesn't work properly
DescriptionThe dataset's SQL Where Clause works properly in this case:

IE:
table: c_phase
ad_client_id='1000'

but in this case works wrong:

IE:
table: c_phase
c_phase.ad_client_id='1000'
Steps To Reproduce-As System administrator go to Application Dictionary || Module
-Set Core in development.
-Save and go to Application Dictionary || Dataset
-Create a new record (Module: Core; Data Access Level: Client/Organization)
-Save and go to Table.
-Create a enw record:
    -Table: C_Phase
    -SQL Where Clause: c_phase.ad_client_id='1000'
-Save and go back to Dataset
-Click 'Export reference data'
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-12-01 12:38networkbNew Issue
2009-12-01 12:38networkbAssigned To => rafaroda
2009-12-01 12:57rafarodaNote Added: 0022297
2009-12-01 12:57rafarodaAssigned Torafaroda => alostale
2009-12-01 13:06alostaleNote Added: 0022301
2009-12-01 13:06alostaleStatusnew => closed
2009-12-01 13:06alostaleResolutionopen => no change required
2009-12-01 16:51networkbStatusclosed => new
2009-12-01 16:51networkbResolutionno change required => open
2009-12-01 16:53rafarodaNote Added: 0022324
2009-12-01 16:53rafarodaAssigned Toalostale => mtaal
2009-12-01 16:53rafarodaPriorityimmediate => high
2009-12-01 16:53rafarodaStatusnew => scheduled
2009-12-28 14:28shuehnerNote Added: 0023112
2010-01-19 19:00hgbotCheckin
2010-01-19 19:00hgbotNote Added: 0023577
2010-01-19 19:00hgbotStatusscheduled => resolved
2010-01-19 19:00hgbotResolutionopen => fixed
2010-01-19 19:00hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/23ef3fb955ccc0ff095a3528c132ade219f1c37e [^]
2010-01-20 13:03alostaleStatusresolved => closed
2010-01-20 23:26hudsonbotCheckin
2010-01-20 23:26hudsonbotNote Added: 0023679
2010-01-21 00:00anonymoussf_bug_id0 => 2935924

Notes
(0022297)
rafaroda   
2009-12-01 12:57   
I think that this is not an issue but the expected behaviour: have a look at http://wiki.openbravo.com/wiki/ERP/2.50/Developers_Guide/How_to_create_a_dataset#Examples [^]

Asier, any comment?
(0022301)
alostale   
2009-12-01 13:06   
Please note that this clause is not SQL but HQL
(0022324)
rafaroda   
2009-12-01 16:53   
Label should be changed to avoid confusions.
(0023112)
shuehner   
2009-12-28 14:28   
Note the definition of this field i planned to change to be sql for the core module datasets and hql for the rest... but not fully decided yet.
(0023577)
hgbot   
2010-01-19 19:00   
Repository: erp/devel/pi
Changeset: 23ef3fb955ccc0ff095a3528c132ade219f1c37e
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Tue Jan 19 18:59:55 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/23ef3fb955ccc0ff095a3528c132ade219f1c37e [^]

fixes issue 11569: The dataset's SQL Where Clause doesn't work properly

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
---
(0023679)
hudsonbot   
2010-01-20 23:26   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/23ef3fb955cc [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/fa6621f85351 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/obx/core/OpenbravoERP-2.50CI.15942.obx [^]