[development] hook_views_query_alter

[Earl Miles]

On 10/30/2010 11:36 AM, Ashraf Amayreh wrote:
> 
> Now with my special case, the query would need to change to:
> 
> SELECT n.nid, n.title FROM node n
> INNER JOIN term_node tn ON n.nid = tn.nid
> INNER JOIN content_type_document ctd ON n.nid = ctd.nid
> INNER JOIN files f ON ctd.field_documet_file_fid = f.fid
> WHERE n.type = 'document' AND tn.tid IN (7) AND f.filename like '%.doc'
> ORDER BY n.created DESC

Assuming that the filefield module offers a relationship to the files
table (it should, but I can't confirm that it does) then you add that
relationship, then add File: Name using the "Ends With" operator.
Alternatively you can use the File: Mime Type filter as well since I
think .doc has its own mime type.