QueryTask.submit()

Note:

The content in this help topic pertains to SuiteScript 2.0.

Method Description

Submits the query task for asynchronous processing.

This method returns a unique ID for the query task. When the submission is successful, this method adds the script IDs of any dependent tasks (added using QueryTask.addInboundDependency(options)) to the QueryTask.inboundDependencies property.

Use the task.QueryTaskStatus object to view the status of a submitted query task. The task.checkStatus(options) method returns a task.QueryTaskStatus object when you specify a task ID that represents a query task.

Returns

string

Supported Script Types

Server scripts

For more information, see SuiteScript 2.x Script Types.

Governance

100 units

Module

N/task Module

Parent Object

task.QueryTask

Sibling Object Members

QueryTask Object Members

Since

2020.2

Errors

Error Code	Thrown If
`ASYNC_QUERY_DEPENDENCY_MR_ALREADY_SUBMITTED`	A dependent map/reduce script task is already submitted and is not complete.
`ASYNC_QUERY_DEPENDENCY_MR_INCORRECT_STATUS`	The status of the script deployment record for the specified dependent map/reduce script task has a value other than “Not Scheduled”.
`ASYNC_QUERY_DEPENDENCY_SS_ALREADY_SUBMITTED`	A dependent scheduled script task is already submitted and is not complete.
`ASYNC_QUERY_DEPENDENCY_SS_INCORRECT_STATUS`	The status of the script deployment record for the specified dependent scheduled script task has a value other than “Not Scheduled”.
`ASYNC_QUERY_DEPLOYMENT_FOR_DEPENDENCY`	A script deployment record for the specified dependent script task is not available for one of the following reasons: A script deployment record was not specified when the dependent task was created, and automatic lookup for an available script deployment record failed. The script deployment record specified when the dependent task was created is not found.
`ASYNC_QUERY_MULTIPLE_DEPENDENCIES`	The same dependent task is passed to this method more than one time.
`ASYNC_QUERY_QUERY_ID_NOT_FOUND`	A query task with the specified script ID is not found.
`ASYNC_QUERY_SCRIPT_ID_NOT_FOUND`	The specified dependent task is not found.
`CANNOT_RESUBMIT_SUBMITTED_ASYNC_QUERY_TASK`	The query task was already submitted and completed successfully.
`FAILED_TO_SUBMIT_JOB_REQUEST_1`	The query task cannot be submitted due to an unexpected error.
`MUST_IDENTIFY_A_FILE`	The QueryTask.filePath property specifies a folder and not a file.
`SSS_MISSING_REQD_ARGUMENT`	A required property is not specified.
`THAT_RECORD_DOES_NOT_EXIST`	The QueryTask.fileId property or QueryTask.filePath property references a file that does not exist.
`YOU_DO_NOT_HAVE_ACCESS_TO_THE_MEDIA_ITEM_YOU_SELECTED`	You do not have permission to access the file specified by the QueryTask.fileId property or QueryTask.filePath property.

Error Code

Thrown If

ASYNC_QUERY_DEPENDENCY_MR_ALREADY_SUBMITTED

A dependent map/reduce script task is already submitted and is not complete.

ASYNC_QUERY_DEPENDENCY_MR_INCORRECT_STATUS

The status of the script deployment record for the specified dependent map/reduce script task has a value other than “Not Scheduled”.

ASYNC_QUERY_DEPENDENCY_SS_ALREADY_SUBMITTED

A dependent scheduled script task is already submitted and is not complete.

ASYNC_QUERY_DEPENDENCY_SS_INCORRECT_STATUS

The status of the script deployment record for the specified dependent scheduled script task has a value other than “Not Scheduled”.

ASYNC_QUERY_DEPLOYMENT_FOR_DEPENDENCY

A script deployment record for the specified dependent script task is not available for one of the following reasons:

A script deployment record was not specified when the dependent task was created, and automatic lookup for an available script deployment record failed.
The script deployment record specified when the dependent task was created is not found.

ASYNC_QUERY_MULTIPLE_DEPENDENCIES

The same dependent task is passed to this method more than one time.

ASYNC_QUERY_QUERY_ID_NOT_FOUND

A query task with the specified script ID is not found.

ASYNC_QUERY_SCRIPT_ID_NOT_FOUND

The specified dependent task is not found.

CANNOT_RESUBMIT_SUBMITTED_ASYNC_QUERY_TASK

The query task was already submitted and completed successfully.

FAILED_TO_SUBMIT_JOB_REQUEST_1

The query task cannot be submitted due to an unexpected error.

MUST_IDENTIFY_A_FILE

The QueryTask.filePath property specifies a folder and not a file.

SSS_MISSING_REQD_ARGUMENT

A required property is not specified.

THAT_RECORD_DOES_NOT_EXIST

The QueryTask.fileId property or QueryTask.filePath property references a file that does not exist.

YOU_DO_NOT_HAVE_ACCESS_TO_THE_MEDIA_ITEM_YOU_SELECTED

You do not have permission to access the file specified by the QueryTask.fileId property or QueryTask.filePath property.

Syntax

Important:

The following code sample shows the syntax for this member. It is not a functional example. For a complete script example, see N/task Module Script Samples.

            // Add additional code
...
var myQueryTask = task.create({
    taskType: task.TaskType.QUERY
}); 
// Submit the task
var myTaskId = myQueryTask.submit();

// Check the task status
var myStatus = task.checkStatus({
    taskId: myTaskId
});
...
// Add additional code

Errors

Syntax

Related Topics