Hey everyone!

With the holiday season upon us, we want to share our upcoming working hours:

After that, we’ll return to our regular schedule and assist you as quickly as possible.

In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find tons of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel), which might just have the answers you need while we’re away.

Thanks a bunch for your understanding and support!

Warm regards and happy holidays!

TMS

Okay
  Public Ticket #1508007
TIMEDIFF
Closed

Comments

  •  1
    offik started the conversation
    March 18, 2018 at 1:04am

    Hi,

    i have problem with my mysql query.

    in my database i have "start" and "end" column and i need to count difference...
    Here is my query created in Sequel Pro - where everything works (see attached screens):

    SELECT 
           TIMEDIFF (time_entries.end, time_entries.start), 
           time_entries.id,
           time_entries.project_id,
           time_entries.user_id,
           time_entries.start,
           time_entries.end,
           time_entries.description,
           projects.id,
           projects.title,
           users.id,
           users.username,
           users.full_name
    FROM projects
      INNER JOIN time_entries
         ON projects.id = time_entries.project_id
      INNER JOIN users
         ON time_entries.user_id = users.id


    But when i use this i have non-sense data filled there - 12:00 in all fields ( i tried to play with data format but it doesnt help...

    any suggestions pls?

    thank you in advance!

  •  472
    Isidora replied
    March 19, 2018 at 10:32am

    Hi offik,
    Thank you for your purchase.

    Sorry for late response. 

    We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.

    If your MySQL-query based wpDataTable doesn’t work correctly with server-side processing, probably this is happening because wpDataTables server has problems with parsing of the query and building new queries dynamically (happens rarely, but does sometimes). To avoid this please prepare a MySQL view (a stored query), which will return the data that you need, call it e.g. “view1” and then build a wpDataTabled based on a simple query like “SELECT * FROM view1″.


    Kind Regards, 

    Isidora Markovic

    wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter |  Amelia demo sites | Docs

    You can try our wpDataTables add-ons before purchase on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables

  •  1
    offik replied
    March 20, 2018 at 12:57pm

    Hello Milan,

    Thank you for your support.

    It works properly now.

    Miloš 

  •  472
    Isidora replied
    March 20, 2018 at 1:09pm

    HI Miloš,

    You are welcome.  

    If you have any more issues or questions feel free to open a new ticket, we will gladly help.

    We'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. Thanks! 

    Kind Regards, 

    Isidora Markovic

    wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter |  Amelia demo sites | Docs

    You can try our wpDataTables add-ons before purchase on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables