Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015554Openbravo ERPA. Platformpublic2010-12-30 18:502011-01-10 18:41
Reportergorkaion 
Assigned Toalostale 
PrioritynormalSeverityminorReproducibilityN/A
StatusclosedResolutionfixed 
PlatformOS20OS VersionGentoo
Product Version 
Target Version3.0RC4Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesMy Openbravo Tab
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0015554: Automate access to widgets on roles with manual flag set to false
DescriptionWidget access to roles is based on the "Enable to all users" flag and the "Widget Access".

The "Widget Access" tab should work as any other "*_Access" table of Openbravo. This is:

*A new Role with the isManual flag disabled should have access to all widgets.
*A new Widget Class should be accessible by all roles with the isManual flag disabled.
*After an update.database, if a new widget class is created not manual roles should have access to it.
Steps To Reproduce
Proposed SolutionIt is needed to build:

* A trigger on the Widget Class table.
* A trigger on the AD_Role table (or add an extension point to the existing one)
* A extension point on the AD_Update_Access procedure and a procedure to insert the access.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-12-30 18:50gorkaionNew Issue
2010-12-30 18:50gorkaionAssigned To => alostale
2010-12-30 18:50gorkaionModules => My Openbravo Tab
2011-01-04 08:53alostaleStatusnew => scheduled
2011-01-07 12:01hgbotCheckin
2011-01-07 12:01hgbotNote Added: 0033537
2011-01-07 12:02hgbotCheckin
2011-01-07 12:02hgbotNote Added: 0033538
2011-01-07 12:02hgbotCheckin
2011-01-07 12:02hgbotNote Added: 0033539
2011-01-07 12:02hgbotCheckin
2011-01-07 12:02hgbotNote Added: 0033540
2011-01-07 12:02hgbotCheckin
2011-01-07 12:02hgbotNote Added: 0033541
2011-01-07 12:02hgbotCheckin
2011-01-07 12:02hgbotNote Added: 0033542
2011-01-07 12:02hgbotStatusscheduled => resolved
2011-01-07 12:02hgbotResolutionopen => fixed
2011-01-07 12:02hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/3bec808908d299fc1f6c603a063cc1d40173456d [^]
2011-01-07 13:54hgbotCheckin
2011-01-07 13:54hgbotNote Added: 0033543
2011-01-07 13:54hgbotCheckin
2011-01-07 13:54hgbotNote Added: 0033544
2011-01-07 13:54hgbotCheckin
2011-01-07 13:54hgbotNote Added: 0033545
2011-01-07 14:01gorkaionStatusresolved => closed
2011-01-08 00:00anonymoussf_bug_id0 => 3153136
2011-01-10 18:41hudsonbotCheckin
2011-01-10 18:41hudsonbotNote Added: 0033570
2011-01-10 18:41hudsonbotCheckin
2011-01-10 18:41hudsonbotNote Added: 0033571
2011-01-10 18:41hudsonbotCheckin
2011-01-10 18:41hudsonbotNote Added: 0033572
2011-01-10 18:41hudsonbotCheckin
2011-01-10 18:41hudsonbotNote Added: 0033573
2011-01-10 18:41hudsonbotCheckin
2011-01-10 18:41hudsonbotNote Added: 0033574
2011-01-10 18:41hudsonbotCheckin
2011-01-10 18:41hudsonbotNote Added: 0033575
2011-01-10 18:41hudsonbotCheckin
2011-01-10 18:41hudsonbotNote Added: 0033576
2011-01-10 18:41hudsonbotCheckin
2011-01-10 18:41hudsonbotNote Added: 0033577
2011-01-10 18:41hudsonbotCheckin
2011-01-10 18:41hudsonbotNote Added: 0033578

Notes
(0033537)
hgbot   
2011-01-07 12:01   
Repository: erp/devel/pi
Changeset: 7724414d838edfa61d6ea6694df64ce0585e894a
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Fri Jan 07 11:53:42 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/7724414d838edfa61d6ea6694df64ce0585e894a [^]

related to issue 15554: Added extension point to ad_update_access

---
M src-db/database/model/functions/AD_UPDATE_ACCESS.xml
M src-db/database/sourcedata/AD_EXTENSION_POINTS.xml
---
(0033538)
hgbot   
2011-01-07 12:02   
Repository: erp/devel/pi
Changeset: e4cabea0de4c94f8af61c6ab305911c66d80f23b
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Fri Jan 07 11:55:57 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/e4cabea0de4c94f8af61c6ab305911c66d80f23b [^]

related to issue 15554: Added access level to obkmo_wiget_class

---
M modules/org.openbravo.client.myob/src-db/database/sourcedata/AD_COLUMN.xml
M modules/org.openbravo.client.myob/src-db/database/sourcedata/AD_FIELD.xml
---
(0033539)
hgbot   
2011-01-07 12:02   
Repository: erp/devel/pi
Changeset: d41e6878430cc139a1e986e10d3fe9c2b8390e86
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Fri Jan 07 11:57:09 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/d41e6878430cc139a1e986e10d3fe9c2b8390e86 [^]

related to issue 15554: Set default obkmo_widget_class.accesslevel

---
M modules/org.openbravo.client.myob/src-db/database/sourcedata/OBKMO_WIDGET_CLASS.xml
---
(0033540)
hgbot   
2011-01-07 12:02   
Repository: erp/devel/pi
Changeset: 0631f2f2e80b764e8b2d1e136817ee384d53d525
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Fri Jan 07 11:57:39 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/0631f2f2e80b764e8b2d1e136817ee384d53d525 [^]

related to issue 15554: Set default obkmo_widget_class.accesslevel

---
M modules/org.openbravo.client.htmlwidget/src-db/database/sourcedata/OBKMO_WIDGET_CLASS.xml
---
(0033541)
hgbot   
2011-01-07 12:02   
Repository: erp/devel/pi
Changeset: 8b6ee1577c93d725c7571b19c3881012d4d24c6f
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Fri Jan 07 11:57:57 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/8b6ee1577c93d725c7571b19c3881012d4d24c6f [^]

related to issue 15554: Set default obkmo_widget_class.accesslevel

---
M modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBKMO_WIDGET_CLASS.xml
---
(0033542)
hgbot   
2011-01-07 12:02   
Repository: erp/devel/pi
Changeset: 3bec808908d299fc1f6c603a063cc1d40173456d
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Fri Jan 07 12:00:49 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/3bec808908d299fc1f6c603a063cc1d40173456d [^]

fixed issue 15554: Automate access to widgets on non manual roles
  -Trigger in AD_Role table
  -Trigger in OBKMO_Widget_Class
  -Extension point for AD_Update_Access

---
M modules/org.openbravo.client.myob/src-db/database/model/tables/OBKMO_WIDGET_CLASS.xml
M modules/org.openbravo.client.myob/src-db/database/model/triggers/OBKMO_WIDGET_CLASS_TRG.xml
M modules/org.openbravo.client.myob/src-db/database/sourcedata/AD_EP_PROCEDURES.xml
A modules/org.openbravo.client.myob/src-db/database/model/functions/OBKMO_UPDATE_ACCESS.xml
A modules/org.openbravo.client.myob/src-db/database/model/triggers/OBKMO_AD_ROLE_TRG.xml
---
(0033543)
hgbot   
2011-01-07 13:54   
Repository: erp/devel/pi
Changeset: 6889687b84758650be7aa8f86bb363e0e7000090
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Fri Jan 07 13:49:00 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/6889687b84758650be7aa8f86bb363e0e7000090 [^]

[OBKMO] Related to issue 15554.Set proper access level and enable to all user flag.Removed show parameters widget.

---
M modules/org.openbravo.client.myob/src-db/database/sourcedata/OBKMO_WIDGET_CLASS.xml
R modules/org.openbravo.client.myob/src-db/database/sourcedata/OBKMO_WIDGET_CLASS_MENU.xml
R modules/org.openbravo.client.myob/src-db/database/sourcedata/OBUIAPP_PARAMETER.xml
---
(0033544)
hgbot   
2011-01-07 13:54   
Repository: erp/devel/pi
Changeset: 5c14ae8f1c926481d20d868bbf91eae935ea6d28
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Fri Jan 07 13:50:30 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/5c14ae8f1c926481d20d868bbf91eae935ea6d28 [^]

[OBCQL]Related to issue 15554.Set proper access level and enable to all users flag.

---
M modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBKMO_WIDGET_CLASS.xml
---
(0033545)
hgbot   
2011-01-07 13:54   
Repository: erp/devel/pi
Changeset: 449cb773894b9971d11c81cf9921d896ad558440
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Fri Jan 07 13:51:00 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/449cb773894b9971d11c81cf9921d896ad558440 [^]

[OBCHW] Related to issue 15554.Set proper access level.

---
M modules/org.openbravo.client.htmlwidget/src-db/database/sourcedata/OBKMO_WIDGET_CLASS.xml
---
(0033570)
hudsonbot   
2011-01-10 18:41   
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/7724414d838e [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/67254b289f54 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.19679.obx [^]
(0033571)
hudsonbot   
2011-01-10 18:41   
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/e4cabea0de4c [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/67254b289f54 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.19679.obx [^]
(0033572)
hudsonbot   
2011-01-10 18:41   
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/d41e6878430c [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/67254b289f54 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.19679.obx [^]
(0033573)
hudsonbot   
2011-01-10 18:41   
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/0631f2f2e80b [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/67254b289f54 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.19679.obx [^]
(0033574)
hudsonbot   
2011-01-10 18:41   
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/8b6ee1577c93 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/67254b289f54 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.19679.obx [^]
(0033575)
hudsonbot   
2011-01-10 18:41   
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/3bec808908d2 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/67254b289f54 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.19679.obx [^]
(0033576)
hudsonbot   
2011-01-10 18:41   
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/6889687b8475 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/67254b289f54 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.19679.obx [^]
(0033577)
hudsonbot   
2011-01-10 18:41   
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/5c14ae8f1c92 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/67254b289f54 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.19679.obx [^]
(0033578)
hudsonbot   
2011-01-10 18:41   
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/449cb773894b [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/67254b289f54 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.19679.obx [^]