Solved
Editable grid cube value always return back to fv!item.value no matter how I edit in the small cube
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