let transferorderSearchObj = search.create({
type: "transferorder",
filters:
[
["mainline", "is", "F"],
"AND",
["taxline", "is", "F"],
"AND",
["cogs", "is", "F"],
"AND",
["shipping", "is", "F"],
"AND",
["type", "anyof", "TrnfrOrd"],
"AND",
["internalid", "is", "123"],//internal id
"AND",
["applyingtransaction.type", "anyof", "ItemShip", "ItemRcpt"]
],
columns:
[
search.createColumn({ name: "tranid", label: "Document Number", summary: "MAX", }),
search.createColumn({ name: "statusref", label: "Status", summary: "MAX", }),
search.createColumn({ name: "internalid", label: "Internal ID", summary: "MAX", }),
search.createColumn({
name: "internalid",
join: "applyingTransaction",
summary: "GROUP",
label: "applyingTransactionId"
}),
search.createColumn({
name: "type",
join: "applyingTransaction",
summary: "MAX",
label: "applyingTransactionType"
}),
]
});