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

Attachments

2

Activity

Show:

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 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.

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 PM
Edited

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.

Fixed

Details

Assignee

Reporter

Components

Fix versions

Affects versions

Priority

Created June 18, 2013 at 9:05 PM
Updated May 2, 2014 at 9:57 PM
Resolved September 18, 2013 at 1:20 PM