Duplicate Remove in data base

Hi All,

please tell me how to not insert the duplicate data in database

code:-

{
a!localVariables(
/* This variable is used to persist the checkbox on selected items by holding the identifiers of the selected rows. */
local!selection,
local!Taglist: rule!tagslistexpression(),
local!items,
local!assignportfolioid,
local!allportfolio: rule!Portfoliomaster_selectAll(),
local!Temp,
local!selected,
local!Portfoliomaster:rule!portfoliomasterexp(),
/*local!portfolioid: max(local!Portfoliomaster.portfolioid),*/
/* This variable would be used to pass the full rows of data on the selected items out of this interface, such as to a process model. */
local!selectedEmployees,
local!filter: rule!customermasterexpression(tags: local!selectedEmployees.tagname),
{
a!richTextDisplayField(
label: "",
labelPosition: "COLLAPSED",
value: {
a!richTextHeader(
text: ""
)
}
),
a!columnsLayout(
columns: {
a!columnLayout(
contents: {
a!columnsLayout(
columns: {
a!columnLayout(
contents: {
a!richTextDisplayField(
labelPosition: "COLLAPSED",
value: {
a!richTextItem(
text: {
"Create Portfolios"
},
color: "STANDARD",
size: "MEDIUM_PLUS",
style: {
"STRONG"
}
)
}
),
a!columnsLayout(
columns: {
a!columnLayout(
contents: {
a!cardLayout(
contents: {
a!richTextDisplayField(
labelPosition: "COLLAPSED",
value: {
a!richTextItem(
text: {
"Select tags to divide your customer into portfolios"
},
color: "#999999"
),
char(10),
a!richTextItem(
text: {
"These selected tags will help us to divide customers into different portfolios on the basis of permutation combination"
},
color: "#999999"
)
}
),
a!gridField(
label: "",
/* Replace the dummy data with a query, rule, or function that returns a datasubset and uses fv!pagingInfo as the paging configuration. */
data: todatasubset(local!Taglist, fv!pagingInfo ),
columns: {
a!gridColumn(
label: "",
sortField: "tagname",
value: upper(fv!row.tagname),
width: "AUTO"

)
},
pageSize: 4,
selectable: true,
selectionStyle: "ROW_HIGHLIGHT",
selectionValue: local!selection,
selectionSaveInto: {
local!selection,
a!save(local!selectedEmployees, append(local!selectedEmployees, fv!selectedRows)),
a!save(local!selectedEmployees,difference(local!selectedEmployees, fv!deselectedRows))
/*a!save(local!selectedEmployees,local!selectedEmployees.GroupId : ri!groupid),*/
/*updatearray(local!selectedEmployees, 1, local!selectedEmployees.GroupId = ri!groupid)*/
}
),
a!checkboxField(
label: "",
labelPosition: "ABOVE",
choiceLabels: {"Include more tags in the list"},
choiceValues: {1},
saveInto: {},
validations: {}
)
},
height: "AUTO",
style: "NONE",
marginBelow: "STANDARD"
),
a!buttonArrayLayout(
buttons: {
a!buttonWidget(
label: "Create",
saveInto:{
/*a!forEach(items: local!filter,expression:a!save(local!items, append(local!items,{customerid: local!filter.customernumber[fv!index], portfolioname: local!filter.value[fv!index]}))),*/
a!forEach(items: local!filter,expression:a!save(local!items, append(local!items,{customerid: local!filter.customernumber[fv!index], tag: local!filter.tag.tagname[fv!index], portfolioname: local!filter.value[fv!index], portfolioid: local!filter.customerid[fv!index], tagid: local!filter.tag.tagid[fv!index]}))),
/*a!forEach(items: local!Taglist,expression:a!save(local!assignportfolioid, append(local!assignportfolioid,{tagid: local!Taglist.tagid[fv!index], tag: local!Taglist.tag[fv!index]}))),*/
/*a!save(a!forEach(items: local!filter,expression:a!save(local!items, app
end(local!items,{customerid: local!filter.customernumber[fv!index], tag: local!filter.tag.tagname[fv!index], portfolioname: local!filter.value[fv!index], portfolioid: local!filter.customerid[fv!index], tagid: local!filter.tag.tagid[fv!index]})))),*/
/*a!save(a!forEach(items: local!selectedEmployees,expression: fv!index),a!save(local!selectedEmployees.GroupId,ri!groupid)),*/
a!writeToDataStoreEntity(
dataStoreEntity: cons!portfoliomasterorg,
valueToStore: local!items
)
},
style: "NORMAL"
)
},
align: "END"
)
},
width: "WIDE_PLUS"
)
}
)
},
width: "WIDE_PLUS"
)
}
)
}
)
}
)
}
)
}

thank you 

  Discussion posts and replies are publicly visible

Parents
  • saveInto:{
    a!forEach(items: local!filter,expression:a!save(local!items, append(local!items,{customerid: local!filter.customernumber[fv!index], tag: local!filter.tag.tagname[fv!index], portfolioname: local!filter.value[fv!index], portfolioid: local!filter.customerid[fv!index], tagid: local!filter.tag.tagid[fv!index]}))),


    a!writeToDataStoreEntity(
    dataStoreEntity: cons!portfoliomasterorg,
    valueToStore: local!items
    )

    in the above code i am writing the data to DB

Reply
  • saveInto:{
    a!forEach(items: local!filter,expression:a!save(local!items, append(local!items,{customerid: local!filter.customernumber[fv!index], tag: local!filter.tag.tagname[fv!index], portfolioname: local!filter.value[fv!index], portfolioid: local!filter.customerid[fv!index], tagid: local!filter.tag.tagid[fv!index]}))),


    a!writeToDataStoreEntity(
    dataStoreEntity: cons!portfoliomasterorg,
    valueToStore: local!items
    )

    in the above code i am writing the data to DB

Children
No Data