Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
n/Query using SuiteQL
I am trying to use SuiteQL with the query module from this note Answer Id: 91329
The examples don't appear to work. However it's unclear what the real sytax is.
I copied sql from a jdbc query that works and got all kinds of errors.
Is there supposed to be a comment after each column like thia /*{amountfx}*/
"t.tranid as trandate AS trandate /*{trandate}*/, " +
"tl.amount_foreign as amountfx /*{amountfx}*/, " +
"tl.amount as amountusd /*{amomuntusd}*/" +
"from transactionline tl " +
"inner join transaction t on tl.transaction_id = t.transaction_id " +
"where t.transaction_id=3387591";
// Run the SuiteQL query