The SOQL Builder now adapts filter operators to the selected field’s data type and offers contextual value suggestions (picklist values, boolean options, common date literals). Query composition now understands NULL semantics (IS NULL / IS NOT NULL). Several UI and accessibility improvements accompany this change.
What’s new (user-facing)
Type-aware filter operators
Operator dropdowns show only operators valid for the selected field type (e.g., numeric comparators for number/date fields; INCLUDES/EXCLUDES for multi-picklists).
Nullable fields offer "= NULL" and "!= NULL" options that compose to IS NULL / IS NOT NULL in the final SOQL.
Contextual value suggestions
Picklist fields: suggestion dropdown shows the object’s picklist values (pick/click to select; type to filter).
Boolean fields: quick true / false options.
Date/datetime fields: common SOQL date literals (TODAY, YESTERDAY, LAST_90_DAYS, LAST_N_DAYS:30, THIS_YEAR, etc.).
IN / NOT IN operators support multi-select (comma-separated) behavior when selecting suggestions.
Keyboard support: Arrow Up/Down to navigate suggestions, Enter to accept, Escape to close.
Query composition improvements
"= NULL" and "!= NULL" operators are converted to "IS NULL" and "IS NOT NULL" respectively when the builder generates the WHERE clause.
UX and styling
Value suggestions are presented in a fixed-position dropdown (avoids overflow clipping) and include dark-theme variants.
The builder preserves editing state while suggestions are visible — typing won’t unexpectedly dismiss the dropdown.
No breaking changes to saved queries or general behavior: existing queries and workflows remain compatible.

SOQL Builder: Type-aware WHERE operators
Operator dropdowns now show only operators valid for the selected field type (e.g., numeric/date comparators for numbers/dates, picklist operators for picklists, includes/excludes for multi-picklists).
= NULL and != NULL operator options added for nullable fields, composed to IS NULL / IS NOT NULL in queries.
SOQL Builder: Contextual value suggestions
Picklist fields: suggestion dropdown shows picklist values from the object describe; click to select. For IN / NOT IN operators multi-selection is supported via comma-separated values.
Boolean fields: quick options for true and false.
Date/datetime fields: common SOQL date literals are suggested (TODAY, YESTERDAY, LAST_90_DAYS, LAST_N_DAYS:30, THIS_YEAR, etc.).
Suggestions are keyboard-navigable (Arrow Up/Down, Enter), clickable, and shown as a fixed-position dropdown to avoid overflow clipping.
Query composition
= NULL → IS NULL, != NULL → IS NOT NULL are now handled when the builder composes the WHERE clause.
UI / styling
New dropdown styling for value suggestions with dark-theme variants to match existing UI guidelines.
Value suggestion behavior respects the builder's editing guards (doesn’t destroy suggestions while typing).
Tests & Validation
Linting and the test suite were run locally for core flows; existing SOQL builder tests pass with these changes.
Detailed user-facing changes and usage guidance
When to expect new behavior
After you select an object and the field describe loads, adding or editing a filter row will show only valid operators for that field.
Example operator mapping (high level)
string/textarea/email/url/phone: =, !=, LIKE, NOT LIKE, IN, NOT IN
picklist: =, !=, IN, NOT IN
multipicklist: =, !=, INCLUDES, EXCLUDES
boolean: =, !=
int/double/currency/percent: =, !=, >, >=, <, <=
date/datetime: =, !=, >, >=, <, <=
reference/id: =, !=, IN, NOT IN
For nullable fields, = NULL / != NULL are available.
Value suggestions
Picklist → picklist values appear under the value input; type to filter the list, click or press Enter to accept.
Boolean → picks true/false.
Date/datetime → pick common date literals (TODAY, LAST_N_DAYS:30, etc.).
IN/NOT IN behave as multi-select (comma-separated). Selecting a suggestion will append it to the list if not present.
For = NULL / != NULL the value input is not required (the builder will compose an IS NULL clause).
Keyboard controls
Arrow keys to navigate suggestion list, Enter to accept, Escape to close.
Tab behavior in filter field continues to advance focus into operator select and then value (unchanged).

v1.8.11 - 2026-03-22

🚀 Highlights

• Fixed: Command Palette keyboard toggle (pressing same shortcut toggles open/close reliably).
• Fixed: Command Palette re-open after close via keyboard.
• Fixed: Show All Data double-toggle (keyboard handler is now single source of truth).
• Improved: Settings Save & Apply stability & broadcast reliability.
• Fixed: Per-org inline edit guard and automatic migration of legacy setting.
• Maintenance: Linter and IDE warning fixes; small code cleanups in content.js and soql_helper.js.

v1.8.10 — March 22, 2026: Small UX patch improving the page-side LWC Explorer. Users can now resize or minimize the component tree, persist default layout preferences, and rescans rebuild from a full-page root to avoid stale traces. This continues the v1.8.9 enhancements that added a To GraphQL SOQL → GraphQL conversion workflow and introduced the LWC Explorer + page tracing utilities — overall these releases refine settings, developer tooling, and metadata discovery.

v1.8.8 — Settings Architecture, Metadata Search, and Training Guide (2026-03-21)
✨ Improvements
Shared Settings Service (settings_helper.js)
Introduced a reusable settings schema/service layer inside settings_helper.js
Migrated the Sidebar panel settings to the new shared model first
Established a cleaner pattern for future settings sections: shared defaults, shared load/save, normalized values, and one consistent apply path
Docs & Training Refresh (docs/*, scripts/update-docs-version.js)
Added a new Training Guide page for role-based onboarding
Updated docs messaging to reflect the current UX model: launcher popup, workspace tab, and in-page overlays
Corrected outdated browser-support and feature-positioning language across the docs hub
Updated the docs version script to include docs/guide.html
Quiz Content Refresh (docs/api/question_bank.py)
Added new training-oriented quiz questions covering:
launcher vs workspace usage
Setup Search vs Metadata Explorer
metadata API-name search
safer label-translation workflows
📦 Files Changed
File Summary
manifest.json Version → 1.8.8
settings_helper.js Added shared settings schema/service and migrated Sidebar panel settings
tests/sidebar_settings.test.js Added coverage for shared settings service and sidebar normalization
docs/guide.html New training guide page
docs/index.html, docs/help.html, docs/documentation.html, docs/quick-start-guide.html Updated UX/content positioning and added Training Guide links
docs/quiz.html, docs/leaderboard.html, docs/privacy-policy.html Added Training Guide navigation links
docs/api/question_bank.py Added new trainer-oriented quiz questions
docs/AGENTS.md Updated docs-project guidance to match actual files and architecture
scripts/update-docs-version.js Includes guide.html in version-sync flow