[TYPO3-english] RealURL and concat in alias_field

Rik Willems rik at actiview.nl
Mon Oct 25 19:22:55 CEST 2010


Hi all,

Just a short question. For a project I'd like to use first_name and 
last_name fields as part of an url through RealURL. I found the 
following snippet for that.

Is this safe to use?


==
'user' => array(
	array(
		'GETvar' => 'tx_feuserlisting_pi1[showUid]',
		'lookUpTable' => array(
			'table' => 'fe_users',
			'id_field' => 'uid',
			'alias_field' => 'concat(first_name, " ", last_name)',
			'addWhereClause' => ' AND NOT deleted',
			#'languageGetVar' => 'L',
			#'languageExceptionUids' => '',
			#'languageField' => 'sys_language_uid',
			#'transOrigPointerField' => 'l18n_parent',
			'useUniqueCache' => 1,
			'useUniqueCache_conf' => array(
				'strtolower' => 1,
				'spaceCharacter' => '-',
			),
			'autoUpdate' => 1,
		),
	),
),
==

thx!

Rik


More information about the TYPO3-english mailing list