Totara Learn Open Discussions

Custom certificate plugin: overview of issued certificates is empty?

 
Laura Swennen
Custom certificate plugin: overview of issued certificates is empty?
par Laura Swennen, Wednesday 21 June 2023, 04:42
Groupe TXP Site Administrator

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 🙂

Eva Strbakova
Re: Custom certificate plugin: overview of issued certificates is empty?
par Eva Strbakova, Tuesday 21 May 2024, 06:08
Groupe 2022 Learner of the Year (Bronze)Groupe PartnersGroupe TXP Site AdministratorGroupe V18 Program Complete

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

Craig Eves
Re: Custom certificate plugin: overview of issued certificates is empty?
par Craig Eves (Totara Support), Tuesday 21 May 2024, 15:53
Groupe Totara

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

Eva Strbakova
Re: Custom certificate plugin: overview of issued certificates is empty?
par Eva Strbakova, Tuesday 21 May 2024, 23:15
Groupe 2022 Learner of the Year (Bronze)Groupe PartnersGroupe TXP Site AdministratorGroupe V18 Program Complete

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

Craig Eves
Re: Custom certificate plugin: overview of issued certificates is empty?
par Craig Eves (Totara Support), Wednesday 22 May 2024, 13:48
Groupe Totara

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

Marek Hanacek
Re: Custom certificate plugin: overview of issued certificates is empty?
par Marek Hanacek, Wednesday 22 May 2024, 23:33
Groupe Partners

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.