• Resolved cbeagrecia

    (@cbeagrecia)


    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

Viewing 1 replies (of 1 total)
  • Plugin Contributor Kim L

    (@kimmyx)

    Hi @cbeagrecia,

    Thanks for the post and sorry to hear you encountered issues.

    We might need to take a closer look at how your data table was set up.

    Could you send us a message at Contact | WP Data Access?

    We’ll wait for your message. 🙏

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.