Dashboard Copy Manager

Administrators can copy dashboards from any user to any number of users, security groups, or roles. Save time logging in as individual users to set up their dashboards.

Free 30 day trial

Try it Now

#2714 - No Roles selectable

Closed Bug? created by Lion Solution Verified Purchase 4 years ago

Dear Jackal Software, i've just installed DashboardCopyManagerSuiteCRM_V_2_0_6 on a SuiteCRM v.7.10.24. I've created a Dashboard Template i clicked on the Deploy Template button i selected "Deploy to Role(s)"

i see no Roles even if i created 3 of them.

If i select Users or SecurityGroups i see a list of available records.

What's the query used by the "Deploy to Role(s)" feature?

PS: i've access to the db, so i can check directly

Jackal Software Provider Affiliate
4 years ago
Hello,

Here is the query to get Roles. Just one thing I can think to check is to make sure the roles have users linked:
```
ELECT ar.id, ar.name 
                    FROM acl_roles ar
                    WHERE ar.deleted = 0
                    AND ar.id IN (
                      SELECT aru.role_id FROM acl_roles_users aru 
                      WHERE aru.deleted = 0
                      )
```
reply
- Lion Solution Verified Purchase
  4 years ago
  
  Yes, you’re right: this is the point. These Roles are linked to SecurityGroups not with Users directly
  
  reply
- Jackal Software Provider Affiliate
  4 years ago
  
  Hello,
  
  You have a good point on this. Let me take a look at adding this either to the Roles or as another option to deployer to Group Roles. Thanks for finding this issue.
  
  reply
- Lion Solution Verified Purchase
  4 years ago
  
  Thanks a lot. May I ask you to send me an email when the upgrade will be downloadable?
  
  reply
- Jackal Software Provider Affiliate
  4 years ago
  
  Absolutely. I expect I'll have something early next week.
  
  Thanks again.
  
  reply
- Jackal Software Provider Affiliate
  4 years ago
  
  Hello,
  
  Thank you for your trial again and finding this issue. I just uploaded a new version DashboardCopyManagerSuiteCRM_V_2_10.zip that has the changes. I tested these out on my local environment and it was pulling in roles with only or a combination of users and groups assigned and deployed the dashboards properly.
  
  It should be available now under your purchases.
  
  Thank you very much.
  
  reply
- Lion Solution Verified Purchase
  4 years ago
  
  Thanks to you!
  
  reply

Jackal Software Provider Affiliate

4 years ago

Sorry,

SELECT ar.id, ar.name 
                    FROM acl_roles ar
                    WHERE ar.deleted = 0
                    AND ar.id IN (
                      SELECT aru.role_id FROM acl_roles_users aru 
                      WHERE aru.deleted = 0
                      )

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.

Saving Comment...

Dashboard Copy Manager

#2714 - No Roles selectable

"An excellent addition to the SuiteCRM solution and one that is necessary when rolling out CRM to many users."

Other add-ons of interest

Glances - Integrate SuiteCRM with all your apps

Organization Chart for SuiteCRM

Dashlet Roles