Workflow is not updating record in DB !?

jupixy · 2024-11-14T19:42:05.766Z

Hi all,

wondering about this:
I’m trying to change an existing record in my database triggered by a backend workflow:

image1468×1512 207 KB

Here’s the backend workflow:

image1468×586 53.8 KB

Details:

image1468×732 69.1 KB

After the user clicks the button, no record in the database is updated.
I don’t know why. Didn’t receive any error messages.
I already tried to insert a NEW record in a test-table in my db and this works correctly (date and “eintragstext” is set correctly and is stored in the db). But the shown workflow currectly down’t update the affected record and I don’t know why.

I already tried my best to debug or look at the server logs, but I can’t find a bug or a solution.

Thanks a lot
jupxi

fede.bubble · 2024-11-14T22:34:59.983Z

hey
if you can’t find someone to help in the forum, I would recommend you connect with the support team. They can help you troubleshoot your app and find what’s wrong

jamie.robson.89 · 2024-11-14T23:09:15.482Z

Privacy rules?

jupixy · 2024-11-15T16:45:26.191Z

Hi all,
I found the issue:

My datetime values in the db are stored in the format: “12/12/24 12:00 pm”
My rule compares the 2 date values but expects “12:00 am” - not “pm”

So I could solve it by using (date + 12 hrs.):

image1468×732 75.3 KB

Thanks for your great input, community!

Best
jupxi

system · 2025-01-23T19:42:19.540Z

This topic was automatically closed after 70 days. New replies are no longer allowed.