Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0000425Openbravo ERPY. DBSourceManagerpublic2008-05-26 10:002009-03-18 11:02
marvintm 
marvintm 
normalminoralways
closedfixed 
5
 
 
Core
No
0000425: AD_USER and AD_USER_ROLES should be filtered by AD_USER_ID instead of by AD_CLIENT_ID
Now, to decide if a row of AD_USER or AD_USER_ROLES is sourcedata or sampledata, AD_CLIENT_ID is used.

The best solution should be to user AD_USER_ID instead of AD_CLIENT_ID.
Just do an ant export.database
This lines in OpenbravoMetadataFilter.java

addTable("AD_USER", "AD_CLIENT_ID = 0");
addTable("AD_USER_ROLES", "AD_CLIENT_ID = 0");

should be replaced by:

addTable("AD_USER", "AD_USER_ID IN (0,100)");
addTable("AD_USER_ROLES", "AD_USER_ID IN (0,100)");

and similar ones in OpenbravoDataFilter.java should also be replaced.
dbsm_migrate
Issue History
2008-05-26 10:00marvintmNew Issue
2008-05-26 10:00marvintmAssigned To => marvintm
2008-05-26 10:01marvintmStatusnew => scheduled
2008-05-26 10:50marvintmStatusscheduled => resolved
2008-05-26 10:50marvintmResolutionopen => fixed
2008-05-26 10:50marvintmNote Added: 0000329
2008-11-26 14:08psarobeStatusresolved => closed
2008-12-18 12:38jpabloaeSticky IssueNo => Yes
2008-12-18 12:39jpabloaeSticky IssueYes => No
2008-12-18 12:39jpabloaeTag Attached: dbsm_migrate
2008-12-18 12:41jpabloaeProject@4@ => Openbravo ERP
2008-12-18 12:41jpabloaeCategory => Y. DBSourceManager
2009-03-18 11:02anonymoussf_bug_id0 => 2691314

Notes
(0000329)
marvintm   
2008-05-26 10:50   
AD_USER is now filtered by AD_USER_ID. AD_USER_ROLES will continue to be filtered by AD_CLIENT_ID, because otherwise we would change current sourcedata.