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

  • Hi Kundan

    U haven't given the value parameter and when your using a!save we have to pass two parameters

    1)Target

    2)Value

    I this code u have mentioned only the target, u haven't mentioned which value to store

  • 0
    Certified Senior Developer

    Hello ,

    Hope you are doing well.

    The error seems pretty clear. You are not passing enough parameters in the a!save() which you are using in the "Submit" button. You have the Target but not the value.

    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'],<Missing Parameter>),
    a!save(ri!record['recordType!{031f0b84-9549-4b3a-942c-a8fd3d0dfa62}NH_Handover_History.fields.{d7f705b2-c020-47c9-95c4-cbe0e6df18a2}addedby'],<Missing Parameter>),
    a!save(ri!record['recordType!{031f0b84-9549-4b3a-942c-a8fd3d0dfa62}NH_Handover_History.fields.{2dea3d66-d379-45f4-a1a5-62542a0d3f83}comments'],<Missing Parameter>),
    a!save(ri!record['recordType!{031f0b84-9549-4b3a-942c-a8fd3d0dfa62}NH_Handover_History.fields.{4db0eea8-82d0-43a2-934c-48eb5338edc4}handoveritems'],<Missing Parameter>),
    a!save(ri!record['recordType!{031f0b84-9549-4b3a-942c-a8fd3d0dfa62}NH_Handover_History.fields.{c51e0d60-934c-494a-8441-ef2fb63ea4b8}handoverto'],<Missing Parameter>),
    a!save(ri!record['recordType!{031f0b84-9549-4b3a-942c-a8fd3d0dfa62}NH_Handover_History.fields.{847c96ef-2335-43ea-9daa-e3b57a52176e}standardhandoveritems'],<Missing Parameter>),
    a!save(ri!record['recordType!{031f0b84-9549-4b3a-942c-a8fd3d0dfa62}NH_Handover_History.fields.{48062b9c-3273-4a3f-afd6-2386be0282ba}team'],<Missing Parameter>),
    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
    )