by Jackal Software

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 10 months 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

  1. shad member avatar

    Jackal Software Provider Affiliate

    10 months 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
                          )
    
    • MayerElyashiv member avatar

      Lion Solution Verified Purchase

      10 months ago

      Yes, you’re right: this is the point.
      These Roles are linked to SecurityGroups not with Users directly

    • shad member avatar

      Jackal Software Provider Affiliate

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

    • MayerElyashiv member avatar

      Lion Solution Verified Purchase

      10 months ago

      Thanks a lot.
      May I ask you to send me an email when the upgrade will be downloadable?

    • shad member avatar

      Jackal Software Provider Affiliate

      10 months ago

      Absolutely. I expect I'll have something early next week.

      Thanks again.

    • shad member avatar

      Jackal Software Provider Affiliate

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

    • MayerElyashiv member avatar

      Lion Solution Verified Purchase

      10 months ago

      Thanks to you!

  2. shad member avatar

    Jackal Software Provider Affiliate

    10 months 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 Saving Comment...
Rating
  • "An excellent addition to the SuiteCRM solution and one that is necessary when rolling out CRM to many users."

    Read More Reviews