1. Multilevel Joins
- N/query allows for multilevel joins, which means you can link multiple related records across various tables efficiently. This feature enables querying complex data relationships without needing multiple scripts or heavy looping logic.
2. Support SQL Queries
- The N/query module allows you to structure your queries similarly to SQL, which is more powerful and flexible compared to the search module. You can construct queries with filters, sorting, and join conditions similar to how you would with SQL, making it easier for developers familiar with database querying.
3. Convert to SuiteQL
- You can convert N/query-based queries into SuiteQL, which provides more flexibility and control. SuiteQL enables the execution of raw SQL queries, allowing access to fields and joins not easily available through other search mechanisms.
4. Manipulate SuiteAnalytics Workbook
- The N/query module can be integrated with SuiteAnalytics Workbook, providing you with the ability to create, manipulate, and execute workbook queries. This integration leverages the SuiteAnalytics engine, enhancing reporting and data analysis capabilities within NetSuite.
5. Paginated and Mapped Results
- N/query provides paginated results, which is essential when handling large datasets. Instead of pulling all records at once, you can retrieve them in smaller, manageable pages. Additionally, the module allows mapping of results into custom structures, making it easier to manipulate and format the data as needed.