Dynamic Query Framework
Lightning Web Component for Dynamic SOQL Queries in Salesforce
Lightning Web Component for Dynamic SOQL Queries in Salesforce
This isn't just another tool to run SOQL queries. JT Dynamic Queries is a comprehensive development framework that transforms how Salesforce developers interact with data.
Pre-configured queries for common debugging scenarios. No more writing the same queries over and over.
Run As User feature lets you validate data visibility and security models without switching users.
Tree view for parent-child relationships. See your data structure at a glance, not in flat tables.
Handle 50k+ records with cursor-based pagination. No more governor limit headaches.
Switch between Table, JSON, and CSV views. Copy data in the format you need for documentation or analysis.
Share query configurations across your team. Everyone uses the same validated queries for consistency.
For Developers, By Developers: Built by someone who got tired of Developer Console limitations and wanted a modern, accessible, and powerful way to work with Salesforce data.
Select a configuration and execute queries instantly. View results in an intuitive table format with smooth scrolling.
Switch between Table, JSON, and CSV views seamlessly. Export data in your preferred format for analysis or integration.
Expand parent records to view child relationships in a hierarchical tree structure. Perfect for navigating complex data models.
Handle massive datasets (>50k records) with cursor-based pagination. Optimized performance for enterprise-scale queries.
Build custom query configurations with a simple form. Define objects, fields, filters, and parameters in seconds.
Execute queries as a specific org user using System.runAs() to test permissions and data visibility. Select any active user and see exactly what they see — OWD, sharing rules, and FLS fully enforced.
Test queries as a synthetic user built from a Profile + Permission Sets combination — no real user required. Define personas via the built-in Persona Manager, then execute queries to validate your sharing model against any role archetype.
Create and manage persona definitions directly from the UI. Combine any Profile with one or more Permission Sets, save to metadata, and reuse across your team — no code deployment required.
Discover how I use EDD as the core methodology, complemented by E2E, TDD, and BDD to build better software faster
"The error message is your friend. It tells you exactly what to build next."
Execute SOQL queries dynamically without hardcoding
Secure Tooling API callouts with modern Named Credentials
Switch between Table, JSON, and mobile card views
WCAG 2.1 AA compliant with full keyboard navigation
Built with Salesforce Lightning Design System
118+ E2E tests with Playwright for reliability
Deploy the framework to your Salesforce org with just one click. No need to clone the repository or install any tools.
If you want to contribute to the project or customize it locally, follow these steps:
# Clone repository
git clone https://github.com/jterrats/JT_DynamicQueries.git
cd JT_DynamicQueries
# Install dependencies
npm install
# Deploy to your org
sf project deploy start
# Run tests (optional)
npm testJoin the community and start building better SOQL queries today