SearchBuilder require datetime when used dates
-
Hello, I use WPDataAccess Premium 5.4.0 and Code Manager Premium 1.0.32.
I created a Reporter but in Chrome, Win11, appears this message: “SearchBuilder require datetime when used dates”.
In my MySQL Query had:
SELECT DISTINCT um7.meta_value as NC, concat(firstmeta.meta_value, ‘ ‘, lastmeta.meta_value) as Nombre, um4.meta_value Departamento, um5.meta_value Puesto, u.user_email as Correo, ROUND(IFNULL(MAX(am.activity_meta_value), ‘0’), 0) as Calificación, (
CASE
WHEN MAX(am.activity_meta_value) >= 1 AND MAX(am.activity_meta_value) <= 79 THEN ‘Estudiando’ WHEN MAX(am.activity_meta_value) >= 80 THEN ‘Aprobado’
WHEN ISNULL(MAX(am.activity_meta_value)) THEN ‘Sin Estudiar’
END) AS Estado, DATE_SUB(FROM_UNIXTIME(MAX(a.activity_completed)), INTERVAL 6 HOUR) as “Curso Completado”, u.user_login as Usuario, um3.meta_Value as Clave, p.post_title as Curso, pex.post_title as Examen
- The topic ‘SearchBuilder require datetime when used dates’ is closed to new replies.