Update records

This is missing all the relevant details. I try to decode ...

You have a CDT and a Data Store. A record points to this table. In a process you store data in it. Values for a field or chosen from a constant. Now you changed the constant.

If all my assumptions are correct, then you need to update the values in DB to take the new ones from the constant.

Hello Stefan,

 sorry, I will try to provide some more information.

 I have a record type (Orders) and a field name inside it (status: text). This field has six possible values (let's call them A, B, C, D, E, F). This possible values are stored in a constant (text type as well). 

I tried to change this status values in (let's say) One, two, three, four, five, six (instead of A, B, C, D, E, F).

Unfortunately, appian didn't updated the record data already stored, leading to data inconsistency errors, because appian checks between the data already stored (with the old names) and the values ​​in the constant (with the new names).

Is there a way to update also data already stored, in order to update from (for example) status: A to status: One?

I understand I can change the record, but it seems I can't change already stored data

Thanks

Hello Stefan,

 sorry, I will try to provide some more information.

 I have a record type (Orders) and a field name inside it (status: text). This field has six possible values (let's call them A, B, C, D, E, F). This possible values are stored in a constant (text type as well). 

I tried to change this status values in (let's say) One, two, three, four, five, six (instead of A, B, C, D, E, F).

Unfortunately, appian didn't updated the record data already stored, leading to data inconsistency errors, because appian checks between the data already stored (with the old names) and the values ​​in the constant (with the new names).

Is there a way to update also data already stored, in order to update from (for example) status: A to status: One?

I understand I can change the record, but it seems I can't change already stored data

Thanks

The data is persisted in the database. You need to modify this data. Preferably using the write-to-datastore smart service.

Where can i find this "write-to-datastore smart service"?

Thanks

it's one of the nodes available in the process model designer window, and is the singular way of storing data into the database from a process.  If you're trying to do this on a form (outside of a process), similarly you'd use the writeToDataStoreEntity smart service which is available in the suite of system rules.

Hm ... you seem to be new to the Appian world. I recommend to attend the Academy and work through the available documentation and tutorials.

https://docs.appian.com/suite/help/21.4/Write_to_Data_Store_Entity_Smart_Service.html

docs.appian.com/.../Working_with_Data_in_Process.html

You are right, I'm quite new. Anyway I attended the accademy and read the documention, in addition to having googled the problem. Unfortunately, trivial explanations and examples are always given to solve complex problems.