Details
-
Type:
Improvement
-
Status:
Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 1.10
-
Component/s: None
-
Labels:None
Description
Freddy found that parameters are missing in the SQL request on PROJECTS table :
SELECT `snapshots`.`id` AS t0_r0, `snapshots`.`created_at` AS t0_r1, `snapshots`.`project_id` AS t0_r2, `snapshots`.`parent_snapshot_id` AS t0_r3, `snapshots`.`status` AS t0_r4, `snapshots`.`purged` AS t0_r5, `snapshots`.`islast` AS t0_r6, `snapshots`.`scope` AS t0_r7, `snapshots`.`qualifier` AS t0_r8, `snapshots`.`root_snapshot_id` AS t0_r9, `snapshots`.`version` AS t0_r10, `snapshots`.`path` AS t0_r11, `snapshots`.`depth` AS t0_r12, `projects`.`id` AS t1_r0, `projects`.`name` AS t1_r1, `projects`.`description` AS t1_r2, `projects`.`enabled` AS t1_r3, `projects`.`scope` AS t1_r4, `projects`.`qualifier` AS t1_r5, `projects`.`kee` AS t1_r6, `projects`.`root_id` AS t1_r7, `projects`.`profile_id` AS t1_r8, `projects`.`language` AS t1_r9 FROM `snapshots` LEFT OUTER JOIN `projects` ON `projects`.id = `snapshots`.project_id WHERE (snapshots.islast=1 and projects.enabled=1 and snapshots.scope='PRJ' and snapshots.qualifier='TRK' and snapshots.status='P')
projects.scope='PRJ' and projects.qualifier='TRK' should be added.