Skip to main content
raulg0001
Inspiring
January 17, 2023
Question

record field reference

  • January 17, 2023
  • 5 replies
  • 0 views

I have a record that I use in many interfaces, querys. I need to change the data type of a column in the database. If I make this change, the references to that field are lost and I have to edit all the objects that use the field from that record to reference the new field type. This can be avoided somehow. That is, appian updates the reference of the record.field automatically.

5 replies

stewart.burchell
January 18, 2023
  1. what is the current data type and what are you changing it to?
  2. how is your record mapped to the DB table? Is it using a CDT via a Data Store Entity, or a Synced Record?
raulg0001
raulg0001Author
Inspiring
January 18, 2023

the data type is Request and I am changing State Varchar 20 to State Varchar 255.

I am using a synchronized register and in the interfaces I use ri! of type Record. With this change, the reference to the State field is lost and must be updated manually in all objects that use it.

June 27, 2024

did you find easiest solution to update record field references.?

June 28, 2024

You can find objects having an "Invalid Record Field Reference" issue in the Heath Dashboard tab under Monitoring.