Search to retrieve the DT orders whose DT status changed on the previous day.

try {
                let salesorderSearchObj = search.create({
                    type: "salesorder",
                    filters:
                        [
                            ["type", "anyof", "SalesOrd"],
                            "AND",
                            ["linesystemnotes.date", "on", "yesterday"],
                            "AND",
                            ["linesystemnotes.field", "anyof", "CUSTCOL_DT_STATUS"],
                            "AND",
                            ["mainline", "is", "F"],
                            "AND",
                            ["custcol_dt_order", "isnotempty", ""]
                          
                        ],
                    columns:
                        [
                            search.createColumn({
                                name: "custcol_dt_order",
                                summary: "GROUP",
                                label: "DT Order"
                            }),
                            search.createColumn({
                                name: "tranid",
                                summary: "GROUP",
                                label: "Document Number"
                            }),
                            search.createColumn({
                                name: "internalid",
                                summary: "GROUP",
                                label: "Internal ID"
                            }),
                            search.createColumn({
                                name: "custcol_dt_acct",
                                summary: "GROUP",
                                label: "DT Account"
                            })
                        ]
                });
                let searchResultCount = salesorderSearchObj.runPaged().count;
                if (searchResultCount > 0) {
                    return salesorderSearchObj;
                }
                else {
                    return [];
                }
            }
            catch (e) {
                log.error("Error@getInputData", e);

                return [];
            }

        }

Leave a comment

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