An error occurred while executing a save: Expression evaluation error: The save target must be a local variable that does not refresh on every evaluation or on an interval, a process variable, or a node input

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

Parents
  • Can you try to comment the Write to Data store entity code and try, if is works, it means there is something wrong with DSE. So we can check there.

  • a!save(
    target: ri!userinputsheet.Language,
    value: if(
    isnull(ri!userinputsheet.Language),
    "Chinese",
    ri!userinputsheet.Language
    )
    ),

    Try above code on save into for language.

  • i promise i don't have null value in the text blank. Because i always let it shows up database value by expression, i show you my overall code.

    a!localVariables(
      local!rule:rule!KONE_Development_userinputsheet_Rule(),
      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!newGrid:'type!{urn:com:appian:types}user_input_sheet'(),
      local!noFiltersApplied: all(fn!isnull, {ri!userinputsheet.KONE_user_name,
      ri!userinputsheet.FIRST_NAME,
      ri!userinputsheet.LAST_NAME,
      ri!userinputsheet.Email,
      ri!userinputsheet.Role,
      ri!userinputsheet.Branch,ri!userinputsheet.Region,ri!userinputsheet.Manager_role,
      ri!userinputsheet.Language,ri!userinputsheet.CE_LEVEL,ri!userinputsheet.Telephone_number,
      ri!userinputsheet.Exceptional_case_library_view_right,
      }),
      local!searchValue,
      a!sectionLayout(
        label:"Update Info",
        contents: {
          a!columnsLayout(
            columns: {
              a!columnLayout(
                contents: {
                  a!textField(
                    label: "USERNAME",
                    labelPosition: "ABOVE",
                    value:local!searchValue,
                    saveInto: local!searchValue,
                    refreshAfter: "KEYPRESS",
                    validations: {}
                  ),
                  a!buttonArrayLayout(
                    buttons: {
                      a!buttonWidget(
                        label: "Clear",
                        saveInto:a!save(local!searchValue,null()),
                        style: "NORMAL"
                      )
                    },
                    align: "START"
                  )
                }
              )
            }
          ),
          if(
          isnull(local!searchValue),
          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: "Deactivate"
              ),
              a!gridLayoutHeaderCell(
                label: "Inactivate"
              )
            },
            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"
              )
            },
            rows: {
              a!forEach(
                items: rule!KONE_Development_updateQueryAllPeople(),
                expression:a!localVariables(
                  local!userinputsheet:fv!item,
                  a!forEach(
                    items:local!rule,
                    expression:if(fv!item.KONE_user_name=local!userinputsheet.KONE_user_name,
                    if(fv!item.updateTime=local!userinputsheet.updateTime,a!gridRowLayout(
                      contents: {
                        a!textField(
                          label: "Username",
                          labelPosition: "ABOVE",
                          value:fv!item.KONE_user_name,
                          saveInto: fv!item.KONE_user_name,
                          refreshAfter: "UNFOCUS",
                          readOnly: true,
                          validations: {}
                        ),
                        a!textField(
                          label: "First Name",
                          labelPosition: "ABOVE",
                          value:fv!item.FIRST_NAME,
                          saveInto: {
                            fv!item.FIRST_NAME
                          },
                          refreshAfter: "UNFOCUS",
                          validations: {}
                        ),
                        a!textField(
                          label: "Last Name",
                          labelPosition: "ABOVE",
                          value:fv!item.LAST_NAME,
                          saveInto: fv!item.LAST_NAME,
                          refreshAfter: "UNFOCUS",
                          validations: {}
                        ),
                        a!textField(
                          label: "Email",
                          labelPosition: "ABOVE",
                          value:fv!item.Email,
                          saveInto: fv!item.Email,
                          refreshAfter: "UNFOCUS",
                          validations: {}
                        ),
                        a!dropdownField(
                          label: "Role",
                          labelPosition: "ABOVE",
                          choiceLabels:reject(fn!isnull,local!allRole),
                          choiceValues:reject(fn!isnull,local!allRole),
                          value:fv!item.Role,
                          saveInto: fv!item.Role,
                          validations: {}
                        ),
                        a!dropdownField(
                          label: "Branch",
                          labelPosition: "ABOVE",
                          choiceLabels:reject(fn!isnull,local!allBranch),
                          choiceValues:reject(fn!isnull,local!allBranch),
                          value:fv!item.Branch,
                          saveInto: fv!item.Branch,
                          validations: {}
                        ),
                        a!dropdownField(
                          label: "Region",
                          labelPosition: "ABOVE",
                          choiceLabels:reject(fn!isnull,local!allRegion),
                          choiceValues:reject(fn!isnull,local!allRegion),
                          value:fv!item.Region,
                          saveInto: fv!item.Region,
                          validations: {}
                        ),
                        a!dropdownField(
                          label: "Manager_role",
                          labelPosition: "ABOVE",
                          choiceLabels:reject(fn!isnull,local!allRole),
                          choiceValues:reject(fn!isnull,local!allRole),
                          value:fv!item.Manager_role,
                          saveInto: fv!item.Manager_role,
                          validations: {}
                        ),
                        a!dropdownField(
                          label: "Language",
                          labelPosition: "ABOVE",
                          choiceLabels:reject(fn!isnull,local!allLanguage),
                          choiceValues:reject(fn!isnull,local!allLanguage),
                          value:fv!item.Language,
                          saveInto: fv!item.Language,
                          validations: {}
                        ),
                        a!textField(
                          label: "CE_LEVEL",
                          labelPosition: "ABOVE",
                          value:fv!item.CE_LEVEL,
                          saveInto: fv!item.CE_LEVEL,
                          refreshAfter: "UNFOCUS",
                          validations: {}
                        ),
                        a!textField(
                          label: "Telephone Number",
                          labelPosition: "ABOVE",
                          value:fv!item.Telephone_number,
                          saveInto: fv!item.Telephone_number,
                          refreshAfter: "UNFOCUS",
                          validations: {}
                        ),
                        a!textField(
                          label: "Exceptional Case Library View Right",
                          labelPosition: "ABOVE",
                          value:fv!item.Exceptional_case_library_view_right,
                          saveInto:fv!item.Exceptional_case_library_view_right,
                          refreshAfter: "UNFOCUS",
                          validations: {}
                        ),
                        a!richTextDisplayField(
                          label:"Update",
                          labelPosition:"ABOVE",
                          value:{
                            a!richTextIcon(
                              icon:"check",
                              link:a!dynamicLink(
                                saveInto:{
                                    a!save(
                                      target:ri!userrole.USER_ID,
                                      value:rule!KONE_Development_UserId(fv!item.KONE_user_name)
                                    ),
                                    a!save(target:ri!userinputsheet.Role,value:fv!item.Role),
                                    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:a!localVariables(local!value:fv!item.KONE_user_name,
                                    a!forEach(items:rule!KONE_Development_Username_UserId(),expression:if(local!value=fv!item.username,fv!item.userid,{}))
                                    )),
                                    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!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: fv!item.Role),
                                    a!save(target:ri!userinputsheet.Active,value:fv!item.Active),
                                    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!userrole.ACTIVE,value:fv!item.Active),
                                    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)
                                          }
                                        ),
                                }
                              ),
                              linkStyle:"STANDALONE",
                              color:"POSITIVE"
                            )
                          }
                        ),
                        a!richTextDisplayField(
                          label:"Deactivate",
                          labelPosition:"ABOVE",
                          value:{
                            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!entityData(entity: cons!KONE_Development_userrole_Constant, data: ri!userrole)
                                        }
                                      )
                                }
                              ),
                              linkStyle:"STANDALONE",
                              color:"NEGATIVE"
                            )
                          }
                        ),
                        a!richTextDisplayField(
                          label:"Activate",
                          labelPosition:"ABOVE",
                          value:{
                            a!richTextIcon(
                              icon:"arrow-up",
                              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:1),
                                      a!save(target:ri!userinputsheet.Active,value:1),
                                      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!forEach(
            items:rule!KONE_Development_updateQueryAllPeople(),
            expression:a!localVariables(
              local!userinputsheet2:fv!item,
              a!forEach(
                items:rule!KONE_Development_userinputsheet_Rule(),
                expression:if(local!userinputsheet2.KONE_user_name=fv!item.KONE_user_name,
                if(local!userinputsheet2.updateTime=fv!item.updateTime,
                if(fv!item.KONE_user_name=local!searchValue,
                {
                a!columnsLayout(
                  columns: {
                    a!columnLayout(
                      contents: {
                        a!textField(
                          label: "Username",
                          labelPosition: "ABOVE",
                          value:fv!item.KONE_user_name,
                          saveInto: {fv!item.KONE_user_name,
                          a!save(target:ri!userinputsheet.KONE_user_name,value:save!value)
                          },
                          refreshAfter: "UNFOCUS",
                          readonly:true,
                          validations: {}
                        )
                      }
                    ),
                    a!columnLayout(
                      contents: {
                        a!textField(
                          label: "First Name",
                          labelPosition: "ABOVE",
                          value:fv!item.FIRST_NAME,
                          saveInto: {fv!item.FIRST_NAME,
                          a!save(target:ri!userinputsheet.FIRST_NAME,value:save!value),
                          },
                          refreshAfter: "UNFOCUS",
                          validations: {}
                        )
                      }
                    ),
                    a!columnLayout(
                      contents: {
                        a!textField(
                          label: "Last Name",
                          labelPosition: "ABOVE",
                          value:fv!item.LAST_NAME,
                          saveInto: {fv!item.LAST_NAME,
                          a!save(target:ri!userinputsheet.LAST_NAME,value:save!value),
                          },
                          refreshAfter: "UNFOCUS",
                          validations: {}
                        )
                      }
                    ),
                    a!columnLayout(
                      contents: {
                        a!textField(
                          label: "Email",
                          labelPosition: "ABOVE",
                          value:fv!item.Email,
                          saveInto: fv!item.Email,
                          refreshAfter: "UNFOCUS",
                          validations: if(find("@",fv!item.Email),if(find(".com",fv!item.Email),null,"not contain correction .com"),if(find(".com",fv!item.Email),"not contain @","not contain @ and .com"))
                        )
                      }
                    )
                  }
                ),
                a!columnsLayout(
                  columns: {
                    a!columnLayout(
                      contents: {
                        a!dropdownField(
                          label: "Role",
                          labelPosition: "ABOVE",
                          placeholder: "--- Select a Value ---",
                          choiceLabels: reject(fn!isnull,(local!allRole)),
                          choiceValues: reject(fn!isnull,(local!allRole)),
                          value:fv!item.Role,
                          saveInto: a!save(target:fv!item.Role,value:save!value),
                          searchDisplay: "AUTO",
                          validations: {}
                        )
                      }
                    ),
                    a!columnLayout(
                      contents: {
                        a!dropdownField(
                          label: "Branch",
                          labelPosition: "ABOVE",
                          placeholder: "--- Select a Value ---",
                          choiceLabels: reject(fn!isnull,local!allBranch),
                          choiceValues: reject(fn!isnull,local!allBranch),
                          value:fv!item.Branch,
                          saveInto: fv!item.Branch,
                          searchDisplay: "AUTO",
                          validations: {}
                        )
                      }
                    ),
                    a!columnLayout(
                      contents: {
                        a!dropdownField(
                          label: "Region",
                          labelPosition: "ABOVE",
                          placeholder: "--- Select a Value ---",
                          choiceLabels: reject(fn!isnull,local!allRegion),
                          choiceValues: reject(fn!isnull,local!allRegion),
                          value:fv!item.Region,
                          saveInto: fv!item.Region,
                          searchDisplay: "AUTO",
                          validations: {}
                        )
                      }
                    ),
                    a!columnLayout(
                      contents: {
                        a!dropdownField(
                          label: "Manager Role",
                          labelPosition: "ABOVE",
                          placeholder: "--- Select a Value ---",
                          choiceLabels: reject(fn!isnull,local!allRole),
                          choiceValues: reject(fn!isnull,local!allRole),
                          value:fv!item.Manager_role,
                          saveInto: fv!item.Manager_role,
                          searchDisplay: "AUTO",
                          validations: {}
                        )
                      }
                    )
                  }
                ),
                a!columnsLayout(
                  columns: {
                    a!columnLayout(
                      contents: {
                        a!textField(
                          label: "Telephone Number",
                          labelPosition: "ABOVE",
                          value:fv!item.Telephone_number,
                          saveInto:fv!item.Telephone_number,
                          refreshAfter: "UNFOCUS",
                          validations: if( len(fv!item.Telephone_number) <> 11, "phone number should be 11 digits", null )
                        )
                      }
                    ),
                    a!columnLayout(
                      contents: {
                        a!textField(
                          label: "CE_LEVEL",
                          labelPosition: "ABOVE",
                          value:fv!item.CE_LEVEL,
                          saveInto: {fv!item.CE_LEVEL},
                          refreshAfter: "UNFOCUS",
                          validations: {}
                        )
                      }
                    ),
                    a!columnLayout(
                      contents: {
                        a!dropdownField(
                          label: "Active",
                          labelPosition: "ABOVE",
                          placeholder: "--- Select a Value ---",
                          choiceLabels: {0,1},
                          choiceValues: {0,1},
                          value:fv!item.Active,
                          saveInto: {fv!item.Active},
                          validations: {}
                        )
                      }
                    ),
                    a!columnLayout(
                      contents: {
                        a!dropdownField(
                          label: "Language",
                          labelPosition: "ABOVE",
                          placeholder: "--- Select a Value ---",
                          choiceLabels: reject(fn!isnull,local!allLanguage),
                          choiceValues: reject(fn!isnull,local!allLanguage),
                          value:fv!item.Language,
                          saveInto: {fv!item.Language},
                          searchDisplay: "AUTO",
                          validations: {}
                        )
                      }
                    )
                  }
                ),
                a!textField(
                  label: "Exceptional Case License Library View Right",
                  labelPosition: "ABOVE",
                  value:fv!item.Exceptional_case_library_view_right,
                  saveInto: fv!item.Exceptional_case_library_view_right,
                  refreshAfter: "UNFOCUS",
                  validations: {}
                ),
                a!buttonLayout(
                  primaryButtons: {
                    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),
                          }
                        )
                      },
                      submit: true,
                      style: "PRIMARY"
                    )
                  }
                ),
                a!gridField(
                  label: "Read-only Grid",
                  labelPosition: "ABOVE",
                  data: a!queryEntity(
                    entity: cons!KONE_Development_userinputsheet_Constant,
                    query: a!query(
                      selection: a!querySelection(
                        columns: {
                          a!queryColumn(field: "KONE_user_name"),
                          a!queryColumn(field:"FIRST_NAME"),
                          a!queryColumn(field: "LAST_NAME"),
                          a!queryColumn(field:"Email"),
                          a!queryColumn(field:"Role"),
                          a!queryColumn(field:"Branch"),
                          a!queryColumn(field:"Region"),
                          a!queryColumn(field:"Manager_role"),
                          a!queryColumn(field:"Telephone_number"),
                          a!queryColumn(field:"CE_LEVEL"),
                          a!queryColumn(field:"Active"),
                          a!queryColumn(field:"Language"),
                          a!queryColumn(field:"Exceptional_case_library_view_right"),
                          a!queryColumn(field:"updateTime")
                        }
                      ),
                      logicalExpression: a!queryLogicalExpression(
                        operator: "AND",
                        filters: {
                          a!queryFilter(
                            field: "KONE_user_name",
                            operator: "=",
                            value: local!searchValue,
                          ),
    
                        },
                        ignoreFiltersWithEmptyValues: true
                      ),
                      pagingInfo: fv!pagingInfo
                    ),
                    fetchTotalCount: true
                  ),
                  columns: {
                    a!gridColumn(
                      label: "KONE_user_name",
                      sortField: "KONE_user_name",
                      value: fv!row.KONE_user_name
                    ),
                    a!gridColumn(
                      label: "First Name",
                      value:fv!row.FIRST_NAME,
                    ),
                    a!gridColumn(
                      label: "Last Name",
                      sortField: "LAST_NAME",
                      value: fv!row.LAST_NAME,
                    ),
                    a!gridColumn(
                      label: "Role",
                      sortField: "Role",
                      value:fv!row.Role
                    ),
                    a!gridColumn(
                      label: "Email",
                      sortField: "Email",
                      value:fv!row.Email
                    ),
                    a!gridColumn(
                      label: "Active",
                      sortField: "Active",
                      value:fv!row.Active
                    ),
                    a!gridColumn(
                      label: "updateTime",
                      sortField: "updateTime",
                      value:fv!row.updateTime,
                    ),
                  },
                  pagesize: 5,
                  initialsorts: a!sortInfo(
                    field: "updateTime",
                    ascending: false()
                  )
                )
                }
                ,{})
                ,{})
                ,{})
              )
            )
          )
          ),
        }
      )
    )
    

    the problem appear around row:510 to row:730. I tried two ways of update, one way is shows up everything and I can update it directly, another is update username by searching then it can update the specific one which appears such annoy problem.

  • It's really hard for us to know where to look in 200 lines of code. Can you try to comment out small parts at a time to isolate what is causing the issue (i.e. which save is causing the problem)?

  • I don't know, during those two hundred lines of application,whenever i change something from one text blank and to switch to the next blank, this error report right after i switch.

  • By the way, you have good lecture, but i do think majority of material could be abbreviate to shorter one, and leave more section on real project practice teaching.

  • I solved it! I should take the second forEach loop items as local!rule which i set in the header but not the rule!KONE_Development_.. in the items definition.

  • By the way,do you have any link discuss about the process model? I want let the interfaces interact between each other by link or button click in it and jump to the different interface.

Reply Children