ストーリーに紐づかないタスクが表示できない

• Reporter: (Anonymous)
• Owner: okamototk
• Type: Feature Requests
• Status: Closed
• Component: (None)
• MileStone: (None)
• Priority: 5 - Medium
• Severity: 5 - Medium
• Resolution: Fixed
• File: None

Details

ストーリーに紐づいていないタスクがバックログの確認画面で表示できません。 下記の記述をレポートに追加してください。

UNION

SELECT
  CASE t.status WHEN 'closed' THEN 5 WHEN 'new' THEN 3 ELSE 1 END AS __color__,
   (CASE t.status 
      WHEN 'closed' THEN 'color: #777; background: #ddd; border-color: #ccc;'
      ELSE 
        (CASE t.owner WHEN $USER THEN 'font-weight: bold' END)
    END) AS __style__,
  t.milestone AS __group__,
  '-' AS id,
  'その他' AS 'ストーリー',
  t.id AS ticket,
  t.summary as 'タスク',
  t.owner AS '担当者', 
  t.status AS '状態',
  eh.value AS '見積',
  th.value AS '作業時間',
  ''
FROM ticket as t
  LEFT JOIN ticket_custom eh ON eh.ticket = t.id AND eh.name = 'estimatedhours'
  LEFT JOIN ticket_custom th ON th.ticket = t.id AND th.name = 'totalhours'
WHERE t.type='タスク' AND
  (SELECT count(*)==0 from subtickets WHERE subtickets.child = t.id)

Ticket History (3/3 Histories)

2011-01-11 13:10 Updated by: None

• New Ticket "ストーリーに紐づかないタスクが表示できない" created

2011-01-12 08:01 Updated by: okamototk

• Owner Update from (None) to okamototk

Comment

NOT EXISTSを使ったら?

http://twitter.com/#!/jun66j5/status/24858348960612352

2011-03-07 08:28 Updated by: okamototk

• Resolution Update from None to Fixed
• Status Update from Open to Closed
• Ticket Close date is changed to 2011-03-07 08:28

Comment

修正済み。