Control dashboard access by role

Description

https://groups.google.com/forum/?fromgroups#!topic/idempiere/JwkwYS9pw70

It should worth effort to add this feature to control dashboard access by role.

Environment

None

Activity

Show:
Hiep Lq
August 14, 2013, 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.

Carlos Ruiz
September 12, 2013, 9:37 PM
Edited
Nicolas Micoud
September 16, 2013, 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

Antonio CaƱaveral
September 16, 2013, 5:24 PM
Edited

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.

Carlos Ruiz
September 16, 2013, 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

Assignee

Heng Sin Low

Reporter

alex yang

Labels

None

Tested By

None

Components

Fix versions

Affects versions

Priority

Major
Configure