title as above,
code as:
a!save(target:ri!userinputsheet.KONE_user_name,value: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!userinputsheet.Role,value:fv!item.Role), a!save(target:ri!userinputsheet.Branch,value:fv!item.Branch), a!save(target:ri!userinputsheet.Region,value:fv!item.Region), a!save(target:ri!userinputsheet.Manager_role,value:fv!item.Manager_role), a!save(target:ri!userinputsheet.Telephone_number,value:fv!item.Telephone_number), a!save(target:ri!userinputsheet.CE_LEVEL,value:fv!item.CE_LEVEL), a!save(target:ri!userinputsheet.Active,value:fv!item.Active), a!save(target:ri!userinputsheet.Language,value:fv!item.Language), a!save(target:ri!userinputsheet.Exceptional_case_library_view_right,value:fv!item.Exceptional_case_library_view_right), a!save(target:ri!userinputsheet.updateTime,value:now()), a!writeToMultipleDataStoreEntities( valuesToStore: { a!entityData(entity: cons!KONE_Development_userinputsheet_Constant, data: ri!userinputsheet), a!entityData(entity: cons!KONE_Development_userrole_Constant, data: ri!userrole) } )
what is the problem?
Discussion posts and replies are publicly visible
Hi,
The problem may be that the write to datastore is not on the correct component
Is this saveinto into a button or similar component?
docs.appian.com/.../Write_to_Data_Store_Entity_Smart_Service.html
Also if it's not necessary, i would advise to not save directly from the interface but to use a process model
saveinto button
could you share the whole button code?
a!buttonWidget( label: "Update", saveInto:{ a!save(target:ri!userinputsheet.KONE_user_name,value: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!userinputsheet.Role,value:fv!item.Role), a!save(target:ri!userinputsheet.Branch,value:fv!item.Branch), a!save(target:ri!userinputsheet.Region,value:fv!item.Region), a!save(target:ri!userinputsheet.Manager_role,value:fv!item.Manager_role), a!save(target:ri!userinputsheet.Telephone_number,value:fv!item.Telephone_number), a!save(target:ri!userinputsheet.CE_LEVEL,value:fv!item.CE_LEVEL), a!save(target:ri!userinputsheet.Active,value:fv!item.Active), a!save(target:ri!userinputsheet.Language,value:fv!item.Language), a!save(target:ri!userinputsheet.Exceptional_case_library_view_right,value:fv!item.Exceptional_case_library_view_right), a!save(target:ri!userinputsheet.updateTime,value:now()), a!writeToMultipleDataStoreEntities( valuesToStore: { a!entityData(entity: cons!KONE_Development_userinputsheet_Constant, data: ri!userinputsheet), a!entityData(entity: cons!KONE_Development_userrole_Constant, data: ri!userrole) } ) }, submit: true, style: "PRIMARY" )
Hi there,
By any chance, have you called this interface inside another interface and then mapped the userinputsheet RI with a refreshVariable?
I wasn't accomplish exact what you mean, i didn't use a!refreshVariable in this interface, plus i don't think i recall this interface from others or vice versa.
How many dependents does this interface have? And where are you calling it? Directly in a process model?
a!localVariables( local!allRole:rule!KONE_Development_ROLE(), local!allLanguage:rule!KONE_Development_LANGUAGE(), local!allBranch:rule!KONE_Development_BRANCH(), local!allRegion:rule!KONE_Development_REGION(), local!valid:false(), local!Language, local!noFiltersApplied: any(fn!isnull, {ri!userinputsheet.kone_user_name, ri!userinputsheet.FIRST_NAME, ri!userinputsheet.LAST_NAME,ri!userinputsheet.Email, ri!userinputsheet.Role, }), a!formLayout( label:"Registration Info", contents: { a!textField( label: "Username(please fill lower case or it will transfer to lower)", value: {ri!userinputsheet.kone_user_name}, saveInto: { a!save(target:ri!userinputsheet.Active,value:1), a!save(target:ri!userrole.IS_EXCEPTION,value:0), a!save(target:ri!userrole.ACTIVE,value:1), a!save(target:ri!userinputsheet.updateTime,value:now()), a!save(target:ri!userinputsheet.kone_user_name, value:trim(lower(save!value))), a!save(target:ri!userrole.NAME, value:trim(lower(save!value))), a!save(target:local!valid, value:if(isnull(ri!userinputsheet.kone_user_name),false(), if(a!queryEntity( entity:cons!KONE_Development_userrole_Constant, fetchTotalCount:true, query:a!query( filter:a!queryFilter( field:"NAME",operator:"=", value:ri!userinputsheet.kone_user_name ), pagingInfo:a!pagingInfo( startIndex: 1, batchSize: 50 ) ) ).totalCount>0,true(),false() ) ) ) }, required:true, validations:if(local!valid=true(),"username already exists",null) ), a!textField( label: "FirstName", value: {ri!userinputsheet.FIRST_NAME}, saveInto: {ri!userinputsheet.FIRST_NAME}, required:true ), a!textField( label: "LastName", value: {ri!userinputsheet.LAST_NAME}, saveInto: {ri!userinputsheet.LAST_NAME}, required:true ), a!textField( label: "Email", value: {ri!userinputsheet.Email}, saveInto: { a!save(target:ri!userinputsheet.Email, value:save!value), a!save(target:ri!userrole.EMAIL,value:save!value) }, required:true, validations:if(find("@",ri!userinputsheet.Email),if(find(".com",ri!userinputsheet.Email),null,"not contain correction .com"),if(find(".com",ri!userinputsheet.Email),"not contain @","not contain @ and .com")) ), a!dropdownField( label:"Role", placeholder:"---please fill your Role---", choiceLabels:reject(fn!isnull,local!allRole), choiceValues:reject(fn!isnull,local!allRole), value:ri!userinputsheet.Role, saveInto:{ a!save(target:ri!userinputsheet.Role,value:save!value), 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.ROLE, value: save!value), 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,{}) )) }, required:true ), a!dropdownField( label:"Branch", placeholder:"---please fill your Branch---", choiceLabels:reject(fn!isnull,local!allBranch), choiceValues:reject(fn!isnull,local!allBranch), value:ri!userinputsheet.Branch, saveInto:{ a!save(target:ri!userinputsheet.Branch,value:save!value), a!save(target:ri!userrole.BRANCH,value:save!value), 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!dropdownField( label:"Region", placeholder:"---please fill your Region---", choiceLabels:reject(fn!isnull,local!allRegion), choiceValues:reject(fn!isnull,local!allRegion), value:ri!userinputsheet.Region, saveInto:{ a!save(target:ri!userinputsheet.Region,value:save!value), a!save(target:ri!userrole.REGION,value:save!value), 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!dropdownField( label:"Manager_Role", placeholder:"---please fill your Manager_Role---", choiceLabels:reject(fn!isnull,local!allRole), choiceValues:reject(fn!isnull,local!allRole), value:ri!userinputsheet.Manager_role, saveInto:{ a!save(target:ri!userinputsheet.Manager_role,value:save!value) } ), a!dropdownField( label:"Language", labelPosition: "ABOVE", placeholder:"Chinese", choiceLabels:{reject(fn!isnull,local!allLanguage)}, choiceValues:reject(fn!isnull,local!allLanguage), value:ri!userinputsheet.Language, saveInto:{ a!save(target:local!Language,value:save!value), a!save(target:ri!userinputsheet.Language,value:save!value), 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,2) )) } ), a!textField( label: "CELevel", value: {ri!userinputsheet.CE_LEVEL}, saveInto: { a!save(target:ri!userinputsheet.CE_LEVEL,value:save!value), a!save(target:ri!userrole.LEVEL,value:save!value) } ), a!textField( label: "Telephone Number", value: {ri!userinputsheet.Telephone_number}, saveInto: { a!save(target:ri!userinputsheet.Telephone_number,value:save!value), a!save(target:ri!userrole.TELEPHONE_NUMBER,value:save!value) }, validations: if( len(ri!userinputsheet.Telephone_number) <> 11, "phone number should be 11 digits", null ) ), a!textField( label: "Exceptional Case Library View Right", value: {ri!userinputsheet.Exceptional_case_library_view_right}, saveInto: { a!save(target:ri!userinputsheet.Exceptional_case_library_view_right,value:save!value) }, refreshAfter: "KEYPRESS" ), a!richTextDisplayField( labelPosition: "COLLAPSED", value: { a!richTextItem( text:"username already exists or incorrect fill such as leave the necessary field blank or wrong form" ) }, showWhen:local!valid=true() ) }, buttons:a!buttonLayout( primaryButtons:{ a!buttonWidget( label: "Submit", saveInto:{ if(isnull(ri!userinputsheet.Language), a!save( target:ri!userinputsheet.Language, value:"Chinese" ),{}), a!writeToMultipleDataStoreEntities( valuesToStore: { a!entityData(entity: cons!KONE_Development_userinputsheet_Constant, data: ri!userinputsheet), a!entityData(entity: cons!KONE_Development_userrole_Constant, data: ri!userrole) } ), a!save(ri!userinputsheet,null()) }, submit: true, style: "PRIMARY", disabled: or(local!valid=true(),local!noFiltersApplied) ), a!buttonWidget( label:"Clear", saveInto: {a!save(ri!userinputsheet, null())}, submit:false, style:"PRIMARY" ) } ) ) )
errors occur after line:507.