a!localVariables( local!rule:rule!KONE_Development_userinputsheet_Rule(), local!noFiltersApplied: all(fn!isnull, {ri!userinputsheet.KONE_user_name}), a!sectionLayout( label:"Update Info", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!textField( label: "Username", value: ri!userinputsheet.KONE_user_name, saveInto: ri!userinputsheet.KONE_user_name, refreshAfter: "KEYPRESS" ), a!buttonLayout( primaryButtons: { a!buttonWidget( label: "SEARCH", saveInto: { ri!userinputsheet.KONE_user_name }, disabled: local!noFiltersApplied ) } ), a!gridLayout( label: "Editable Grid", labelPosition: "ABOVE", headerCells: { a!gridLayoutHeaderCell( label: "Username" ), a!gridLayoutHeaderCell( label: "First Name" ), a!gridLayoutHeaderCell( label: "Last Name" ), a!gridLayoutHeaderCell( label: "Email" ), a!gridLayoutHeaderCell( label: "Role" ), a!gridLayoutHeaderCell( label: "Branch" ), a!gridLayoutHeaderCell( label: "Region" ), a!gridLayoutHeaderCell( label: "Manager_role" ), a!gridLayoutHeaderCell( label: "Language" ), a!gridLayoutHeaderCell( label: "CE_LEVEL" ), a!gridLayoutHeaderCell( label: "Telephone Number" ), a!gridLayoutHeaderCell( label: "Exceptional Case Library View Right" ), a!gridLayoutHeaderCell( label: "Update" ), a!gridLayoutHeaderCell( label: "Delete" ), a!gridLayoutHeaderCell( label: "Restart" ) }, columnConfigs: { a!gridLayoutColumnConfig( width: "DISTRIBUTE" ), a!gridLayoutColumnConfig( width: "DISTRIBUTE" ), a!gridLayoutColumnConfig( width: "DISTRIBUTE" ), a!gridLayoutColumnConfig( width: "DISTRIBUTE" ), a!gridLayoutColumnConfig( width: "DISTRIBUTE" ), a!gridLayoutColumnConfig( width: "DISTRIBUTE" ), a!gridLayoutColumnConfig( width: "DISTRIBUTE" ), a!gridLayoutColumnConfig( width: "DISTRIBUTE" ), a!gridLayoutColumnConfig( width: "DISTRIBUTE" ), a!gridLayoutColumnConfig( width: "DISTRIBUTE" ), a!gridLayoutColumnConfig( width: "DISTRIBUTE" ), a!gridLayoutColumnConfig( width: "DISTRIBUTE" ), a!gridLayoutColumnConfig( width: "DISTRIBUTE" ), a!gridLayoutColumnConfig( width: "DISTRIBUTE" ), a!gridLayoutColumnConfig( width: "DISTRIBUTE" ) }, rows: { a!forEach( items:ri!userinputsheet, expression:a!gridRowLayout( contents: { a!textField( label: "Username", labelPosition: "ABOVE", value:fv!item.KONE_user_name, saveInto: { a!save(target:ri!userinputsheet.KONE_user_name,value:save!value), a!save(target:ri!userrole.NAME,value:save!value), }, refreshAfter: "UNFOCUS", readOnly: true, validations: {} ), a!textField( label: "First Name", labelPosition: "ABOVE", value:fv!item.FIRST_NAME, saveInto: ri!userinputsheet.FIRST_NAME, refreshAfter: "UNFOCUS", validations: {} ), a!textField( label: "Last Name", labelPosition: "ABOVE", value:fv!item.LAST_NAME, saveInto: ri!userinputsheet.LAST_NAME, refreshAfter: "UNFOCUS", validations: {} ), a!textField( label: "Email", labelPosition: "ABOVE", value:fv!item.Email, saveInto: { a!save(target:ri!userinputsheet.Email, value:save!value), a!save(target:ri!userrole.EMAIL,value:save!value)}, refreshAfter: "UNFOCUS", validations: {} ), a!textField( label: "Role", labelPosition: "ABOVE", value:fv!item.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,{}) )) }, refreshAfter: "UNFOCUS", validations: {} ), a!textField( label: "Branch", labelPosition: "ABOVE", value:fv!item.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,{}) )) }, refreshAfter: "UNFOCUS", validations: {} ), a!textField( label: "Region", labelPosition: "ABOVE", value:fv!item.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,{}) )) }, refreshAfter: "UNFOCUS", validations: {} ), a!textField( label: "Manager_role", labelPosition: "ABOVE", value:fv!item.Manager_role, saveInto:{ a!save(target:ri!userinputsheet.Manager_role,value:save!value) }, refreshAfter: "UNFOCUS", validations: {} ), a!textField( label: "Language", labelPosition: "ABOVE", value:fv!item.Language, saveInto:{ 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,{}) )) }, refreshAfter: "UNFOCUS", validations: {} ), a!textField( label: "CE_LEVEL", labelPosition: "ABOVE", value:fv!item.CE_LEVEL, saveInto: { a!save(target:ri!userinputsheet.CE_LEVEL,value:save!value), a!save(target:ri!userrole.LEVEL,value:save!value) }, refreshAfter: "UNFOCUS", validations: {} ), a!textField( label: "Telephone Number", labelPosition: "ABOVE", value:fv!item.Telephone_number, saveInto: { a!save(target:ri!userinputsheet.Telephone_number,value:save!value), a!save(target:ri!userrole.TELEPHONE_NUMBER,value:save!value) }, refreshAfter: "UNFOCUS", validations: {} ), a!textField( label: "Exceptional Case Library View Right", labelPosition: "ABOVE", value:fv!item.Exceptional_case_library_view_right, saveInto: { a!save(target:ri!userinputsheet.Exceptional_case_library_view_right,value:save!value), 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()), }, refreshAfter: "UNFOCUS", validations: {} ), a!richTextDisplayField( label:"upDate", labelPosition:"ABOVE", value:{ a!richTextIcon( icon:"check", link:a!dynamicLink( saveInto:{ 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) } ), } ), linkStyle:"STANDALONE", color:"POSITIVE" ) } ), a!richTextDisplayField( label:"Delete", labelPosition:"ABOVE", value:{ a!richTextIcon( icon:"arrow-down", link:a!dynamicLink( saveInto:{target:ri!userrole.ACTIVE,value:0} ), linkStyle:"STANDALONE", color:"NEGATIVE" ) } ), a!richTextDisplayField( label:"Restart", labelPosition:"ABOVE", value:{ a!richTextIcon( icon:"arrow-up", link:a!dynamicLink( saveInto:{target:ri!userrole.ACTIVE,value:1} ), linkStyle:"STANDALONE", color:"POSITIVE", ) } ) } ) ) }, pagesize:20, ) } ) } ) } ) )
I wish to update data from editable directly, but no matter how I edit in the cube unit of editable grid, after couple seconds i always change back to the original one, so failed to update. By the way how to limit the rows number of editable grid, pagesize not correct. Thank you
Discussion posts and replies are publicly visible