Hi guys! Maybe a stupid question. When I try to ge...
# suitescriptd
Dmitry Masanov
11/30/2020, 1:40 PMHi guys! Maybe a stupid question. When I try to get all RMA item lines using the following sql:
Copy code
`SELECT TransactionLine.Transaction, TransactionLine.linesequencenumber, TransactionLine.item, FROM TransactionLine INNER JOIN Transaction ON ( Transaction.ID = TransactionLine.Transaction ) where ( TransactionLine.Transaction = ${rmaId}) order by TransactionLine.linesequencenumber`;w
Watz
11/30/2020, 1:45 PMMaybe you get tax lines or some other type of line that isn't in the item sublist?
d
Dmitry Masanov
11/30/2020, 1:47 PMNope, checked one of them, it is Inventory Item as well
Dmitry Masanov
11/30/2020, 1:57 PMFound the workaround, since I only need serializable items, I added a join with Item table with .isserialitem condition. But still a mystery for me. :)
w
Watz
11/30/2020, 2:07 PMGreat! If I run your query, I get a tax line in the result.
d
Dmitry Masanov
11/30/2020, 2:08 PMOh, I see. Thank you!
Dmitry Masanov
11/30/2020, 2:09 PM@Watz what is the tool you’re using?
w
Watz
11/30/2020, 2:10 PMA great suitelet script created by Tim Dietrich: https://timdietrich.me/netsuite-suitescripts/suiteql-query-tool/
d
Dmitry Masanov
11/30/2020, 2:18 PMSuch a great thing! Thank you!
w
Watz
11/30/2020, 2:23 PMThank Tim / tdietrich, not me! 🙂
s
stalbert
11/30/2020, 2:39 PMI wish someone would make a full featured SuiteApp for suiteql.
w
Watz
11/30/2020, 2:41 PM@stalbert how do you mean? Like Analytics Workbook?
s
stalbert
11/30/2020, 2:44 PMHopefully better than that. I'm thinking more like SSMS
stalbert
11/30/2020, 2:45 PMbasically a rich UI (e.g. built in AngularJS) that helps you quickly craft and test SuiteQL queries.
stalbert
11/30/2020, 2:46 PMin other words, like the form shown above but much more advanced. Stuff like SQL syntax highlighting and intellisense, perhaps schema info, perhaps show performance metrics, richer UI for viewing results, etc.
stalbert
11/30/2020, 2:46 PMI'll do it if I get time, but it's time that's the gotcha 🙂
w
Watz
11/30/2020, 2:46 PMGet it.
m
michoel
11/30/2020, 10:38 PM@stalbert I started working on one actually in vue.js a couple weeks back, but don't have much spare time at the moment
michoel
11/30/2020, 10:40 PMFor now I just use chrome snippets, which works pretty well. @tdietrich's tool is handy as well.
s
stalbert
12/01/2020, 1:47 PMI hear ya @michoel. I hope NS provides a good SuiteQL experience in the native UI soon.
w
Watz
12/03/2020, 11:23 AM@michoel console.table() was a nifty function.
2 Views