Michael
02/14/2025, 6:00 PMjen
02/14/2025, 9:53 PMShahar Kaminski
02/14/2025, 10:04 PMMichael
02/14/2025, 11:01 PMrequire(['N/query', 'N/search']);
const query = require('N/query')
const search = require('N/search')
var creator = search.create({
type: "systemnote",
filters:
[
["recordid","equalto",240743],
"AND",
["type","is","T"]
],
columns:
[
"name",
]
}).run().getRange(0,1)[0].getValue("name")
const queryString = `SELECT TOP 1 name FROM systemnote WHERE recordid=240743 and type=1`;
log.debug("creatorQueryString", queryString);
const creatorSQL = query.runSuiteQL({
query: queryString,
});
battk
02/15/2025, 3:30 AM