An Award Record has 3 sections: Section 1, Section 2, and Section 3. Section 1 and 2 combine to serve as a unique identifier. When you edit Section 3 of an Award Record, all of the Awards with the same values for Section 1 and 2 should be updated as well. This process model updates the value for Section 3, but it does not check to see if there are other awards with the same combination of Section 1&2 before writing to the DB.
I was told to "build a dictionary in building the CDT before the DB write and write the array".
Any help would be greatly appreciated!
Thank you
Discussion posts and replies are publicly visible
This doesn't make much sense here with such a vague description of the data structure. My advice in general is to map it out on a whiteboard and try to simplify what updates will be needed to the structure given your on-form update of any particular data element, and go from there.
Is there any information I can add to make it more understandable? I have the whiteboard mapped out; I understand what I want to do just now how to get Appian to do it. If you edit "Award.A.B.1" to "Award.A.B.2", then it would need to edit all awards in the database that start with "Award.A.B." and change the last value to "2".
I don't really understand though - are the values being stored/edited, actually hardcoded into different tables as duplicate copies or something? In a relational DB there would typically be no need to manually change values in related tables if things are properly normalized.
No, it's all in the same database table. I just want the single edit action to apply to multiple records.