My Stuff
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
-
Re: SuiteQL: date field "is not on or before three days ago"
Well, the question is answered, but the answer is effectively no. I have a RESTlet that does the same thing and runs in 1.4 seconds. Opening an Analytics Dataset with the same data in the UI takes ab…1 -
Re: Join assembly item to work order query (SuiteQL)
This works: SELECT tranid, id from transaction WHERE recordtype = 'workorder' AND custbody_sea_rundate >= '8/3/2024' It doesn't like the LIMIT the way you wrote it. This a…1 -
Re: SuiteScript: File attachments and the File Cabinet
Not sure how I missed this before: search.create({ type: "transaction", filters: [ ["trandate","within","9/1/2020","8/31/2022"], "AND", [&q…1 -
Re: Adding a User Note to a Sales Order via scheduled script, looking for code snippet
fwiw.. adds a user note on a custom record.. function myNote(id,title,note) { log.debug('huNote', JSON.stringify({id: id, title: title, note: note})); var CUSTOMRECORD_MY = 87; var NOTETYPE…1
