Using "life" field content in SQL queries (V2025)

0

Hi,
Do you have an error?
You can use unsaved data, but it must be in quotes '{Field}', and you don't have the first attribute - maybe that's causing the error?

Hi Krystian,

thank you for the answer.
In case it is an integer value it should work without quotes, right?
What do you mean with "you don't have the first attribute"?

Here two pictures that show it a bit better:
pic 1: the item has been saved, the values are visible in the query editor
pic 2: there are values in the field, but the instance has not been saved since; the field is empty in the query

Kind regards,
Klaus

Okay, now I understand what you're asking :)
The second version from the designer studio will not show you the information because you don't have the data saved that you have in the first screenshot.

You have to assume that the action you are performing dynamically retrieves this data during the execution of the action, so it will work well for you on the form - the designer will not substitute the data you expect, but the action will retrieve the data during execution - test it :)

Okay, but in the old version it was possible to see it in the designer. Was very helpful for bugfixing.

Thanks!
Klaus