This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Anyone got task.SuiteQLTask() to work and then check the status with the SuiteQLTaskStatus-object? I'm just getting Invalid_task_id when I try to read anything from the SuiteQLTaskStatus-object in the debugger using the task-id that I got from my submission of the SuiteQLTask

:man-facepalming: could it be that the task isn't available for me as a user in the debugger if the task was created by the - system - through a scheduled script?

If I submit the SuiteQLTask in the debugger instead of a separate scheduled script (same code). I can then retrieve the status of the task. (I'm logged in as administrator).

But status = 'FAILED' doesn't really help much when the SuiteQL works with the query-module