[ld_id=1188, ll_id=904, fl_id=, fm_id=, rsed_id=, appian_document_id=5357264, klt_id=, legacy_id=, description=, name=, createdby=testc, createdon=10/3/2022 7:14 PM, modifiedby=tects, modifiedon=10/3/2022 7:44 PM, inuse=1],[ld_id=, ll_id=904, fl_id=, fm_id=, rsed_id=, appian_document_id=6057969, klt_id=, legacy_lease_id=, description=The Parties, by mutual agreement, due to the Partial Surrender of the Demised Premises, agree to amend items 1 ("Base Rent"), 3 ("Demised Premises") and 10 ("Shared Property Expenses") of the Summary of Terms and Definitions of the Agreement., name=, createdby=testc, createdon=10/3/2022 7:44 PM, modifiedby=, modifiedon=, inuse=1],[ld_id=, ll_id=, fl_id=, fm_id=, rsed_id=, appian_document_id=6057968, klt_id=, legacy_id=, description=, name=, createdby=, createdon=, modifiedby=lecst, modifiedon=10/3/2022 7:44 PM, inuse=0]
This was the pv variable cdt data in that for second id (second occurence) means where document id =6057969 i want to update "description" column data i used update array function in the place of index i was confused what exactly needs to be provided kindly suggest on this
updatearray(array:pv!documentsToUpdateInDB,index:index( pv!documentsToUpdateInDB,*tried with many ways here by passing as index not worked* ),value:"The Parties, by mutual agreement, due to the Partial Surrender of the Demised Premises")
Discussion posts and replies are publicly visible
Hi dharanik2600,
Since you want to update a particular row based on doc id,
please try the following code,
updatearray( array: index( pv!documentsToUpdateInDB,wherecontains( tointeger("appian_document_id"), tointeger(index(pv!documentsToUpdateInDB,"appian_document_id",null)), null), index: "description", value: "Text to be replaced" )
if you are looking to update an array of elements you can use foreach on top the code.
please let me know if it works or not.
thanks