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
You can trigger a process model to work on multiple smart services . Please refer the other post.
I know but always idiotic on process model
Try calling a!startprocess in button save into in order to trigger the process. Create a constant for your process model to refer in the above function and pass the parameters which you are intended to pass.
the question is what fill in the processParameter?!!
Need to fill the parameters what you require in the process model which you try to pass to the smart service.
In your code - ri!userinputsheet in your first smart service.
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?
not at all ;)
You are aware that it is a real challenge to try to support you with this kind of answers?
In most of my answers to your questions, I need to ask for details. Trying again.
https://codeblog.jonskeet.uk/2012/11/24/stack-overflow-question-checklist/
I need screenshots of the process variable configuration and the a!startProcess code.
I think I almost there but seems only small piccadillo i commit but can't figure it out, and i dont know where, I already over come the barrier of interface,once i can complete processModel by myself, which would be a great process for me and my company.
OK
Once again: processParameters need to be a dictionary. You need to tell Appian which value to pass to which variable. As you did not post a screenshot of the process variable configuration, I can only guess the names.
processParameters: { username: ri!username }
The process variable needs to be configured as a parameter.
To find out whether that works you need to monitor the last started process instance.
still didn't see any changes