[Gforge-commits] gforge/common/search ArtifactSearchQuery.class, 1.1, 1.2

[gsmet]

Update of /cvsroot/gforge/gforge/common/search
In directory db.perdue.net:/tmp/cvs-serv13418/common/search

Modified Files:
        ArtifactSearchQuery.class 
Log Message:
Applied patch #763 by Oliver Blume


Index: ArtifactSearchQuery.class
===================================================================
RCS file: /cvsroot/gforge/gforge/common/search/ArtifactSearchQuery.class,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- ArtifactSearchQuery.class   9 Feb 2004 10:22:21 -0000       1.1
+++ ArtifactSearchQuery.class   16 Apr 2004 12:20:07 -0000      1.2
@@ -52,12 +52,13 @@
         */
        function getQuery() {
                $sql = 'SELECT DISTINCT ON (a.group_artifact_id,a.artifact_id) 
a.group_artifact_id,a.artifact_id,a.summary,a.open_date,users.realname '
-                       . 'FROM artifact a,users ' 
+                       . 'FROM artifact a LEFT OUTER JOIN artifact_message am 
USING (artifact_id), users ' 
                        . 'WHERE a.group_artifact_id=\''.$this->artifactId.'\' '
                        . 'AND users.user_id=a.submitted_by '
                        . 'AND (('.$this->getIlikeCondition('a.details', 
$this->words).') ' 
                        . 'OR ('.$this->getIlikeCondition('a.summary', 
$this->words).')) '
-                       . 'ORDER BY group_artifact_id ASC, artifact_id ASC';
+                       . 'OR ('.$this->getIlikeCondition('am.body', 
$this->words).') '
+                       . 'ORDER BY group_artifact_id ASC, a.artifact_id ASC';
 
                return $sql;
        }
@@ -78,4 +79,4 @@
        
 }
 
-?>
\ No newline at end of file
+?>