Fetch file attachment internal ids of bill record using saved search.

function checkForParameter(parameter, parameterName) {
    if (parameter !== "" && parameter !== null && parameter !== undefined && parameter !== false && parameter !== "null" && parameter !== "undefined" && parameter !== " " && parameter !== 'false') {
        return true;
    } else {
        if (parameterName)
            return false;
    }
}

let vendorbillSearchObj = search.create({
    type: "vendorbill",
    filters:
        [
            ["type", "anyof", "VendBill"],
            "AND",
            ["internalid", "anyof", '<billIntId>'],
            "AND",
            ["mainline", "is", "T"]
        ],
    columns:
        [
            search.createColumn({
                name: "name",
                join: "file",
                label: "Name"
            }),
            search.createColumn({
                name: "internalid",
                join: "file",
                label: "Internal ID"
            }),
            search.createColumn({
                name: "documentsize",
                join: "file",
                label: "Size (KB)"
            })
        ]
});
vendorbillSearchObj.run().each(function (result) {
    // if vendor bill pdf exists, the corresponding internal id will bw assign to fieldId
    if (checkForParameter(result.getValue(vendorbillSearchObj.columns[0]))) {
        fileIds.push({ 'fileId': result.getValue(vendorbillSearchObj.columns[1]), 'size': result.getValue(vendorbillSearchObj.columns[2]) });
    }
    return true;
});
let vendorbillSearchObj = search.create({
    type: "vendorbill",
    filters:
        [
            ["type", "anyof", "VendBill"],
            "AND",
            ["internalid", "anyof", '<billIntId>'],
            "AND",
            ["mainline", "is", "T"]
        ],
    columns:
        [
            search.createColumn({
                name: "name",
                join: "file",
                label: "Name"
            }),
            search.createColumn({
                name: "internalid",
                join: "file",
                label: "Internal ID"
            }),
            search.createColumn({
                name: "documentsize",
                join: "file",
                label: "Size (KB)"
            })
        ]
});
vendorbillSearchObj.run().each(function (result) {
    // if vendor bill pdf exists, the corresponding internal id will bw assign to fieldId
    if (checkForParameter(result.getValue(vendorbillSearchObj.columns[0]))) {
        fileIds.push({ 'fileId': result.getValue(vendorbillSearchObj.columns[1]), 'size': result.getValue(vendorbillSearchObj.columns[2]) });
    }
    return true;
});

Leave a comment

Your email address will not be published. Required fields are marked *