/[drupal]/contributions/modules/casetracker_services/casetracker_services.module
ViewVC logotype

Diff of /contributions/modules/casetracker_services/casetracker_services.module

Parent Directory Parent Directory | Revision Log Revision Log | View Revision Graph Revision Graph | View Patch Patch

revision 1.2.2.6, Fri Apr 4 03:36:24 2008 UTC revision 1.2.2.7, Fri Apr 4 03:37:39 2008 UTC
# Line 440  function casetracker_services_cases($pid Line 440  function casetracker_services_cases($pid
440        DISTINCT(n.nid), n.title, ncs.last_comment_timestamp,        DISTINCT(n.nid), n.title, ncs.last_comment_timestamp,
441        cc.pid, cc.case_number, cc.case_priority_id, cc.case_status_id, cc.case_type_id, cc.assign_to,        cc.pid, cc.case_number, cc.case_priority_id, cc.case_status_id, cc.case_type_id, cc.assign_to,
442        cp.project_number, n2.title AS project_title, n2.uid as project_author        cp.project_number, n2.title AS project_title, n2.uid as project_author
443      FROM node n LEFT JOIN casetracker_case cc ON (n.vid = cc.vid)      FROM {node} n LEFT JOIN casetracker_case cc ON (n.vid = cc.vid)
444      LEFT JOIN casetracker_project cp      LEFT JOIN {casetracker_project} cp
445        ON (cp.nid = cc.pid)        ON (cp.nid = cc.pid)
446      LEFT JOIN node n2      LEFT JOIN {node} n2
447        ON (cp.nid = n2.nid)        ON (cp.nid = n2.nid)
448      LEFT JOIN node_comment_statistics ncs      LEFT JOIN {node_comment_statistics} ncs
449        ON (n.nid = ncs.nid)        ON (n.nid = ncs.nid)
450      WHERE      WHERE
451        n.status = 1        n.status = 1
Legend:
Removed from v.1.2.2.6  
changed lines
  Added in v.1.2.2.7
  ViewVC Help
Powered by ViewVC 1.1.2