Wappler Version : 5.3.1 Operating System : mac Server Model: node Database Type: mysql Hosting Type: docker Expected behavior When setting Timezone Handling to UTC, datetime values should be always returned in the ISO 8601 notation. Actual behavior If a datetime column is queried as part of a …

Ouch. Trying to debug that would be painful

There is a similar problem if use a database paged query

Could you test with this update: dbconnector.zip (3.4 KB)

Thanks Patrick, but no luck. Driver dependent mode: [Screenshot 2023-01-16 at 7.38.39 AM] UTC: [Screenshot 2023-01-16 at 7.38.19 AM]

For the conversion I depend on the metadata that Wappler adds to the action, can you share the json of the action step. I’ve updated some code that will try to detect dates in the output when no metadata is available. app.zip (5.3 KB) Unzip to lib/core.

Thanks Patrick. Here is the response when using the revised app.zip {"status":"500","message":"obj is not defined","stack":"ReferenceError: obj is not defined\n at formatRecord (/opt/node_app/lib/core/app.js:352:60)\n at Object.options.postProcessResponse (/opt/node_app/lib/core/app.js:392:2…

Seems I forgot to change a parameter there, did copy/paste part of the code from an other location. Have it fixed here: app.zip (5.3 KB) Seeing your json it seems that the metadata is not complete, we will look into that issue. Let me know if the updated file above solves your problem, it will try …

Thanks, that takes care of it! Not sure this is relevant, as I have not run into this (yet), but wouldn’t your fix also help nested data from a custom query?

It should fix date formatting in all database queries.

The update didn’t make it in yesterdays Wappler update. We are still checking the issue with the metadata. Does the data picker allow you to pick all the data from the server action? Perhaps you can open the server action in Wappler and save it again to see if it then updates the metadata. If it d…

Wappler Community

UTC Timezone handling does not apply to subtables

Wappler General Bugs

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled