Submitted by Seb on 31/10/2011 - 10:34
Let's keep on with useful snippets. Here is, in 4 lines of code, how to order view results on title string length.
1
2
3
4
5
6
7
8
9
10
11
| <?php
/**
* Implements hook_query_TAG_alter().
*
* @param SelectQuery $query
*/
function glossaire_query_views_export_alter(SelectQuery $query) {
$query->addExpression('LENGTH(node.title)', 'title_length');
$query->orderBy('title_length', 'DESC');
} |
This is used in the custom module of the french glossary. The code was built from the documentation available on drupal.org.