Query on record table history code

Hi Team,

I am working on the history table of my Appian application. I created a new table in the database having a similar column of my application in addition of 3 new columns modifyby, modifyat, and operation(create/update/delete). I created a corresponding record type/data type as well. The entity mapping on the Datastore is also successfully done.

Now while I am updating my code on create/update/delete interface to fetch the action history of my app, I am getting errors.

This is the code:-

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
      )
    },

This is error screenshot:-

Could you please suggest, what I am missing here?

Thanks in advance

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Senior Developer

    in these save are you saving any value

    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']),

    its should be like a!save(<field>,value) the value is missing in your above code

    like in           a!save(ri!record['recordType!{031f0b84-9549-4b3a-942c-a8fd3d0dfa62}NH_Handover_History.fields.{6fc387a1-36b4-4acb-bdf1-e47af07eecf1}operation'],"Create")

    you are saving "create" in operation but field like {"team","standardhandoveritems","handoverto","handoveritems","comments","addedby","serialnumber"} has no value 

Reply
  • 0
    Certified Senior Developer

    in these save are you saving any value

    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']),

    its should be like a!save(<field>,value) the value is missing in your above code

    like in           a!save(ri!record['recordType!{031f0b84-9549-4b3a-942c-a8fd3d0dfa62}NH_Handover_History.fields.{6fc387a1-36b4-4acb-bdf1-e47af07eecf1}operation'],"Create")

    you are saving "create" in operation but field like {"team","standardhandoveritems","handoverto","handoveritems","comments","addedby","serialnumber"} has no value 

Children
No Data