PropelJoin transformer

PropelJoin transformer is used to join Propel objects.

It is used to add one or more entries to the row by looking up the data in the database.

Usage:

<propel-join
    pipelineFieldName="name"
    dbFilterFieldName="name"
    modelFilterFieldName="name"
    queryClass="\Orm\Zed\Module\Persistence\SpyModuleQuery"
    limit="1"
>
    <with-column name="name" alias="alias" />
</propel-join>

Attributes:

  • pipelineFieldName - name of the field in the pipeline - used as a JOIN condition

  • dbFilterFieldName - name of the field in the database - used as a JOIN condition

  • modelFilterFieldName - name of the field in the model

  • queryClass - name of the query class, used to fetch the data from the database

Optional attributes:

  • limit - limit of the query

Children:

  • with-column - name of the column to be joined
    • name - name of the column in the database table

    • alias - name of the entry added to the row