Control dashboard access by role
Description
Environment
Attachments
Activity
Carlos Ruiz September 16, 2013 at 11:25 PM
One test case failed:
Add one gadget and assign it just to GardenAdmin user
Clear the dashboard preference for GardenAdmin user
Logout and login
The dashboard preference is shown twice for GardenAdmin

Antonio Cañaveral September 16, 2013 at 5:24 PMEdited
MDashboardContent[] get issue:
The filter AD_Client_ID IN (0,?) Must also be in the first part of the query. Because I'm getting widgets from other customers. Specifically Calendar widget that is defined in Garden.
Something like this:
```
#!java
sql.append("SELECT PA_DashboardContent_ID,ColumnNo ")
.append(" FROM PA_DashboardContent ")
.append(" WHERE PA_DashboardContent_ID NOT IN (")
.append(" SELECT PA_DashboardContent_ID ")
.append(" FROM PA_DashboardContent_Access" )
.append(" WHERE IsActive='Y' )")
.append(" AND IsShowInLogin='Y'")
.append(" AND IsActive='Y'")
.append(" AND IsShowInDashboard=?");
if (AD_Client_ID > 0){
sql.append(" AND AD_Client_ID in (0,?)");
parameters.add(AD_Client_ID);
}
sql.append(" UNION ALL")
.append(" SELECT ct.PA_DashboardContent_ID,ct.ColumnNo")
.append(" FROM PA_DashboardContent ct")
.append(" INNER JOIN PA_DashboardContent_Access cta on (ct.PA_DashboardContent_ID = cta.PA_DashboardContent_ID)")
.append(" WHERE cta.IsActive='Y'")
.append(" AND ct.IsActive='Y'")
.append(" AND ct.IsShowInDashboard=?");
```
I would also like to submit for consideration the proposed improvement in ticket IDEMPIERE-1196.

Nicolas Micoud September 16, 2013 at 9:53 AM
Hi,
Just my 2 cents : perhaps the new PA_DashboardContent_Access table should be managed in the Role window ?
WDYT ?
Regards,
Nicolas
Carlos Ruiz September 12, 2013 at 9:37 PMEdited

Hiep Lq August 14, 2013 at 5:48 PM
what do you think about below request:
Tab home is fix position. when open more tab it not hide by scroll.
please attach for clear.
Details
Assignee
Heng Sin LowHeng Sin LowReporter
alex yangalex yangComponents
Fix versions
Affects versions
Priority
Major
Details
Details
Assignee

Reporter

https://groups.google.com/forum/?fromgroups#!topic/idempiere/JwkwYS9pw70
It should worth effort to add this feature to control dashboard access by role.