Query on Record table history

Hi Team,

I am working on the record history of my Appian application.  I created a new table with a similar column in application addition with Modifiedby, Modifiedat, and Operation in order to see create/update and delete history of the application record. Along with the db table, I have created a record type and data type. I have done the entity mapping successfully in the datastore.

Now while I am updating the code in create/update/delete interface, I am unable to fetch the data.

Below is the code snippet I am updating in submit button to save the record simultaneously in history table as well.

buttons: a!buttonLayout(
primaryButtons: {
a!buttonWidget(
label: "Submit",
saveInto: {

a!save(ri!record['recordType!{031f0b84-9549-4b3a-942c-a8fd3d0dfa62}NH_Handover_History.fields.{b5d840ba-2408-425d-b829-510414356ac2}serialnumber']),
a!save(ri!record['recordType!{031f0b84-9549-4b3a-942c-a8fd3d0dfa62}NH_Handover_History.fields.{d7f705b2-c020-47c9-95c4-cbe0e6df18a2}addedby']),
a!save(ri!record['recordType!{031f0b84-9549-4b3a-942c-a8fd3d0dfa62}NH_Handover_History.fields.{2dea3d66-d379-45f4-a1a5-62542a0d3f83}comments']),
a!save(ri!record['recordType!{031f0b84-9549-4b3a-942c-a8fd3d0dfa62}NH_Handover_History.fields.{4db0eea8-82d0-43a2-934c-48eb5338edc4}handoveritems']),
a!save(ri!record['recordType!{031f0b84-9549-4b3a-942c-a8fd3d0dfa62}NH_Handover_History.fields.{c51e0d60-934c-494a-8441-ef2fb63ea4b8}handoverto']),
a!save(ri!record['recordType!{031f0b84-9549-4b3a-942c-a8fd3d0dfa62}NH_Handover_History.fields.{847c96ef-2335-43ea-9daa-e3b57a52176e}standardhandoveritems']),
a!save(ri!record['recordType!{031f0b84-9549-4b3a-942c-a8fd3d0dfa62}NH_Handover_History.fields.{48062b9c-3273-4a3f-afd6-2386be0282ba}team']),
a!save(ri!record['recordType!{031f0b84-9549-4b3a-942c-a8fd3d0dfa62}NH_Handover_History.fields.{94ca961c-bcc7-4043-bb20-703e23564d07}modifiedby'],loggedInUser()),
a!save(ri!record['recordType!{031f0b84-9549-4b3a-942c-a8fd3d0dfa62}NH_Handover_History.fields.{b504bb2b-4e36-47e2-b0fb-bba6286c8166}modifiedat'],now()),
a!save(ri!record['recordType!{031f0b84-9549-4b3a-942c-a8fd3d0dfa62}NH_Handover_History.fields.{6fc387a1-36b4-4acb-bdf1-e47af07eecf1}operation'],"Create")

},

submit: true,
style: "PRIMARY",
validate: true
)
},

But I am getting the below error while submitting the new entry.

Could anyone let me know what i am missing in my code?

Thanks

Kundan

  Discussion posts and replies are publicly visible