I'm thinking of going pure N/query in my next proj...
# suitescripte
ExtendApps Inc.
12/04/2020, 4:06 AMI'm thinking of going pure N/query in my next project. No N/search. Possible?
s
stalbert
12/04/2020, 5:05 AMI find myself rapidly moving towards SuiteQL for new projects.
stalbert
12/04/2020, 5:05 AMbut I avoid N/query like the complex plague that it is
b
battk
12/04/2020, 5:12 AMnot really sure what the issue is. Try only N/query, if you fail, then fall back to N/search
battk
12/04/2020, 5:12 AMits not like they are exclusive or anything
s
stalbert
12/04/2020, 5:14 AMtrue that
z
Zoran Roncevic
12/04/2020, 7:16 AMNo it is not possible. Some data (fields, values...) are available only through "object" model (record API), but not exposed via "database tables".... Especially if you are using International Tax Report like most EU users
t
tdietrich
12/04/2020, 8:14 AM@ExtendApps Inc. I think it's not only possible, but that you might find that the development goes much more quickly as well.
tdietrich
12/04/2020, 8:15 AMHow familiar are you with SQL?
z
Zoran Roncevic
12/04/2020, 8:27 AMAdditionally, SQL query executing is much faster than saved search, getting multilevel joined data is only possible with SQL. I wouldn't be exclusive. Both search and query have their advantages
Zoran Roncevic
12/04/2020, 8:32 AMAnd I forgot to mention : @ExtendApps Inc. don't miss @tdietrich SQL suitelet for interactive writing queries... 😎
e
ExtendApps Inc.
12/04/2020, 12:18 PMLove the feedback, thanks everyone!
s
stalbert
12/04/2020, 2:00 PMworth noting that n/query supports multilevel joins, not just SuiteQL.