Write Query

The Write Query screen is the primary interface of NimbusQL. It allows you to compose SQL queries using SuiteQL syntax, with support for multi-level joins and combining datasets.

Writing a Query

1. Navigate to NimbusQL in your NetSuite menu
2. Click Write Query to open the query editor
3. Enter your SuiteQL query in the editor
4. Click Execute to run the query and view results

Using Autocomplete

NimbusQL includes autocomplete functionality for all standard and custom record types.

• Press Ctrl + Space to activate autocomplete
• Autocomplete works for table names, field names, and keywords

Query Tips

• Use standard SuiteQL syntax for all queries
• Multi-level joins are fully supported
• You can combine multiple datasets within the same query
• The Full version supports unlimited query results with no row limits