Clarification on a!writeToDataStoreEntity

can you please check the input of wrtieToDataStore Entity, wheather the input is having all 5 cloumns data before inserting the database ?

The intention is to update the data , not insert new records. I have the primary key and the additional 2 fields that are present in the grid columns.

Yeah, correct i understood, just want to if check the variable is having primary key value before reaching WriteToDataStore Entity (after submiting the form or how you are updating the data base from the process model or from SAIL Interface itself)

if possible could you attach the code here.

please find the code below
= load(
local!pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: - 1
),
local!data: a!queryEntity(
entity: cons!MY_DB_ENTITY,
query: a!query(
selection: a!querySelection(
columns: {
a!queryColumn(
field: "expense_id",
alias: "expense_id"
),
a!queryColumn(
field: "expenseItem",
alias: "expenseItem"
),
a!queryColumn(
field: "expenseType",
alias: "expenseType"
)
}
),
pagingInfo: local!pagingInfo
)
),
a!dashboardLayout(
contents: {
a!buttonArrayLayout(
buttons: a!buttonWidget(
label: "Save",
saveInto: {
a!writeToDataStoreEntity(
cons!MY_DB_ENTITY,
local!data.data
)
}
)
),
a!gridLayout(
label: "Label",
labelPosition: "ABOVE",
headerCells: {
a!gridLayoutHeaderCell(
label: "Header1",
showWhen: false
),
a!gridLayoutHeaderCell(
label: "Header2"
),
a!gridLayoutHeaderCell(
label: "Header3"
)
},
columnConfigs: {},
rows: a!forEach(
items: local!data,
expression: {
a!gridRowLayout(
id: fv!item.expense_id,
contents: {
a!textField(
label: "expitem",
value: fv!item.expense_id,
saveInto: fv!item.expense_id,
showWhen: false
),
a!textField(
label: "expitem1",
value: fv!item.expenseItem,
saveInto: fv!item.expenseItem
),
a!textField(
label: "expType",
value: fv!item.expenseType,
saveInto: fv!item.expenseType
)
}
)
}
),
selectionSaveInto: {},
validations: {},
shadeAlternateRows: true
)
}
)
)

for me the above code is working perfectly we are on 17.4 hotfix A

load(
local!pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: - 1
),
local!data: a!queryEntity(
entity: cons!MK_DSE_QUALIFICATION,
query: a!query(
selection: {
a!querySelection(
columns: {
a!queryColumn(
field: "skillName"
),
a!queryColumn(
field: "certifiedOn"
),
a!queryColumn(
field: "employeeID"
)
}
)
},
pagingInfo: local!pagingInfo
)
),
a!dashboardLayout(
contents: {
a!buttonArrayLayout(
buttons: a!buttonWidget(
label: "Save",
saveInto: {
a!writeToDataStoreEntity(
cons!MK_DSE_QUALIFICATION,
local!data.data
)
}
)
),
a!gridLayout(
label: local!data.data,
labelPosition: "ABOVE",
headerCells: {
a!gridLayoutHeaderCell(
label: "Header1",
showWhen: false()
),
a!gridLayoutHeaderCell(
label: "Header2"
),
a!gridLayoutHeaderCell(
label: "Header3"
)
},
columnConfigs: {},
rows: a!forEach(
items: local!data,
expression: {
a!gridRowLayout(
id: fv!item.expense_id,
contents: {
a!textField(
label: "expitem",
value: fv!item.skillName,
showWhen: false(),
saveInto: fv!item.skillName
),
a!textField(
label: "expitem1",
value: fv!item.employeeID,
saveInto: fv!item.employeeID
),
a!textField(
label: "expType",
value: fv!item.certifiedOn,
saveInto: fv!item.certifiedOn
)
}
)
}
),
selectionSaveInto: {},
validations: {},
shadeAlternateRows: true
)
}
)
)


Above code snippet is working for me , when i click on button it's updating the values

load(
local!pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: - 1
),
local!data: a!queryEntity(
entity: cons!MK_DSE_QUALIFICATION,
query: a!query(
selection: {
a!querySelection(
columns: {
a!queryColumn(
field: "skillName"
),
a!queryColumn(
field: "certifiedOn"
),
a!queryColumn(
field: "employeeID"
)
}
)
},
pagingInfo: local!pagingInfo
)
),
a!dashboardLayout(
contents: {
a!buttonArrayLayout(
buttons: a!buttonWidget(
label: "Save",
saveInto: {
a!writeToDataStoreEntity(
cons!MK_DSE_QUALIFICATION,
local!data.data
)
}
)
),
a!gridLayout(
label: local!data.data,
labelPosition: "ABOVE",
headerCells: {
a!gridLayoutHeaderCell(
label: "Header1",
showWhen: false()
),
a!gridLayoutHeaderCell(
label: "Header2"
),
a!gridLayoutHeaderCell(
label: "Header3"
)
},
columnConfigs: {},
rows: a!forEach(
items: local!data,
expression: {
a!gridRowLayout(
id: fv!item.expense_id,
contents: {
a!textField(
label: "expitem",
value: fv!item.skillName,
showWhen: false(),
saveInto: fv!item.skillName
),
a!textField(
label: "expitem1",
value: fv!item.employeeID,
saveInto: fv!item.employeeID
),
a!textField(
label: "expType",
value: fv!item.certifiedOn,
saveInto: fv!item.certifiedOn
)
}
)
}
),
selectionSaveInto: {},
validations: {},
shadeAlternateRows: true
)
}
)
)


Above code snippet is working for me , when i click on button it's updating the values

Are you sure it is not affecting the existing values in the table for other columns ?

Hi chandolum, How many columns are there in your CDT? only three ?

The above code will work and will update NULL as default to the fields defined as Integer and have been mentioned in MySQL to allow Null. The key is to capture the unique identifier to update the rows back else it will insert additional rows to the table. Hope that helps. And for the record I tried that on V17.4