• Resolved mglasser

    (@mglasser)


    Is it possible to grant SQL Reports to editors? It only seems available to those with admin rights and I have people who would benefit from the queries, but I only want them to have editor rights. I would prefer to not create a page with the results, due to the sensitive nature of the results.

    On a related note, is it possible to put these reports on the dashboard with the option of a link to the report or the results of the report. If I could put a link on the dashboard for Editors, then that would work. It returns thousands of records, so I do not just want it to run every time someone opens their dashboard.

    Thanks.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Eli

    (@scheeeli)

    Yes, you can add any report to the wp-admin dashboard and choose who can see it there.

    Thread Starter mglasser

    (@mglasser)

    Yes, I can see that I can add to dashboard, but it returns about 3,000 records, so I do not want that to run every time. I was hoping it would be available on the dashboard but only run on demand (when clicked). I just noticed that I can collapse the report on the dashboard, so that should be sufficient. I will just hope that it does not run the query if it is collapsed, since that would be an unnecessary performance hit.

    Thanks for the quick reply and the plugin.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Access for Editors?’ is closed to new replies.