Active
Project:
Support Nag
Version:
6.x-1.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
14 Mar 2011 at 22:29 UTC
Updated:
14 Mar 2011 at 22:29 UTC
I expect following query in file support_nag.module (about line 62) to select all tickets matching some filter criteria:
// TODO: Ugly query!
$sql = 'SELECT n.nid FROM {node} n
LEFT JOIN {support_ticket} t ON n.nid = t.nid
WHERE '. implode(' AND ', $where) .
' ORDER BY state ASC, priority DESC, client';
$result2 = db_query($sql);
But the "LEFT JOIN" will result in returning ALL nodes - what is probably not intended.