No matching records found

  • Resolved zatanx

    (@zatanx)


    1 year, 8 months ago

    I use SQL Query

    SELECT 
    p.emp_code, 
    p.first_name, 
    p.last_name, 
    DATE(t.punch_time) AS date,
    MIN(TIME(t.punch_time)) AS time_in, 
    MAX(TIME(t.punch_time)) AS time_out 
FROM wp_dbo_personnel_employee p 
JOIN wp_dbo_iclock_transaction t 
    ON p.emp_code = t.emp_code 
GROUP BY 
    p.emp_code, 
    p.first_name, 
    p.last_name, 
    DATE(t.punch_time)

    The problem is that it can’t be searched.

    ” No matching records found “

    • This topic was modified 1 year, 8 months ago by zatanx.
Viewing 1 replies (of 1 total)
  • Plugin Author wpDataTables

    (@wpdatatables)

    Hello, zatanx.

    Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

    We can see that you have the Premium Plugin version, since you are using SQL Queries.
    We are not allowed to discuss anything about any premium features/options on this Forum, it is just for Lite users;
    but our main support Team can help you with this issue.

    So if you can please open a ticket on our?main Support platform here?and one of our Agents will respond you as quickly as possible.

    Premium products are not supported in these forums, as per this comment by www.ads-software.com moderators.

    If you don’t have an active licence, you can open a ticket in the “Pre-Purchase” section, 

    or simply click on this link; that way, it will not ask you for the Premium code.

    Thank you for understanding.

Viewing 1 replies (of 1 total)
  • The topic ‘No matching records found’ is closed to new replies.

Tags