This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Is it better to use the n/query module than the n/search module because the former supports muti-joins? Or is n/search still the default and n/query is used only as a last resort? What do you think is the best practice?

Honestly depends on your use case.  I almost exclusively use N/query because I’m usually multi-joining and I find it way faster to write my code using SQL as I have lots of experience using it.

but for simple lookups or code that you want other NS devs (who might now know SQL) to be able to read and understand, N/search would be a better choice.