let searchFilters = projectcheck
? [
[“custrecord_jj_project_name”, “anyof”, cusName],
“AND”,
[“custrecord_jj_itemname”, “anyof”, itemName],
“AND”,
[“isinactive”, “is”, “F”]
]
: [
[“custrecord_jj_customername”, “anyof”, cusName],
“AND”,
[“custrecord_jj_itemname”, “anyof”, itemName],
“AND”,
[“isinactive”, “is”, “F”],
“AND”,
[“custrecord_jj_project_name”,“anyof”,“@NONE@”]
];
let customrecord_jj_contract_record_ahap1065SearchObj = search.create({
type: “customrecord_jj_contract_record_ahap1065”,
filters: searchFilters,
columns:
[
search.createColumn({ name: “internalid”, label: “Internal ID” }),
search.createColumn({ name: “custrecord_jj_customername”, label: “Customer Name” }),
search.createColumn({ name: “custrecord_jj_itemname”, label: “Item Name” }),
search.createColumn({ name: “custrecord_jj_startdate”, label: “Contract Period Start Date” }),
search.createColumn({ name: “custrecord_jj_enddate”, label: “Contract Period End Date” }),
search.createColumn({ name: “custrecord_jj_salescost”, label: “Sales Invoice Cost” }),
search.createColumn({
name: “lastmodified”,
sort: search.Sort.DESC,
label: “Last Modified”
})
]
});