Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018407Openbravo ERP01. General setuppublic2011-09-01 10:542012-04-02 06:11
Reporterjonalegriaesarte 
Assigned Tojecharri 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version3.0MP2 
Target Version3.0MP5Fixed in Version3.0MP5 
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
Summary0018407: Campaign tree does not work
DescriptionIf you try to activate the campaign tree, it does not work correctly
Steps To Reproduce- Activate tree option in campaign tab
- Tree structure does not work
Proposed SolutionTreetype in ad_tree table is created after create and entity (ad_tree.treetype = 'MC')
Things missing:
- Trigger in c_campaign to add nodes to ad_treenode (treetype='MC'), similar to org, product, ....
- Add issummary column to campaign table.
- Change src/org/openbravo/erpCommon/utility/WindowTree_data.xsql, to obtain issummary column instead of 'N' in selectCampaign.

Issummary column can be added and WindowTree_data.xsql changed inmediatly, because are the biggest problem to people that want to implement it.
Additional Information
TagsNo tags attached.
Relationships
depends on backport 00189532.50MP36 closed jecharri Campaign tree does not work 
related to defect 0019697 closed vmromanos It is not possible to create a Campaign, see error attached. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-09-01 10:54jonalegriaesarteNew Issue
2011-09-01 10:54jonalegriaesarteAssigned To => jecharri
2011-09-01 10:54jonalegriaesarteModules => Core
2011-09-01 13:50jonalegriaesarteAssigned Tojecharri => jonalegriaesarte
2011-10-04 10:32jonalegriaesarteNote Added: 0041478
2011-10-04 10:32jonalegriaesarteTarget Version3.0MP4 => 3.0MP5
2011-10-17 10:23jonalegriaesarteSeveritymajor => minor
2011-10-17 13:23egoitzPriorityurgent => high
2011-10-31 17:42hgbotCheckin
2011-10-31 17:42hgbotNote Added: 0042424
2011-10-31 17:42hgbotStatusnew => resolved
2011-10-31 17:42hgbotResolutionopen => fixed
2011-10-31 17:42hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/86cbd2ddf9655cf7a813f9c9cb9b6c35b9ac54f7 [^]
2011-11-02 09:57hgbotCheckin
2011-11-02 09:57hgbotNote Added: 0042432
2011-11-02 12:25jecharriStatusresolved => new
2011-11-02 12:25jecharriResolutionfixed => open
2011-11-02 12:25jecharriStatusnew => scheduled
2011-11-02 12:25jecharriAssigned Tojonalegriaesarte => jecharri
2011-11-02 12:25jecharrifix_in_branch => pi
2011-11-02 12:26jecharriStatusscheduled => resolved
2011-11-02 12:26jecharriResolutionopen => fixed
2011-11-02 16:53hgbotCheckin
2011-11-02 16:53hgbotNote Added: 0042454
2011-11-04 13:58hudsonbotCheckin
2011-11-04 13:58hudsonbotNote Added: 0042615
2011-11-04 13:58hudsonbotCheckin
2011-11-04 13:58hudsonbotNote Added: 0042617
2011-11-04 13:58hudsonbotCheckin
2011-11-04 13:58hudsonbotNote Added: 0042620
2011-11-07 18:41jonalegriaesarteNote Added: 0042666
2011-11-07 18:41jonalegriaesarteStatusresolved => closed
2011-11-07 18:41jonalegriaesarteFixed in Version => 3.0MP5
2012-03-20 18:30vmromanosRelationship addedrelated to 0019697
2012-03-21 10:30hgbotCheckin
2012-03-21 10:30hgbotNote Added: 0046578
2012-03-21 11:41hgbotCheckin
2012-03-21 11:41hgbotNote Added: 0046583
2012-04-01 20:34hgbotCheckin
2012-04-01 20:34hgbotNote Added: 0047015
2012-04-01 20:34hgbotCheckin
2012-04-01 20:34hgbotNote Added: 0047018
2012-04-02 06:11hudsonbotCheckin
2012-04-02 06:11hudsonbotNote Added: 0047180
2012-04-02 06:11hudsonbotCheckin
2012-04-02 06:11hudsonbotNote Added: 0047183

Notes
(0041478)
jonalegriaesarte   
2011-10-04 10:32   
Due to other priorities it will be solved in the next MP
(0042424)
hgbot   
2011-10-31 17:42   
Repository: erp/devel/pi
Changeset: 86cbd2ddf9655cf7a813f9c9cb9b6c35b9ac54f7
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Mon Oct 31 17:08:59 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/86cbd2ddf9655cf7a813f9c9cb9b6c35b9ac54f7 [^]

Fixes issue 18407: Campaign tree does not work

---
M src-db/database/model/tables/AD_CLIENTINFO.xml
M src-db/database/model/tables/C_CAMPAIGN.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_TAB.xml
M src/org/openbravo/erpCommon/businessUtility/InitialClientSetup.java
M src/org/openbravo/erpCommon/businessUtility/InitialSetupUtility.java
M src/org/openbravo/erpCommon/utility/WindowTree_data.xsql
A src-db/database/model/triggers/C_CAMPAIGN_TRG.xml
---
(0042432)
hgbot   
2011-11-02 09:57   
Repository: erp/devel/pi
Changeset: 24d39bcffbb095b5725649e24fded3a5203ab33d
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Wed Nov 02 09:55:34 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/24d39bcffbb095b5725649e24fded3a5203ab33d [^]

issue 18407: Campaign tree does not work

---
M src-db/database/model/tables/C_CAMPAIGN.xml
M src-db/database/model/triggers/C_CAMPAIGN_TRG.xml
M src/org/openbravo/erpCommon/businessUtility/InitialSetupUtility.java
---
(0042454)
hgbot   
2011-11-02 16:53   
Repository: erp/devel/pi
Changeset: 01601b9a584684ce3bc512bb2219ebd7b3838905
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Wed Nov 02 16:53:06 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/01601b9a584684ce3bc512bb2219ebd7b3838905 [^]

issue 18407: Campaign tree does not work

---
M src-db/database/model/triggers/C_CAMPAIGN_TRG.xml
---
(0042615)
hudsonbot   
2011-11-04 13:58   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/d10da320df2a [^]

Maturity status: Test
(0042617)
hudsonbot   
2011-11-04 13:58   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/d10da320df2a [^]

Maturity status: Test
(0042620)
hudsonbot   
2011-11-04 13:58   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/d10da320df2a [^]

Maturity status: Test
(0042666)
jonalegriaesarte   
2011-11-07 18:41   
Verified
(0046578)
hgbot   
2012-03-21 10:30   
Repository: erp/devel/pi
Changeset: 57131b13c97a77f1edc8a9d1e038b995fadcb8a2
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Wed Mar 21 10:29:38 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/57131b13c97a77f1edc8a9d1e038b995fadcb8a2 [^]

Fixes issue 19697: It is not possible to create a Campaign, see error attached.
Also complete the issue 18407

---
A src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateADClientInfo.class
A src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateADClientInfoData.class
A src-util/modulescript/src/org/openbravo/modulescript/UpdateADClientInfo.java
A src-util/modulescript/src/org/openbravo/modulescript/UpdateADClientInfo_data.xsql
---
(0046583)
hgbot   
2012-03-21 11:41   
Repository: erp/devel/pi
Changeset: 240bae48f88cfe1e21262242df7034cb9f03a964
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Wed Mar 21 11:40:03 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/240bae48f88cfe1e21262242df7034cb9f03a964 [^]

issue 19697, issue 18407.
Changed the method selectClientsID to have better performance and only update the neccesary clients

---
M src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateADClientInfoData.class
M src-util/modulescript/src/org/openbravo/modulescript/UpdateADClientInfo_data.xsql
---
(0047015)
hgbot   
2012-04-01 20:34   
Repository: erp/devel/pi
Changeset: e0d914c1efd1635ff518ce027e4072e24b968df6
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Wed Mar 21 10:29:38 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/e0d914c1efd1635ff518ce027e4072e24b968df6 [^]

Fixes issue 19697: It is not possible to create a Campaign, see error attached.
Also complete the issue 18407

---
A src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateADClientInfo.class
A src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateADClientInfoData.class
A src-util/modulescript/src/org/openbravo/modulescript/UpdateADClientInfo.java
A src-util/modulescript/src/org/openbravo/modulescript/UpdateADClientInfo_data.xsql
---
(0047018)
hgbot   
2012-04-01 20:34   
Repository: erp/devel/pi
Changeset: f5fe379ed93a6096bac2caa837ce4bee45a63597
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Wed Mar 21 11:40:03 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/f5fe379ed93a6096bac2caa837ce4bee45a63597 [^]

issue 19697, issue 18407.
Changed the method selectClientsID to have better performance and only update the neccesary clients

---
M src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateADClientInfoData.class
M src-util/modulescript/src/org/openbravo/modulescript/UpdateADClientInfo_data.xsql
---
(0047180)
hudsonbot   
2012-04-02 06:11   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/7814864461ac [^]

Maturity status: Test
(0047183)
hudsonbot   
2012-04-02 06:11   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/7814864461ac [^]

Maturity status: Test