Home > Forum > Rules, JS, SQL > Retrieving previous and comparing to new value

Retrieving previous and comparing to new value

0

Arthuzad

11.04.2025

15:52

Arthuzad

Hi, I'm having a dilemma about comparing two date objects. My thinking is when I do sql queries to retrieve data from objects it will give you already stored db results, but with webcon functions you actually get value before it is actually stored. It does not work this way, so i'm looking for a way to do it. In conclusion, it should compare date before change and after change (this is triggered on menu action SAVE).

11.04.2025

22:54

Hi,

you could check out this blog post:
https://daniels-notes.de/posts/2023/has-field-value-changed

I've no idea whether it's still working with the latest version.

Best regards,
Daniel

Solution (0)

Helpful (1)

Wrong answer (0)

Arthuzad

14.04.2025

14:32

Arthuzad

In reply to: Daniel Krüger (Cosmo Consult)

Hi,

you could check out this blog post:
https://daniels-notes.de/posts/2023/has-field-value-changed

I've no idea whether it's still working with the latest version.

Best regards,
Daniel

Unfortunately it's not working. I have a bit different example where I'm retrieving date from a data table so history db will be different(WfHistoryElementDetails) so I modified it. In the end, it did not work. Is only solution via sql ? Is there a solution more 'native' to webcon ?

Solution (0)

Helpful (0)

Wrong answer (0)

15.04.2025

07:11

In reply to: Arthuzad

Hi,

as you noticed, there's no build in function to access a previous value.
An alternative would be to store the current value in a technical field. You could do this on form load / using the behavior tab or with an action, after the check has been executed.

Best regards,
Daniel

Solution (0)

Helpful (1)

Wrong answer (0)