[TYPO3-mvc] Sorting based on related objects

Frank Krüger fkrueger-ml at mp-group.net
Thu Dec 29 20:52:05 CET 2011


Hi Henjo,

you could create a field 'position.type', type integer, set this to
- normal position: 0
- override position: 1
- global override position: 2

and modify your query to
  ORDER BY position.type DESC, position.title ASC, lastName ASC

Cheers,
Frank




More information about the TYPO3-project-typo3v4mvc mailing list