3.1 - ORM System

New feature : ORM System

The ORM system acts such as a data provider, directly at the SQL level.
You don't need anymore to write SQL queries manually.

'ORM' stand for Object-Relational Mapping.
It basically means that your component is able to link tables together automatically.

For purists... I know, this is not yet a complete ORM system, but it has the foundations to introduce such new way for loading datas. And more in future!



New Feature : Multiple FK Filter

This feature permit to enter multiplie values in a simple Foreign Key Filter.Multi FK Filter

How to use it :
1. Instance a "List" filter
2. Drag a FK node (or sub node)

This filter can accept unlimited level of Foreign Key.

New Helper : Form Helper
Include the functions which will slowly replace JDom
Some fields has been rewrited (model, relation) to fit better Joomla native fields.


New Feature : Pivot Filter

Permit to filter a list using a Many-to-Many relation table.
Pivot Filter

For instance, in the 'Cities' table, the user is able to filter on 'Travellers'
The pivot table is 'Visits', which contains a FK to a City, and a FK to a Traveller.

This filter is multi-selection. It means that you can concat multiple values into the filter.

Pivot Filter Multiselect



Rewrite structure : EnumerationsEnumerations
Code improvement for instancing enumerations.

Enumerations are called directly from the XML files in Forms, Filters, and Front Layout Filters (Menu items)
A new 'Enumeration' field has been created.
A new dedicated Helper is used for the static values. It is forkable, flexible, and optimized.
The caller view and the templates has been simplified.

To get a static list :


New Feature : Import dataset
Import dataset
The importer is now able to treat and import the datas contained in a SQL file.

First, drop a SQL file (or compressed archive).
The importer shows the recognized structure and datas.
The base prefix (DB prefix + component base), is automatically recognized and removed when the file contains more than one table.
Check carefully the tables aliases (plural and singular).
If your file contains only one table, the prefix cannot be recognized. You might need to rename the aliases names.
For every table, choose if you want to import the fields (structure), or datas (rows).
Once you have configured the import, click the "Import" button.

  • The component tables structures will be overridden
  • A new dataset snapshot will be created : "import"

The imported dataset will NOT be installed automatically.

To install the imported dataset, you simply have to drag the last "import" dataset into the drop area.
(The datasets are located under the "Datasets" tab)

Dataset Snapshot


Dataset Snapshot New feature : Snapshot the dataset

Save you datasets in backup files.
Thanks to this feature, you can now be sure to never lost your datasets and to be able to play with them.

Drag a dataset to the drop area to reinstall it in the sandbox.

The first line are the milestones for every regeneration in sandbox. It is a simple FIFO stack.
The second line is the list of your manual snapshots.

Get Started