Anyone else having trouble when using the custom certificates plugin that the list showing all issued certificates stays empty, altough there are certificates issued?
Thanks for sharing which version of the plugin & Totara you are using 🙂
Totara Learn Open Discussions
Custom certificate plugin: overview of issued certificates is empty?
Custom certificate plugin: overview of issued certificates is empty?
Re: Custom certificate plugin: overview of issued certificates is empty?
Hi,
I see nobody has answered this issue. Please, do you have any updates on this?
We have the same problem - with not showing recipients. It seems to have something to do with tenants. When the course with a Custom certificate activity belongs to a tenant category and the tenant has a Domain manager or a User manager, it doesn't show anything. But if we remove these managers from the tenant, it displays the list of recipients.
We use 3.4.7 version of the Custom certificate plugin and Totara version 17.9.
Thanks for any ideas.
Eva
Re: Custom certificate plugin: overview of issued certificates is empty?
Hi Eva
This sounds as though the plugin is expecting the certificate permissions to be at a system level - the tenant managers have certificate permissions allowed at a tenant/category level.
Plugins apply to all tenants and required relevant roles at the system level
The suggestion is to create a system level role that only allows certificate permissions and assign this to the tenant user manager to see if this provides access
regards
Re: Custom certificate plugin: overview of issued certificates is empty?
Hi Craig,
Thank you for your reply. The problem is that site admins also don't see the list of issued certificates when there are tenant managers assigned to a tenant.
BR
Eva
Re: Custom certificate plugin: overview of issued certificates is empty?
Hi Eva
Unfortunately third party plugins designed for another LMS are not guaranteed to continue working in Totara without customising.
The custom certificate plugin is used by a few partners so they may be able to help on what needs modifying
regards
Re: Custom certificate plugin: overview of issued certificates is empty?
Hi all,
my reverse engineering lead to issue with native function $DB->get_in_or_equal()
list($sql, $params) = $DB->get_in_or_equal($certmanagers, SQL_PARAMS_NAMED, 'cert');
Input & Output from that line without assign role 'Tenant Domain Manager':
$certmanagers:
array(10) { [0]=> int(19) [1]=> int(2514) [2]=> int(1122) [3]=> int(58) [4]=> int(3) [5]=> int(18) [6]=> int(2) [7]=> int(3) [8]=> int(4) [9]=> int(1085) }
$sql:string(115) "IN (:uq_cert_1,:uq_cert_2,:uq_cert_3,:uq_cert_4,:uq_cert_5,:uq_cert_6,:uq_cert_7,:uq_cert_8,:uq_cert_9,
:uq_cert_10)"
$params:
array(10) { ["uq_cert_1"]=> int(19) ["uq_cert_2"]=> int(2514) ["uq_cert_3"]=> int(1122) ["uq_cert_4"]=> int(58) ["uq_cert_5"]=> int(3) ["uq_cert_6"]=> int(18) ["uq_cert_7"]=> int(2) ["uq_cert_8"]=> int(3) ["uq_cert_9"]=> int(4) ["uq_cert_10"]=> int(1085) }
And when we assign tenane role:
$certmanagers:
array(11) { [0]=> int(2541) [1]=> int(19) [2]=> int(2514) [3]=> int(1122) [4]=> int(58) [5]=> int(3) [6]=> int(18) [7]=> int(2) [8]=> int(3) [9]=> int(4) [10]=> int(1085) }
$sql:
string(63) "IN ('2541','19','2514','1122','58','3','18','2','3','4','1085')"
$params:
array(0) { }
Custom certificate plugin than in table view has condition that if $params is empty, do not show generate that table with issued certificates.