#32051Concat ordering for Database request
Description
Hi there
it would be nice to be able to made “concat orderings” over multiple fields with database.
I’d imagine this looking like this:
$query = $this->createQuery(); $query->setOrderings( array( 'CONCAT(field1,field2,field3) as 'fieldx' => Tx_Extbase_Persistence_QueryInterface::ORDER_DESCENDING ) );
The code must then check with preg_match if CONCAT\((.*)\) as ([^\s]+) is set.
I’m probably going to implement something like this by my self and I’ll post it as soon as I’ve got something that works.
Greets Tizian