QueryStream v3.7.8
How To Use
Back to App

How To Use QueryStream

Everything below is live in the app today. Log in with Salesforce, type a query, and the rest of this page is the tour.

1. Run your first query

  1. Enter any valid SOQL query in the editor and click Run.
  2. Results stream into the table live in batches of 2,000 rows - sort, browse, and export while the query is still loading.
  3. Click Abort at any time to stop a running query after the current batch completes. Rows already loaded stay in the table and can still be exported.

2. Aggregates and HAVING

  1. Aggregate queries with GROUP BY, COUNT, SUM, AVG, MIN, MAX are handled automatically. Simple aggregates run natively against Salesforce in one call, the same as Developer Console.
  2. Complex aggregates are rewritten to stream raw rows and are grouped in your browser - this works on any org size, with no governor limit timeouts.
  3. HAVING clauses are fully supported. On the rewrite path, HAVING is evaluated in the browser after all records are fetched and grouped, and a notice appears when this happens.

3. Templates and saved queries

  1. Use Templates in the sidebar for pre-built queries: Files by Type, Attachments by Object, Recent Accounts, Open Tasks by Owner, User Login Activity, Largest Files, and more.
  2. Use Save in the Saved Queries section to name and store the queries you reuse. They persist in your browser across sessions - stored locally on your device only, never on our servers.

4. Sorting and exporting

  1. Click any column header to sort results - unsorted columns show a ↕ icon, and the active sort column highlights in blue with a directional arrow.
  2. Export results as CSV (opens in Excel or Google Sheets) or JSON (for developers and API integrations) using the Export button - even while a query is still loading, or after an abort.

5. Keyboard shortcuts

  1. Ctrl+Enter (Cmd+Enter on Mac) runs the query.
  2. Escape aborts a running query.
  3. Ctrl+Shift+F focuses the editor, Ctrl+Shift+X clears it.

6. Working with multiple orgs

  1. Use Add Org in the topbar to connect multiple Salesforce orgs at the same time. Switch between them using the tab strip below the topbar - each org's queries, history, and results are completely isolated.
  2. Click the org name pill in the topbar to open your Salesforce org directly in a new tab.

7. Sessions and first-time sign-in

  1. Session tokens auto-renew when they expire - you will see a brief toast, but your query continues uninterrupted.
  2. If your first login fails with OAUTH_APPROVAL_ERROR_GENERIC, ask your Salesforce admin to approve this app once under Setup > Connected Apps > Manage Connected Apps > OAuth Usage > Install. This is a one-time step per org - after that, login works normally for everyone.