Skip to main content
March 9, 2021
Question

Update record

  • March 9, 2021
  • 2 replies
  • 0 views

Hi,

I want to update the record .Here I have written the expression for fetching  the data and it is working fine but now I want to update the status with help

of Interface(means what ever user enter the value in status ,the status should be update).What changes should I do here .

a!queryEntity(
entity: cons!LA_ManagerStatusCons,
query: a!query(
selection: a!querySelection(columns: {
a!queryColumn( field: "EmployeeName"),
a!queryColumn( field: "Status"),

}),

filter: a!queryFilter( field: "Status",
operator:"=",
value:ri!Status ),
pagingInfo: a!pagingInfo(1,5)
)
).data

Thanks

    2 replies

    danny.verb
    March 9, 2021

    You can utilize the Write to Data Store Smart Service https://docs.appian.com/suite/help/20.4/Write_to_Data_Store_Entity_Smart_Service.html#awritetodatastoreentity

    This lets you write to the database either via an interface click or within a process model.

    arund0002Author
    March 10, 2021

    Thanks Danny,

    I will try to implement this