Hola Juan, ¿sabes si es posible instalar el bloque desde un administrado solo para admin y gestores en una tema sin bloques?

Hola Juan, ¿sabes si es posible instalar el bloque desde un administrado solo para admin y gestores en una tema sin bloques?

Good afternoon, can someone help me? I have a custom statement, but when I add it, the sql statement doesn't work, the error that appears is: No explicit prefix, the sql is:
SELECT
u.id AS 'Identificación',
CONCAT(u.firstname, ' ', u.lastname) AS 'Nombre',
c.fullname AS 'Nombre del Curso',
g.name AS 'Grupo',
ROUND( (SUM( CASE WHEN cmc.completionstate = 1 THEN 1 ELSE 0 END ) / COUNT(cm.id)) * 100, 2 ) AS 'Progreso (%)',
SUM( CASE WHEN cmc.completionstate = 1 THEN 1 ELSE 0 END ) AS 'Actividades Completadas',
(SELECT COUNT(*)
FROM mdl_course_modules
WHERE course = c.id
AND completion > 0) AS 'Actividades del Curso',
docdata.data AS 'Tipo de Documento',
numdocdata.data AS 'Número de Documento',
caractdata.data AS 'Caracterización'
FROM mdl_user u
LEFT JOIN mdl_user_enrolments ue ON ue.userid = u.id
LEFT JOIN mdl_enrol e ON e.id = ue.enrolid
LEFT JOIN mdl_course c ON c.id = e.courseid
LEFT JOIN mdl_groups_members gm ON gm.userid = u.id
LEFT JOIN mdl_groups g ON g.id = gm.groupid
LEFT JOIN mdl_course_modules_completion cmc ON cmc.userid = u.id
LEFT JOIN mdl_course_modules cm ON cm.id = cmc.coursemoduleid AND cm.course = c.id
LEFT JOIN mdl_user_info_data docdata ON docdata.userid = u.id AND docdata.fieldid = 5 -- Ajustar con el ID correcto de "Tipo de Documento"
LEFT JOIN mdl_user_info_data numdocdata ON numdocdata.userid = u.id AND numdocdata.fieldid = 4 -- Ajustar con el ID correcto de "Número de Documento"
LEFT JOIN mdl_user_info_data caractdata ON caractdata.userid = u.id AND caractdata.fieldid = 6 -- Ajustar con el ID correcto de "Caracterización"
WHERE c.visible = 1
GROUP BY u.id, c.id, g.id, docdata.data, numdocdata.data, caractdata.data
ORDER BY u.lastname, u.firstname;

Jesus, your tables start with mdl_. I believe that Configurable Reports want you to specifically use prefix_, not mdl_.

Give this simple query a try and see if it works.

select *
from prefix_user

Will there be a version that is compatible with Moodle 4.3 and when would that be released?

¡¡Juan, se te agradece muchísimo por las actualización a 4.5!!

Quiero también agradecer a Juan por la actualización.

Thanks for the update, Juan. So glad the export issue was resolved (amongst all the others reported issues).

I opened an issue on Github. Now I see that the Moodle Tracker is the "official" bug tracker. What should I do? Copy the issue to the tracker?

I'm really struggling to get my reports to show up to 100 rows by default. I've posted an issue here: https://github.com/Lesterhuis-Training-en-Consultancy/moodle-block_configurable_reports/issues/8. Not sure if this is a feature request or a bug. Any help would be awesome!

Hi all, just a heads up - I used Grok to generate some SQL statements and it was spot on! Don't spend hours writing your own.

Great plugin, used in so many institutions all over the world. Although Moodle now has custom reports module, this plugin is so much better because we can write our own queries.

I hope some day it will solve two major issues in reports with large amount of data:
- for reports with filters, it should load results after clicking the Apply button and not before.
- default search field should also work with paging enabled. That means replacing Javascript search with Ajax or something.

One more suggestion for developers... regarding SQL reports, filtering syntax is really too limiting and complicated without real reason. Could you just use filter values as variables instead? That would make life so much easier for anyone that codes custom SQL queries for this report. This would also remove so much limitations of the current plugin and it would make plugin's PHP code so much cleaner, smaller and simple.

Absolutely Zoran. To load results after applying filters or parameters is what is missing in this plugin. It would be perfect with it.

Question: why statement
%%FILTER_SEARCHTEXT_lastname:uu.lastname:~%%
works, but case insensitive does not ?
%%FILTER_SEARCHTEXT_lastname:uu.lastname:~*%%
it is error or by design ?

Hi Team,
We are using Moodle version 4.5.4+ (Build: 20250502) with plugin version 2024051300, and we’ve noticed that the plugin uses the deprecated function get_all_user_name_fields() in multiple places.
As of recent Moodle versions, it seems this function has been deprecated and removed from core. It should be replaced maybe with: \core_user\fields::get_name_fields().
Regards