AMCARSON
01/28/2025, 9:55 AMCeligo AI
01/28/2025, 9:56 AMAI generated answer (using internal Slack threads):Based on the conversations provided, it appears that there is no direct way to get the raw SQL for a NetSuite report. While you can use SuiteQL to run SQL-like queries in NetSuite, the ability to export a report's underlying SQL query is not mentioned. One user suggested using SuiteQL to write SQL-like queries, as shown in the code snippet:
let SQL = ""
var mySuiteQLQuery = query.runSuiteQL(sql);
let results = mySuiteQLQuery.results;
return JSON.stringify(results);
However, this does not directly answer the question about exporting a report's SQL.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
01/28/2025, 9:56 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.832472801
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.828980744
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.828744471
Celigo AI
01/28/2025, 9:56 AMAMCARSON
01/28/2025, 9:57 AMAMCARSON
01/28/2025, 9:57 AMCeligo AI
01/28/2025, 9:57 AMCeligo AI
01/28/2025, 9:57 AMAMCARSON
01/28/2025, 9:57 AM