Tag: SQL

Limiting the Number of Results Using SuiteQL

In today’s data-driven business environment, managing and processing large datasets efficiently is crucial for making informed decisions. Whether you’re working with databases, APIs, or enterprise applications, controlling the number of results returned by your queries or searches is essential to ensure both performance optimization and improved user experience. When working with SuiteQL to explore and retrieve data… Continue reading Limiting the Number of Results Using SuiteQL

Database Testing Using SQL Server

Database testing is an essential phase of software development and quality assurance, ensuring the data layer of applications is reliable, accurate, and efficient. SQL Server, a widely used relational database management system, offers powerful tools for effective database testing. This article explores the key aspects of database testing in SQL Server, focusing on its importance,… Continue reading Database Testing Using SQL Server

SQL Datetime functions

The following tables outline the SQL datetime functions that can be used in NetSuite search formulas and custom formula fields: Datetime Functions:

Fetching the credit Sublist values From Payment record.

The credit sublist values are not directly accessible using a script. However, we can create a workbook to fetch the credit data, and then use SQL to retrieve it in the script. Steps: Create a dataset for the required data. Navigate to Analytics > create new dataset. We can filter the results by adding criteria.… Continue reading Fetching the credit Sublist values From Payment record.

Setting up new models in Hightouch for BigQuery to NetSuite data transfer (reverseETL)

Hightouch models define and organize the data you want to query from a source. To create a new model, navigate to the Models page and click Add model. Next, select one of you the sources you’ve setup. Then choose a modeling method: SQL editor Table selector dbt model selector Looker Sigma Supported modeling methods depend on the source. Refer to… Continue reading Setting up new models in Hightouch for BigQuery to NetSuite data transfer (reverseETL)

SQL Issue on the server

Job for mysqld.service failed See “systemctl status mysqld.service” This message came after deploying the mysql service and we will not be able to run the service. use the terminal to route to the following commands This will resolve the issues on the server and will be able to run the MySQL services on the local… Continue reading SQL Issue on the server

Suite talk Rest API setup

Importing the Postman Collection To import the Postman collection: Download the REST web services Postman collection of sample requests from the SuiteTalk tools download page at https://<accountID>.app.netsuite.com/app/external/integration/integrationDownloadPage.nl. To access this page, you must substitute your account ID, and the REST web services permission must be assigned to your role. Unzip the archive. Click Import in… Continue reading Suite talk Rest API setup