If you've been trying to figure out when to use `N...
# suitescripte
erictgrubaugh
03/19/2020, 7:28 PMIf you've been trying to figure out when to use
N/searchN/query👍 7
💯 2
t
The Usual Suspect
03/19/2020, 7:29 PMBeen loving the Query module recently. I'll have to check this out
The Usual Suspect
03/19/2020, 7:30 PMRecently ran into trouble with polymorphic joins, you might want to add some detail about that. NetSuite didn't explain it very well
The Usual Suspect
03/19/2020, 7:31 PMOther than that you make some good points. I love the "asMappedResult" function
e
erictgrubaugh
03/19/2020, 8:00 PMThanks! The article isn't meant to be a "here's how to use it", and I haven't explored the directional joins myself yet. That will come later in the series I suspect
p
Pavol
03/20/2020, 1:12 PMWhere to find some field IDs for N/query:
Help> SuiteAnalytics > SuiteAnalytics > Workbook Analytics Data Source Overview > Available Record Types > WorkbookDataSource19_2.xlsx
Pavol
03/20/2020, 1:15 PMSearch vs Workbook field IDs' bible:
TransactionMapping.xlsx
5 Views