Modules

filter

 

Objects/Functions

module (N/query)

SuiteScript 2.0

query.Type

query.Type.{|ACCOUNT,ACCOUNTING_BOOK,ACCOUNTING_CONTEXT,ACCOUNTING_PERIOD,ALLOCATION_METHOD,ALL_PARSER_PLUGIN,AMORTIZATION_SCHEDULE,AMORTIZATION_TEMPLATE,AUTHORIZATION_CONSENT,BILLING_CLASS,BILLING_RATE_CARD,BILLING_SCHEDULE,BILL_OF_DISTRIBUTION,BILL_RUN,BILL_RUN_SCHEDULE,BIN,BOM,BOM_REVISION,BOM_REVISION_COMPONENT,BUDGETCATEGORY,BUDGETS,BUDGET_EXCHANGE_RATE,BULK_PROC_SUBMISSION,BUNDLE_INSTALLATION_SCRIPT,BUNDLE_INSTALLATION_SCRIPT_DEPLOYMENT,BUSINESS_EVENTS_PROCESSING_HISTORY,CALENDAR_EVENT,CAMPAIGN_AUDIENCE,CAMPAIGN_CATEGORY,CAMPAIGN_CHANNEL,CAMPAIGN_EMAIL_ADDRESS,CAMPAIGN_EVENT,CAMPAIGN_FAMILY,CAMPAIGN_OFFER,CAMPAIGN_RESPONSE,CAMPAIGN_SEARCH_ENGINE,CAMPAIGN_SUBSCRIPTION,CAMPAIGN_TEMPLATE,CAMPAIGN_VERTICAL,CARDHOLDER_AUTHENTICATION,CARDHOLDER_AUTHENTICATION_EVENT,CATEGORY1099MISC,CHARGE,CHARGE_RULE,CHARGE_RUN,CHARGE_TYPE,CLASSIFICATION,CLIENT_SCRIPT,CLIENT_SCRIPT_DEPLOYMENT,COMPETITOR,CONSOLIDATED_EXCHANGE_RATE,CONSOLIDATED_RATE_ADJUSTOR_PLUGIN,CONTACT,CONTACT_CATEGORY,CONTACT_ROLE,CONTACT_SUBSIDIARY_RELATIONSHIP,COST_CATEGORY,COUPON_CODE,CURRENCY,CURRENCY_RATE,CUSTOMER,CUSTOMER_CATEGORY,CUSTOMER_MESSAGE,CUSTOMER_SEGMENT,CUSTOMER_SUBSIDIARY_RELATIONSHIP,CUSTOM_FIELD,CUSTOM_FIELD_2,CUSTOM_GL_PLUGIN,CUSTOM_LIST,CUSTOM_RECORD_ACTION_SCRIPT,CUSTOM_RECORD_TYPE,CUSTOM_SEGMENT,CUSTOM_TRANSACTION_TYPE,DATASET_BUILDER_PLUGIN,DELETED_RECORD,DEPARTMENT,DEVICE_ID,DISTRIBUTION_CATEGORY,DISTRIBUTION_NETWORK,DOMAIN,DUAL,EMAIL_CAPTURE_PLUGIN,EMAIL_TEMPLATE,EMPLOYEE,EMPLOYEE_LIST,EMPLOYEE_STATUS,EMPLOYEE_SUBSIDIARY_RELATIONSHIP,EMPLOYEE_TYPE,ENTITY,ENTITY_GROUP,ENTITY_SUBSIDIARY_RELATIONSHIP,EXPENSE_CATEGORY,EXPENSE_REPORT_POLICY,FAX_TEMPLATE,FILE,FISCAL_CALENDAR,FI_CONNECTIVITY_PLUGIN,FORECAST,FULFILLMENT_EXCEPTION_REASON,FULFILLMENT_REQUEST,F_I_PARSER_PLUGIN,GATEWAY_NOTIFICATION,GENERAL_ALLOCATION_SCHEDULE,GENERAL_TOKEN,GENERIC_RESOURCE,GENERIC_RESOURCE_SUBSIDIARY_RELATIONSHIP,GIFT_CERTIFICATE,GLOBAL_ACCOUNT_MAPPING,GLOBAL_INVENTORY_RELATIONSHIP,GL_LINES_AUDIT_LOG,GL_LINES_PLUGIN_REVISION,G_L_NUMBERING_SEQUENCE,IMPORTED_EMPLOYEE_EXPENSE,INBOUND_SHIPMENT,INCO_TERM,INVENTORY_COST_TEMPLATE,INVENTORY_NUMBER,INVENTORY_STATUS,INVT_ITEM_PRICE_HISTORY,ISSUE,ITEM,ITEM_ACCOUNT_MAPPING,ITEM_COLLECTION,ITEM_DEMAND_PLAN,ITEM_LOCATION_CONFIGURATION,ITEM_SEGMENT_INCLUDING_SYNTHETIC,ITEM_SUPPLY_PLAN,I_P_RESTRICTIONS,JOB,JOB_RESOURCE_ROLE,JOB_STATUS,JOB_TYPE,KNOWLEDGE_BASE,LOCATION,LOCATION_COSTING_GROUP,LOGIN_AUDIT,MAIL_TEMPLATE,MANUFACTURING_COMPONENT,MANUFACTURING_COST_TEMPLATE,MANUFACTURING_OPERATION_TASK,MANUFACTURING_ROUTING,MANUFACTURING_TRANSACTION,MAP_REDUCE_SCRIPT,MAP_REDUCE_SCRIPT_DEPLOYMENT,MASS_UPDATE_SCRIPT,MASS_UPDATE_SCRIPT_DEPLOYMENT,MEDIA_ITEM_FOLDER,MEM_DOC,MEM_DOC_TRANSACTION_TEMPLATE,MERCHANDISE_HIERARCHY_LEVEL,MERCHANDISE_HIERARCHY_NODE,MERCHANDISE_HIERARCHY_VERSION,MESSAGE,MFG_PLANNED_TIME,NEXUS,NOTE,ONLINE_CASE_FORM,ONLINE_FORM_TEMPLATE,ONLINE_LEAD_FORM,ORDER_ALLOCATION_STRATEGY,OTHER_NAME,OTHER_NAME_CATEGORY,OTHER_NAME_SUBSIDIARY_RELATIONSHIP,OUTBOUND_REQUEST,O_AUTH_TOKEN,PARTNER,PARTNER_SUBSIDIARY_RELATIONSHIP,PAYCHECK,PAYMENT_CARD,PAYMENT_CARD_SEARCH_RECORD,PAYMENT_CARD_TOKEN,PAYMENT_EVENT,PAYMENT_GATEWAY_PLUGIN,PAYMENT_INSTRUMENT,PAYMENT_METHOD,PAYMENT_PROCESSING_PROFILE,PAYMENT_RESULT_PREVIEW,PAYROLL_BATCH,PAYROLL_ITEM,PDF_TEMPLATE,PHONE_CALL,PLANNED_ORDER,PLANNED_STANDARD_COST,PLANNING_ITEM_CATEGORY,PLANNING_ITEM_GROUP,PLANNING_ITEM_GROUP_SOURCE,PLANNING_RULE_GROUP,PLATFORM_EXTENSION_PLUGIN,PLUG_IN_TYPE,PLUG_IN_TYPE_IMPL,PORTLET,PORTLET_DEPLOYMENT,PREDICTED_RISK_TRAIN_EVAL_HISTORY,PRICE_LEVEL,PRICING,PRICING_GROUP,PRICING_WITH_CUSTOMERS,PROJECT_BUDGET,PROJECT_EXPENSE_TYPE,PROJECT_FINANCIALS,PROJECT_SUBSIDIARY_RELATIONSHIP,PROJECT_TASK,PROJECT_TEMPLATE,PROJECT_TEMPLATE_SUBSIDIARY_RELATIONSHIP,PROMOTIONS_PLUGIN,PROMOTION_CODE,PUBLISHED_SAVED_SEARCH,QUANTITY_PRICING_SCHEDULE,QUOTA,RECENT_RECORD,RECORD_ACTION_SCRIPT_DEPLOYMENT,REDIRECT,RESOURCE_ALLOCATION,RESOURCE_GROUP,RESTLET,RESTLET_DEPLOYMENT,REV_REC_SCHEDULE,REV_REC_TEMPLATE,ROLE,SALES_INVOICED,SALES_ORDERED,SALES_TAX_ITEM,SCHEDULED_SCRIPT,SCHEDULED_SCRIPT_DEPLOYMENT,SCHEDULED_SCRIPT_INSTANCE,SCRIPT,SCRIPT_CUSTOM_RECORD_TYPE,SCRIPT_DEPLOYMENT,SCRIPT_NOTE,SCRIPT_RECORD_TYPE,SEARCH_CAMPAIGN,SENT_EMAIL,SHIPPING_PACKAGE,SHIPPING_PARTNERS_PLUGIN,SHIPPING_PARTNER_REGISTRATION,SHIP_ITEM,SHOPPING_CART,SITE_CATEGORY,SOLUTION,STANDARD_COST_VERSION,STATISTICAL_JOURNAL_ENTRY,STATISTICAL_SCHEDULE,STORE_PICKUP_FULFILLMENT,STORE_TAB,SUBLIST,SUBSIDIARY,SUBSIDIARY_SETTINGS,SUITELET,SUITELET_DEPLOYMENT,SUITE_SCRIPT_DETAIL,SUPPLY_CHAIN_SNAPSHOT,SUPPLY_CHAIN_SNAPSHOT_SIMULATION,SUPPLY_CHANGE_ORDER,SUPPLY_PLAN_DEFINITION,SUPPORT_CASE,SYSTEM_EMAIL_TEMPLATE,SYSTEM_NOTE,SYSTEM_NOTE2,SYSTEM_NOTE_FIELD,TAG,TASK,TASK_ITEM_STATUS,TAX_CALCULATION_PLUGIN,TAX_ITEM_TAX_GROUP,TAX_TYPE,TERM,TEST_PLUGIN,TIME_BILL,TIME_MODIFICATION_REQUEST,TIME_SHEET,TOPIC,TRACKING_NUMBER,TRANSACTION,TRANSACTION_ADDRESSBOOK,TRANSACTION_BILLING_ADDRESSBOOK,TRANSACTION_DELETION_REASON,TRANSACTION_HISTORY,TRANSACTION_NUMBERING_AUDIT_LOG,TRANSACTION_PAYEE_ADDRESSBOOK,TRANSACTION_RETURN_ADDRESSBOOK,TRANSACTION_SHIPPING_ADDRESSBOOK,UMD_FIELD,UNDELIVERED_EMAIL,UNITS_TYPE,UNLOCKED_TIME_PERIOD,USER_AUTHORIZATION_CONSENT,USER_EVENT_SCRIPT,USER_EVENT_SCRIPT_DEPLOYMENT,USER_O_AUTH_TOKEN,USRSAVEDSEARCH,USR_AUDIT_LOG,USR_DS_AUDIT_LOG,USR_DS_EXECUTION_LOG,USR_EXECUTION_LOG,VENDOR,VENDOR_CATEGORY,VENDOR_SUBSIDIARY_RELATIONSHIP,WEBAPP,WEB_SITE,WORKBOOK_BUILDER_PLUGIN,WORKFLOW_ACTION_SCRIPT,WORKFLOW_ACTION_SCRIPT_DEPLOYMENT,WORKPLACE,WORK_CALENDAR,WBS|}

N/query Module
query.Type
Enum Description: Holds the string values for query types used in the query definition. This enum is used to pass the initial query type argument to query.create(options). The N/query module supports the same record types that are supported by the SuiteAnalytics Workbook interface. For more information, see Available Record Types. JavaScript does not include an enumeration type. The SuiteScript 2.0 documentation utilizes the term enumeration (or enum) to describe the following: a plain JavaScript object with a flat, map-like structure. Within this object, each key points to a read-only string value.
Module: N/query Module
Sibling Module Members: N/query Module Members
Since: 2018.1
Search NetSuite - https://system.netsuite.com/app/help/helpcenter.nl?search=query.Type

Example:

// Code Example 1
// Add additional code
//...
var myCustomerQuery = query.create({
type: query.Type.CUSTOMER
});

var mySalesRepJoin = myCustomerQuery.autoJoin({
fieldId: 'salesrep'
});

var firstCondition = myCustomerQuery.createCondition({
fieldId: 'id',
operator: query.Operator.EQUAL,
values: 107
});
var secondCondition = myCustomerQuery.createCondition({
fieldId: 'id',
operator: query.Operator.EQUAL,
values: 2647
});
var thirdCondition = mySalesRepJoin.createCondition({
fieldId: 'email',
operator: query.Operator.START_WITH_NOT,
values: 'foo'
});

myCustomerQuery.condition = myCustomerQuery.and(
thirdCondition, myCustomerQuery.or(firstCondition, secondCondition)
);

var resultSet = myCustomerQuery.run();
//...
// Add additional code

//SOURCE: https://system.netsuite.com/app/help/helpcenter.nl?fid=section_1510878994.html