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
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
This is what I am talking about.
Question: Is the PV "username" configured as parameter?
Then you need to monitor the last process instance and check whether the PV has to expected value.
OK, that seems to be good. What about monitoring?
what do you mean monitoring? process instance nothing shows up, where else can monitor?
Sorry not being mean to you, just to direct, i am pleasing on your help
An error occurred while trying to write to the entity "username" [id=309bbcf5-b599-4929-803f-15824ea28283@14858, type=username (id=3906)] (data store: user_Input_sheet). Details: java.lang.IllegalArgumentException: The record to be saved must not be null: TypedValue[it=3906,v=<null>] Data: TypedValue[it=3906,v=<null>]