Using RealURL with a JOIN statement (TYPO3)

Question

I'm using RealURL on a site where I would like to join two tables in the "lookUpTable" statement. The resulting URL should be a combination of fields in table a and table b.

So basically I would like to do a JOIN in table and addWhereClause and than use multiple alias_fields.

The standard syntax is:

'lookUpTable' => array(
                            'table' => 'user_3dsplmxml_bfsbrand',
                            'id_field' => 'xml_id',
                            'alias_field' => 'xml_title',
                            'maxLength' => 10,
                            'addWhereClause' => ' AND NOT deleted'
                        )

The manual gives no hint if this is possible, but it would be of great use. Anyone knows if this can be done?

Answer 1

You can use a userFunc instead of the lookUpTable.

See realurl manual