hook_views_query_alter() and am wondering where I can find the syntax for the various query modifiers.
One of the examples I found looked like this:
$query->orderby = "FIELD(node.type, 'story', 'page', 'productTypeC', 'productTypeD') ASC";
I'm not sure what that syntax is saying. Does it mean order by the node.type field, where nodes with story are first, then page, and so on? Or something else? I need to be able to group on multiple fields (and not all fields are on the initial node (relationships.)
Is there somewhere that all of the available modifiers are documented, including their syntax? By modifiers, I mean
$query->where, and so on.