Changeset 15666 for branches/HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3/Daos/TaskDao.cs

Timestamp:

01/29/18 17:38:50 (7 years ago)

Author:

jzenisek

Message:

#2839 implemented project facts-logging in HiveStatisticsGenerator

File:

• branches/HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3/Daos/TaskDao.cs (modified) (1 diff)

branches/HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3/Daos/TaskDao.cs

@@ -93 +93 @@
 
     #region String queries
-    private const string GetParentTasksQueryString = @"
-      SELECT t.* FROM [Task] t, [Job] j, [AssignedJobResource] ajr
-        WHERE t.IsParentTask = 1
-        AND t.TaskState = 'Waiting'
+    private const string GetCalculatingChildTasksByProjectId = @"
+      SELECT t.* FROM [Task] t, [Job] j
+        WHERE t.IsParentTask = 0
+        AND t.TaskState = 'Calculating'
         AND t.JobId = j.JobId
-        AND j.JobId = ajr.JobId
-        AND t.FinishWhenChildJobsFinished = 1
-        ... TODO (not necessary)
+        AND j.ProjectId = {0}
+        ORDER BY j.ProjectId
     ";
     private const string GetWaitingTasksQueryString = @"