Tag: SQL

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

SuiteQL to generate a saved search in Power BI via ODBC connector

The requirement was to connect NetSuite searches with Power BI in order to create the reports. We can load tables from NetSuite to Power BI based on the permissions given in the custom role. The searches cannot be load this way. As solution to this we can use SQL queries to recreate the same search… Continue reading SuiteQL to generate a saved search in Power BI via ODBC connector

Using TRIM, LTRIM, and RTRIM for Formula functions

This article gives examples on using some common string functions that can be used for NetSuite search formulas via user interface or script, and on custom formula fields. TRIM: Removes leading or trailing characters (or both) from a character string Syntax: TRIM([ { { LEADING | TRAILING | BOTH } [ trim_character ]| trim_character}FROM ]trim_source)… Continue reading Using TRIM, LTRIM, and RTRIM for Formula functions