a!richTextIcon( icon:"arrow-down", link:a!dynamicLink( saveInto:{ a!save(target:ri!userrole.ROLE,value:fv!item.Role), a!save(target:ri!userinputsheet.KONE_user_name,value:fv!item.KONE_user_name), a!save(target:ri!userrole.NAME,value:fv!item.KONE_user_name), a!save( target:ri!userrole.USER_ID, value:rule!KONE_Development_UserId(fv!item.KONE_user_name) ), a!save(target:ri!userinputsheet.FIRST_NAME,value:fv!item.FIRST_NAME), a!save(target:ri!userinputsheet.LAST_NAME,value:fv!item.LAST_NAME), a!save(target:ri!userinputsheet.Email, value:fv!item.Email), a!save(target:ri!userrole.EMAIL,value:fv!item.Email), a!save(target:ri!userinputsheet.Role,value:fv!item.Role), a!save( target:ri!userrole.ROLE_ID, value: a!forEach (items:rule!KONE_Development_Role_RoleId(), expression:if(fv!item.Role=ri!userinputsheet.Role,fv!item.Role_Id,{}) )), a!save( target:ri!userrole.USER_ID, value:rule!KONE_Development_UserId(ri!userinputsheet.KONE_user_name) ), a!save( target:ri!userrole.ROLE, value: fv!item.Role), a!save(target:ri!userrole.PHASE_ID, value:a!forEach (items:rule!KONE_Development_Role_RoleId(), expression:if(fv!item.Role=ri!userinputsheet.Role,fv!item.Role_Id,{}) )), a!save(target:ri!userinputsheet.Branch,value:fv!item.Branch), a!save(target:ri!userrole.BRANCH,value:fv!item.Branch), a!save(target:ri!userrole.BRANCH_ID, value:a!forEach (items:rule!KONE_Development_Branch_BranchId(), expression:if(fv!item.Branch=ri!userinputsheet.Branch,fv!item.Branch_Id,{}) )), a!save(target:ri!userinputsheet.Region,value:fv!item.Region), a!save(target:ri!userrole.REGION,value:fv!item.Region), a!save(target:ri!userrole.REGION_ID, value:a!forEach (items:rule!KONE_Development_Region_RegionId(), expression:if(fv!item.Region=ri!userinputsheet.Region,fv!item.Region_Id,{}) )), a!save(target:ri!userinputsheet.Manager_role,value:fv!item.Manager_role), a!save(target:ri!userinputsheet.Language,value:fv!item.Language), a!save(target:ri!userrole.LANG_ID, value:a!forEach (items:rule!KONE_Development_Language_LanguageId(), expression:if(fv!item.Language=ri!userinputsheet.Language,fv!item.Language_Id,{}) )), a!save(target:ri!userinputsheet.CE_LEVEL,value:fv!item.CE_LEVEL), a!save(target:ri!userrole.LEVEL,value:fv!item.CE_LEVEL), a!save(target:ri!userinputsheet.Telephone_number,value:fv!item.Telephone_number), a!save(target:ri!userrole.TELEPHONE_NUMBER,value:fv!item.Telephone_number), a!save(target:ri!userinputsheet.Exceptional_case_library_view_right,value:fv!item.Exceptional_case_library_view_right), a!save(target:ri!userrole.IS_EXCEPTION,value:0), a!save(target:ri!userinputsheet.updateTime,value:now()), a!save(target:ri!userrole.ACTIVE,value:0), a!save(target:ri!userinputsheet.Active,value:0), a!writeToMultipleDataStoreEntities( valuesToStore: { a!entityData(entity: cons!KONE_Development_userinputsheet_Constant, data: ri!userinputsheet), } ), a!deleteFromDataStoreEntities( dataToDelete: { a!entityDataIdentifiers( entity: cons!KONE_Development_userrole_Constant, identifiers: ri!userrole.NAME ) }, ) } ), linkStyle:"STANDALONE", color:"NEGATIVE" )
Just watch the bottom, i wish to update data to one table and delete data from table after click arrow-down button at the same time, but it can't running double smart service at same time, any way can make it come true?
Discussion posts and replies are publicly visible
please check ri!username in your interface and pv!username in your process model are of same type.
it should be, i just have one table called username
But there are three columns in your table.
This one is different as the one i post above, i use another table for trial practice, dont put it same as ri!userinputsheet.
When you check the documentation about a!startProcess, then you will see that processParameters needs to be a dictionary. Dictionaries are also explained in documentation.
which documentation? how to transfer a list to be dictionary, I am running out to be crazy
https://docs.appian.com/suite/help/21.3/Expressions.html#dictionaries
{list: local!list}
It didn't report any error, but didn't execute any insert work to database sir.
What did not report any error? Do you see the passed data in the process instance?