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