I would like to rename the source field name for a field in one of my record types ('source field name' is the field in the database table, holding the record type).
In the record type, screen Data Model > Configure Fields, I am allowed to change the record field name (the field name visible in Appian), but the source field name is readonly!
In this particular case, I would like to change "workzonecaseid" to "WORKZONE_SAGS_NR":
Here's the current situation in MariaDB:
Discussion posts and replies are publicly visible
Hello Søren Juul,
You can do the changes of your source field names only in the source. In your case it is the Database. you need to update the name in Database.
But May I know why do you want to change it? Because you will be displaying only the Record Field Name
Than you, it worked :-)
Yes, I know that the database field name is not visible in Appian (apart from the "Configure Fields" screen), but it is confusing, when I work in MariaDB, that two fields have nearly identical names ("sag" or "sags" in danish means "case").
Okay!
Actually, it only works so-so: Now I have to manually edit all the references in the code:
That is obvious. Every field you create is assigned a unique ID. If you change that field, you have actually changed the Id also.
Unknown said:If you change that field, you have actually changed the Id also.
Should it be that way? I figured one of the presumed benefits of the new RecordType data system was that it can obfuscate all this stuff in a way that it gets handled automatically - thus you'd think if it has a way of knowing that the underlying DB field name for a given property is changed, then it should be able to reflect the new field inherently without needing to assign a new UUID to it.
That said, if the field name is changed in the DB out from under the synced data type, i'm not sure how the synced data type would be expected to know it's the same field. I suppose maybe this is an argument in favor of allowing the synced data type to be able to handle this from the Designer UI. I suppose it's not possible to do some sort of code-level update like updating the XSD for a CDT... interesting question