What Are Dynamic Gets?

Dynamic Gets in JCB are graphically designed database queries that define how data should be fetched, joined, filtered, and structured using a easy selection query builder interface.

They act as a visual abstraction over SQL joins and filters, comparable to:

• Visual Query Builders
• ORM Relationship Graphs
• Custom Query Composition Engines

Dynamic Gets allow you to:

• Choose a primary table
• Join multiple related tables
• Select fields from across those joins
• Apply filters, WHERE clauses, ordering, and grouping — all from within a GUI.

JCB then auto-generates:

• The complete SQL JOIN logic
• Any Joomla-compliant API interaction
• The PHP model code required to support the query

How Do Dynamic Gets Integrate Into Views?

Each Site View or Custom Admin View requires a main Dynamic Get, which defines how its item or list data is fetched from the database.

But that's not all: you can attach multiple additional Dynamic Gets to a single view, enabling you to merge data from completely different tables — dynamically, cleanly, and consistently.

JCB intelligently ensures that the resulting component:

• Uses secure and efficient Joomla API calls
• Avoids repetitive logic
• Embeds the Dynamic Get logic directly into the component's models

This eliminates the need for hand-crafted query code, while maintaining full control and extensibility.

Reset, Fork, or Customize

Just like other JCB entities, Dynamic Gets support a Git-based update workflow:

• Init: Pull from a remote repository
• Reset: Sync with upstream versions
• Push: Submit updates (if you have write access)
• Fork: Maintain your own version of dynamic queries

This lets you customize, evolve, and share query logic without rewriting or copy-pasting.

Whether you're building for:

• Deep reporting
• Cross-table analytics
• Complex filter-based list views

Dynamic Gets combine power, flexibility, and GUI-driven convenience — helping you build smarter, faster, and more maintainable Joomla components.

Index of Dynamic Gets

• Greeting | Details | Settings
• GreetingList | Details | Settings
• ImportLogMessages | Details | Settings
• Item Import Queue | Details | Settings
• Item Importer | Details | Settings
• Looking | Details | Settings
• Looks | Details | Settings

All used in Joomla Component Builder – Source – Mirror – Download