What It Does
The Dynamic GET Builder in Joomla Component Builder allows you to visually build complex queries involving one or more tables. You define the primary table and visually “join” related tables, selecting the fields you need from each and specifying how they relate. JCB then auto-generates secure, Joomla-compliant model code and query statements.

Key Capabilities

• 🔗 Join multiple related tables (one-to-one, one-to-many, many-to-many)
• 🔧 Choose join types (LEFT, RIGHT, INNER) from the GUI
• 🔍 Select specific fields to include from each joined table
• 🧠 Define join conditions using foreign keys or custom expressions
• 📊 Auto-generates Joomla Query API calls (not raw SQL)

Where to Configure

Inside the Dynamic GET Builder:

• Start with a primary table (e.g., #__yourcomponent_main)
• Add related tables using the “Join Table” feature
• Set join rules (ON conditions) using dropdowns or field matchers
• Select output fields from any joined table
• Optionally: add WHERE, GROUP BY, ORDER BY clauses

Example Scenarios

• Join #__orders with #__users to show customer names with each order
• Combine #__articles with #__categories for a filtered blog list
• Create dashboards showing data across multiple business entities
• Merge custom tables (e.g., invoices, transactions, audit logs)

Use Cases

• ✅ Build frontend lists showing user-generated content
• ✅ Power custom admin dashboards with real-time metrics
• ✅ Drive views requiring cross-referenced data from many tables
• ✅ Construct API-style outputs for JSON or XML rendering

Benefits

• ✅ No SQL knowledge needed — everything visual
• ✅ Reusable: one Dynamic GET can be attached to multiple views
• ✅ Round-trip safe: stored and compiled automatically
• ✅ Git versionable: stored as JCB entities and shared like code

Conclusion

With JCB’s visual join interface, you can handle data relationships that typically require custom SQL models — visually, safely, and flexibly. It’s an ideal way to future-proof complex views while staying within Joomla best practices.