how to get the updated values form the cdt in editable grid ?

Can you explain in detail what you want to achieve? Nobody here is keen on trying to guess what you want.

i was working with the editable grid and the output in the update column has to be updated according to the action perform on grid but i was not getting the correct output . eg. even i'm deleting values other action's are also running 

You say "not getting the correct output". I do not know what you expect. Please describe what you expect, what you do to generate that output, and the result that you see.

/*Interface to fetch and display the data from MC_referenceData and MC_referenceDataAudit table.
Users will have access to Amend the Assign Group Name, Description,Updated By and Update in the MC_referenceData table.*/
a!localVariables(
local!readOnly: true,
/*Holds the reference data before being edited by the user*/
local!oldAssignGroupReferenceData: a!refreshVariable(
value: cast(
'type!{urn:uk:aviva:appian:mc}MC_referenceData?list',
rule!MC_getReferenceData(
pagingInfo: a!pagingInfo(startIndex: 1, batchSize: - 1),
type: cons!MC_ASSIGN_GROUP_TYPE/*dateFilter: today()*/

)
),
refreshOnVarChange: local!readOnly
),
/*Holds the updated data after being edited by the user.*/
local!GroupReferenceData: local!oldAssignGroupReferenceData,
local!OldGroupName: reject(
fn!isnull,
if(
toboolean(
local!oldAssignGroupReferenceData.isActive
) = true,
local!oldAssignGroupReferenceData.value,
null
)
),
local!newGroupName: reject(
fn!isnull,
if(
toboolean(local!GroupReferenceData.isActive) = true,
local!GroupReferenceData.value,
null
)
),
local!addGroup: false(),
local!deletedGroup,
local!comments,
local!deleteMessage: a!forEach(
items: local!deletedGroup,
expression: fv!item.value
) & " Group Name is deleted.",
local!updatedValues: {},
local!addedNewValues:{

a!forEach(
items:local!OldGroupName,
expression:if(
where(length(local!OldGroupName)<>length(local!OldGroupName)),
{},
local!newGroupName[fv!item]
)



)
},


a!boxLayout(
label: "Manage Group",
contents: {
/*Section for displaying the Group name which can be edited by the user.*/
a!sectionLayout(
/*label: "Following are the Group name.",*/
labelColor: "#008080",
contents: {
a!gridLayout(
headerCells: {
a!gridLayoutHeaderCell(label: "Group Id", align: "CENTER"),
a!gridLayoutHeaderCell(label: "Group Name", align: "CENTER"),
a!gridLayoutHeaderCell(label: "Is Active", align: "CENTER"),
a!gridLayoutHeaderCell(label: "Updated By", align: "CENTER"),
a!gridLayoutHeaderCell(label: "Updated On", align: "CENTER"),
a!gridLayoutHeaderCell(label: "End Date", align: "CENTER"),
a!gridLayoutHeaderCell(label: "")
},
columnConfigs: {
a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight: 2),
a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight: 2),
a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight: 1),
a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight: 1),
a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight: 1),
a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight: 1),
a!gridLayoutColumnConfig(width: "ICON")
},
rows: a!forEach(
items: local!GroupReferenceData,
expression: if(
fv!item.isActive,
a!gridRowLayout(
id: fv!index,
contents: {
a!textField(
label: " Group Id",
value: fv!item.refCode,
saveInto: fv!item.refCode,
required: false(),
readOnly: local!readOnly,
align: "CENTER"
),
a!textField(
label: "Group Name",
value: fv!item.value,
saveInto: fv!item.value,
required: true,
readOnly: local!readOnly,
align: "CENTER"
),
a!checkboxField(
label: "Is Active",
choiceLabels: { "" },
choiceValues: { true },
value: fv!item.isActive,
saveInto: fv!item.isActive,
disabled: local!readOnly,
align: "CENTER"
),
a!textField(
label: "Updated By",
value: fv!item.updatedBy,
saveInto: fv!item.updatedBy,
readOnly: true(),
align: "CENTER"
),
a!textField(
label: "Updated On",
value: fv!item.updatedOn,
saveInto: fv!item.updatedOn,
readOnly: true(),
align: "CENTER"
),
a!dateField(
label: "End Date",
value: fv!item.endDate,
saveInto: fv!item.endDate,
readOnly: local!readOnly,
align: "CENTER"
),
a!richTextDisplayField(
value: a!richTextIcon(
icon: "close",
altText: "delete " & fv!index,
caption: "Remove row",
link: a!dynamicLink(
value: fv!index,
saveInto: {
a!save(fv!item.isActive, false),
a!save(
local!deletedGroup,
append(local!deletedGroup, fv!item)
),
a!save(
local!GroupReferenceData,
remove(local!GroupReferenceData, save!value)
),
a!save(local!addGroup, false),
a!save(local!oldAssignGroupReferenceData,remove(local!oldAssignGroupReferenceData,save!value))
}
),
linkStyle: "STANDALONE",
showWhen: local!readOnly = false,
color: "NEGATIVE"
)
)
}
),
{}
)
),
addRowLink: a!dynamicLink(
label: "Add Group",
saveInto: {
a!save(local!addGroup, true),
a!save(
local!GroupReferenceData,
append(
local!GroupReferenceData,
'type!{urn:uk:aviva:appian:mc}MC_referenceData'(
refCode: null,
value: null,
description: null,
type: cons!MC_ASSIGN_GROUP_TYPE,
isActive: true(),
startDate: today(),
endDate: today(),
createdOn: now(),
createdBy: loggedInUser(),
updatedOn: now(),
updatedBy: loggedInUser()
)
)
)
},
showWhen: local!readOnly = false
)
),
a!paragraphField(
label: "Comments",
value: local!comments,
saveInto: local!comments,
characterLimit: 300,
showWhen: local!readOnly = false,
required: true
)
}
),
a!buttonArrayLayout(
buttons: {
a!buttonWidget(
label: cons!MC_BUTTON_EDIT,
saveInto: { a!save(local!readOnly, false),a!save(local!addGroup,false) },
style: "SECONDARY",
showWhen: local!readOnly = true
),
a!buttonWidget(
label: cons!SHARED_BUTTON_CANCEL,
saveInto: {
a!save(local!readOnly, true),
a!save(local!deletedGroup, null),
a!save(local!newGroupName, local!OldGroupName),
a!save(
local!GroupReferenceData,
local!oldAssignGroupReferenceData
),
a!save(local!addGroup, false)
},
style: "NORMAL",
showWhen: local!readOnly = false
),
a!buttonWidget(
label: "Update Group",
saveInto: {
a!writeToMultipleDataStoreEntities(
valuesToStore: {
a!entityData(
entity: cons!MC_DSE_REFERENCE_DATA,
data: {
local!GroupReferenceData,
a!forEach(
items: local!deletedGroup,
expression: 'type!{urn:uk:aviva:appian:mc}MC_referenceData'(
refId: fv!item.refId,
refCode: fv!item.refCode,
value: fv!item.value,
description: fv!item.description,
type: fv!item.type,
startDate: fv!item.startDate,
endDate: fv!item.endDate,
isActive: fv!item.isActive,
createdOn: fv!item.createdOn,
createdBy: fv!item.createdBy,
updatedOn: now(),
updatedBy: loggedInUser()
)
)
}
),
a!entityData(
entity: cons!MC_DSE_REFERENCE_DATA_AUDIT,
data: 'type!{urn:uk:aviva:appian:mc}MC_referenceDataAudit'(
refCode: cons!MC_INSURER_NAME_REF_CODE,
update: {
if(
and(rule!APN_isEmpty(local!OldGroupName),where(local!OldGroupName<>local!newGroupName)),
{},
"New Group Added: "& local!addedNewValues
),


if(and(rule!APN_isEmpty(local!deletedGroup)),{}," Deleted Message: "&local!deleteMessage)
},
description: (local!comments),
updatedBy: loggedInUser(),
updatedOn: now(),
type: cons!MC_ASSIGN_GROUP_TYPE
)
)
},
onSuccess: "Group name updated successfully."
),
a!save(local!readOnly, true),
a!save(local!comments, null),
a!save(local!deletedGroup, null)
},
style: "PRIMARY",
showWhen: local!readOnly = false,
validate: true
)
},
align: "END"
),
a!sectionLayout(
label: "Audit Details",
labelColor: "#008080",
contents: {
a!gridField(
data: rule!MC_getReferenceDataAudit(
pagingInfo: a!pagingInfo(startIndex: 1, batchSize: - 1),
refCode: cons!MC_INSURER_NAME_REF_CODE,
type: cons!MC_ASSIGN_GROUP_TYPE
),
columns: {
a!gridColumn(
label: "#Id",
sortField: "id",
value: fv!row.id,
align: "CENTER"
),
a!gridColumn(
label: "Updates",
sortField: "update",
value: fv!row.update,
align: "CENTER"
),
a!gridColumn(
label: "User Comment",
sortField: "description",
value: fv!row.description,
align: "CENTER"
),
a!gridColumn(
label: "Updated By",
sortField: "updatedBy",
value: fv!row.updatedBy,
align: "CENTER"
),
a!gridColumn(
label: "Updated On",
sortField: "updatedOn",
value: fv!row.updatedon,
align: "CENTER"
)
},
pageSize: 5,
initialSorts: a!sortInfo(field: "updatedOn", ascending: false),
spacing: "DENSE",
rowHeader: 1,
refreshOnVarChange: local!readOnly
)
},
isCollapsible: true,
isInitiallyCollapsed: false,
marginBelow: "STANDARD"
)
},
style: "#008080",
shape: "ROUNDED"
)
)

in the audit details log update column for the adding operation it should show only new added value but it's showing all the values which are there in the llocal!newGroupNmae Variables

/*Interface to fetch and display the data from MC_referenceData and MC_referenceDataAudit table.
Users will have access to Amend the Assign Group Name, Description,Updated By and Update in the MC_referenceData table.*/
a!localVariables(
local!readOnly: true,
/*Holds the reference data before being edited by the user*/
local!oldAssignGroupReferenceData: a!refreshVariable(
value: cast(
'type!{urn:uk:aviva:appian:mc}MC_referenceData?list',
rule!MC_getReferenceData(
pagingInfo: a!pagingInfo(startIndex: 1, batchSize: - 1),
type: cons!MC_ASSIGN_GROUP_TYPE/*dateFilter: today()*/

)
),
refreshOnVarChange: local!readOnly
),
/*Holds the updated data after being edited by the user.*/
local!GroupReferenceData: local!oldAssignGroupReferenceData,
local!OldGroupName: reject(
fn!isnull,
if(
toboolean(
local!oldAssignGroupReferenceData.isActive
) = true,
local!oldAssignGroupReferenceData.value,
null
)
),
local!newGroupName: reject(
fn!isnull,
if(
toboolean(local!GroupReferenceData.isActive) = true,
local!GroupReferenceData.value,
null
)
),
local!addGroup: false(),
local!deletedGroup,
local!comments,
local!deleteMessage: a!forEach(
items: local!deletedGroup,
expression: fv!item.value
) & " Group Name is deleted.",
local!updatedValues: {},
local!addedNewValues:{

a!forEach(
items:local!OldGroupName,
expression:if(
where(length(local!OldGroupName)<>length(local!OldGroupName)),
{},
local!newGroupName[fv!item]
)



)
},


a!boxLayout(
label: "Manage Group",
contents: {
/*Section for displaying the Group name which can be edited by the user.*/
a!sectionLayout(
/*label: "Following are the Group name.",*/
labelColor: "#008080",
contents: {
a!gridLayout(
headerCells: {
a!gridLayoutHeaderCell(label: "Group Id", align: "CENTER"),
a!gridLayoutHeaderCell(label: "Group Name", align: "CENTER"),
a!gridLayoutHeaderCell(label: "Is Active", align: "CENTER"),
a!gridLayoutHeaderCell(label: "Updated By", align: "CENTER"),
a!gridLayoutHeaderCell(label: "Updated On", align: "CENTER"),
a!gridLayoutHeaderCell(label: "End Date", align: "CENTER"),
a!gridLayoutHeaderCell(label: "")
},
columnConfigs: {
a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight: 2),
a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight: 2),
a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight: 1),
a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight: 1),
a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight: 1),
a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight: 1),
a!gridLayoutColumnConfig(width: "ICON")
},
rows: a!forEach(
items: local!GroupReferenceData,
expression: if(
fv!item.isActive,
a!gridRowLayout(
id: fv!index,
contents: {
a!textField(
label: " Group Id",
value: fv!item.refCode,
saveInto: fv!item.refCode,
required: false(),
readOnly: local!readOnly,
align: "CENTER"
),
a!textField(
label: "Group Name",
value: fv!item.value,
saveInto: fv!item.value,
required: true,
readOnly: local!readOnly,
align: "CENTER"
),
a!checkboxField(
label: "Is Active",
choiceLabels: { "" },
choiceValues: { true },
value: fv!item.isActive,
saveInto: fv!item.isActive,
disabled: local!readOnly,
align: "CENTER"
),
a!textField(
label: "Updated By",
value: fv!item.updatedBy,
saveInto: fv!item.updatedBy,
readOnly: true(),
align: "CENTER"
),
a!textField(
label: "Updated On",
value: fv!item.updatedOn,
saveInto: fv!item.updatedOn,
readOnly: true(),
align: "CENTER"
),
a!dateField(
label: "End Date",
value: fv!item.endDate,
saveInto: fv!item.endDate,
readOnly: local!readOnly,
align: "CENTER"
),
a!richTextDisplayField(
value: a!richTextIcon(
icon: "close",
altText: "delete " & fv!index,
caption: "Remove row",
link: a!dynamicLink(
value: fv!index,
saveInto: {
a!save(fv!item.isActive, false),
a!save(
local!deletedGroup,
append(local!deletedGroup, fv!item)
),
a!save(
local!GroupReferenceData,
remove(local!GroupReferenceData, save!value)
),
a!save(local!addGroup, false),
a!save(local!oldAssignGroupReferenceData,remove(local!oldAssignGroupReferenceData,save!value))
}
),
linkStyle: "STANDALONE",
showWhen: local!readOnly = false,
color: "NEGATIVE"
)
)
}
),
{}
)
),
addRowLink: a!dynamicLink(
label: "Add Group",
saveInto: {
a!save(local!addGroup, true),
a!save(
local!GroupReferenceData,
append(
local!GroupReferenceData,
'type!{urn:uk:aviva:appian:mc}MC_referenceData'(
refCode: null,
value: null,
description: null,
type: cons!MC_ASSIGN_GROUP_TYPE,
isActive: true(),
startDate: today(),
endDate: today(),
createdOn: now(),
createdBy: loggedInUser(),
updatedOn: now(),
updatedBy: loggedInUser()
)
)
)
},
showWhen: local!readOnly = false
)
),
a!paragraphField(
label: "Comments",
value: local!comments,
saveInto: local!comments,
characterLimit: 300,
showWhen: local!readOnly = false,
required: true
)
}
),
a!buttonArrayLayout(
buttons: {
a!buttonWidget(
label: cons!MC_BUTTON_EDIT,
saveInto: { a!save(local!readOnly, false),a!save(local!addGroup,false) },
style: "SECONDARY",
showWhen: local!readOnly = true
),
a!buttonWidget(
label: cons!SHARED_BUTTON_CANCEL,
saveInto: {
a!save(local!readOnly, true),
a!save(local!deletedGroup, null),
a!save(local!newGroupName, local!OldGroupName),
a!save(
local!GroupReferenceData,
local!oldAssignGroupReferenceData
),
a!save(local!addGroup, false)
},
style: "NORMAL",
showWhen: local!readOnly = false
),
a!buttonWidget(
label: "Update Group",
saveInto: {
a!writeToMultipleDataStoreEntities(
valuesToStore: {
a!entityData(
entity: cons!MC_DSE_REFERENCE_DATA,
data: {
local!GroupReferenceData,
a!forEach(
items: local!deletedGroup,
expression: 'type!{urn:uk:aviva:appian:mc}MC_referenceData'(
refId: fv!item.refId,
refCode: fv!item.refCode,
value: fv!item.value,
description: fv!item.description,
type: fv!item.type,
startDate: fv!item.startDate,
endDate: fv!item.endDate,
isActive: fv!item.isActive,
createdOn: fv!item.createdOn,
createdBy: fv!item.createdBy,
updatedOn: now(),
updatedBy: loggedInUser()
)
)
}
),
a!entityData(
entity: cons!MC_DSE_REFERENCE_DATA_AUDIT,
data: 'type!{urn:uk:aviva:appian:mc}MC_referenceDataAudit'(
refCode: cons!MC_INSURER_NAME_REF_CODE,
update: {
if(
and(rule!APN_isEmpty(local!OldGroupName),where(local!OldGroupName<>local!newGroupName)),
{},
"New Group Added: "& local!addedNewValues
),


if(and(rule!APN_isEmpty(local!deletedGroup)),{}," Deleted Message: "&local!deleteMessage)
},
description: (local!comments),
updatedBy: loggedInUser(),
updatedOn: now(),
type: cons!MC_ASSIGN_GROUP_TYPE
)
)
},
onSuccess: "Group name updated successfully."
),
a!save(local!readOnly, true),
a!save(local!comments, null),
a!save(local!deletedGroup, null)
},
style: "PRIMARY",
showWhen: local!readOnly = false,
validate: true
)
},
align: "END"
),
a!sectionLayout(
label: "Audit Details",
labelColor: "#008080",
contents: {
a!gridField(
data: rule!MC_getReferenceDataAudit(
pagingInfo: a!pagingInfo(startIndex: 1, batchSize: - 1),
refCode: cons!MC_INSURER_NAME_REF_CODE,
type: cons!MC_ASSIGN_GROUP_TYPE
),
columns: {
a!gridColumn(
label: "#Id",
sortField: "id",
value: fv!row.id,
align: "CENTER"
),
a!gridColumn(
label: "Updates",
sortField: "update",
value: fv!row.update,
align: "CENTER"
),
a!gridColumn(
label: "User Comment",
sortField: "description",
value: fv!row.description,
align: "CENTER"
),
a!gridColumn(
label: "Updated By",
sortField: "updatedBy",
value: fv!row.updatedBy,
align: "CENTER"
),
a!gridColumn(
label: "Updated On",
sortField: "updatedOn",
value: fv!row.updatedon,
align: "CENTER"
)
},
pageSize: 5,
initialSorts: a!sortInfo(field: "updatedOn", ascending: false),
spacing: "DENSE",
rowHeader: 1,
refreshOnVarChange: local!readOnly
)
},
isCollapsible: true,
isInitiallyCollapsed: false,
marginBelow: "STANDARD"
)
},
style: "#008080",
shape: "ROUNDED"
)
)

in the audit details log update column for the adding operation it should show only new added value but it's showing all the values which are there in the llocal!newGroupNmae Variables

This line:

and(rule!APN_isEmpty(local!OldGroupName),where(local!OldGroupName<>local!newGroupName)),

looks suspicious. What logic do you want to express?

Please modify your post and use this.