battk
12/31/2019, 8:45 AMNickSuite
12/31/2019, 8:52 AMvar itemSearch = search.load({
id: 'customsearch152'
});
itemSearch.filters.push(
search.createFilter({
name: 'trandate',
operator: 'within',
values: [d1, d2]
})
);NickSuite
12/31/2019, 8:52 AMbattk
12/31/2019, 8:54 AMNickSuite
12/31/2019, 8:55 AMNickSuite
12/31/2019, 8:56 AMNickSuite
12/31/2019, 8:56 AMNickSuite
12/31/2019, 8:59 AMbattk
12/31/2019, 9:08 AMbattk
12/31/2019, 9:08 AMNickSuite
12/31/2019, 9:24 AMNickSuite
12/31/2019, 9:25 AMbattk
12/31/2019, 9:26 AMrequire(["N/search", "N/format"], function(search, format) {
var tranSearch = search.create({ type: search.Type.TRANSACTION , filters: [ search.createFilter({
name: "trandate",
operator: "within",
values: [
format.format({
value: new Date("2019-01-01T08:00:00.000Z"),
type: format.Type.DATE
}),format.format({
value: new Date("2019-12-31T08:00:00.000Z"),
type: format.Type.DATE
})
]
})]});
var results = tranSearch.run().getRange(0, 1000);
log.debug("results", results.length);
});battk
12/31/2019, 9:27 AMbattk
12/31/2019, 9:27 AMNickSuite
12/31/2019, 9:27 AMNickSuite
12/31/2019, 9:30 AMbattk
12/31/2019, 9:33 AMbattk
12/31/2019, 9:33 AMNickSuite
12/31/2019, 9:34 AMNickSuite
12/31/2019, 9:34 AMNickSuite
12/31/2019, 9:35 AMNickSuite
12/31/2019, 10:02 AM