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

Successful runs are saved in Query History. Click History to reopen a previous query.

Reuse SuiteQL fragments with Snippets. Click Snippets to insert a saved snippet, or highlight text and click Create Snippet.

Browse records and fields with Schema Explorer. Click Schema to open the panel beside the editor.

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
• Table suggestions include a book icon that opens Schema Explorer on that record

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