2008\ub144 \ub4e4\uc5b4\uc11c \ud68c\uc0ac \uac1c\ubc1c\ud300\uc5d0\uc11c \ubaa8\ub4e0 \uc77c\uc744 Trac\uc758 \ud2f0\ucf13\uc73c\ub85c \uad00\ub9ac\ud558\uae30\ub85c \ud588\uc2b5\ub2c8\ub2e4.<\/p>\n
Trac\uc774 \ud55c\uae00\ud654 \ub418\uc5b4\uc788\uc9c0 \uc54a\uc740\uac70 \uac19\uc544\uc11c \uba87\uac00\uc9c0 \uac04\ub2e8\ud55c\uac70\ub294 \ud55c\uae00\ub85c \ubc14\uafe8\uc2b5\ub2c8\ub2e4.<\/p>\n
\ud604\uc7ac 0.10.4 \ubc84\uc804\uc744 \uc0ac\uc6a9\uc911\uc778\ub370, \uc124\uc815 \ubcc0\uacbd\uc740 TracWebAdmin \ud50c\ub7ec\uadf8\uc778\uc744 \ud1b5\ud574\uc11c \ud588\uc2b5\ub2c8\ub2e4. \uc0c8\ubc84\uc804\uc5d0\ub294 Admin \uae30\ub2a5\uc774 Trac\uc5d0 \ud1b5\ud569\ub41c\ub2e4\uace0 \ud558\ub294\ub370, \uc815\ub9d0 \uc5c6\uc73c\uba74 \uc548\ub418\ub294 \ud544\uc218 \uae30\ub2a5\uc785\ub2c8\ub2e4.<\/p>\n
Priority\ub97c \uc601\uc5b4\uc5d0\uc11c 1,2,3,4,5\ub85c \ubc14\uafb8\uace0,
\nType\uc740 \ubc84\uadf8\uc218\uc815, \uae30\ub2a5\uac1c\uc120, \uc0c8\ub85c\uc6b4\uae30\ub2a5\uc73c\ub85c \ubcc0\uacbd\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n
\uac1c\ubc1c\ud300 \ubc16\uc5d0\uc11c \ud2f0\ucf13 \ub4f1\ub85d \ubc0f \ubaa8\ub2c8\ud130\ub9c1\uc744 \ud560\uc218 \uc788\ub3c4\ub85d, Permission\uc744 \ubc14\uafe8\uc2b5\ub2c8\ub2e4.
\n\uba3c\uc800 \uac1c\ubc1c\uc790(developers) \uadf8\ub8f9\uc744 \uc0dd\uc131\ud558\uace0, TIMELINE_VIEW\uc640 BROWSER_VIEW \uc561\uc158\uc744 anonymous\uc5d0\uc11c developers\ub85c \uc62e\uacbc\uc2b5\ub2c8\ub2e4. (\uc0ad\uc81c\ud558\uace0 \ub2e4\uc2dc \ub4f1\ub85d)<\/p>\n
Trac\uc758 \uc0ac\uc6a9\uc790 \uc778\uc99d\uc740 htpasswd\ub97c \uc0ac\uc6a9\ud558\uba70, \uc6f9\uc11c\ubc84\ub294 lighttpd\ub97c \uc0ac\uc6a9\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
View Tickets \ud398\uc774\uc9c0 \ubcf4\uba74 report\ub97c \ud3b8\uc9d1\ud560\uc218 \uc788\ub294\ub370, \ud3b8\uc9d1\ud574\uc11c TODO\uc640 \ucd5c\uadfc\ubcc0\uacbd\uc0ac\ud56d\uc744 \ub9cc\ub4e4\uc5c8\uc2b5\ub2c8\ub2e4. TODO\ub294 \uc544\uc9c1 \uc644\ub8cc\ub418\uc9c0 \uc54a\uc740 \uc77c(\ud2f0\ucf13)\uc744 \ub0b4\uac70\uc640 \ub2e4\ub978\uc0ac\ub78c\uac70\ub85c \ub098\ub204\uc5b4 \ubcf4\uc5ec\uc8fc\uba70, \uc6b0\uc120\ub3c4\uc5d0 \ub530\ub77c \uc815\ub82c\ud574 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. \ubc14\ud0d5\uc0c9\ub3c4 \uc6b0\uc120\ub3c4\uc5d0 \ub530\ub77c\uc11c \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. \uc544\ub798\ub294 report\ub97c \uc704\ud55c SQL Query\uc785\ub2c8\ub2e4.<\/p>\n
[CODE]
\nSELECT p.value AS __color__,
\n (CASE owner
\n WHEN ‘$USER’ THEN ‘My Tickets’
\n ELSE ‘Active Tickets’
\n END) AS __group__,
\n id AS ticket,
\n (CASE status WHEN ‘assigned’ THEN owner||’ *’ ELSE owner END) AS owner,
\n summary, component, priority, t.type AS type,
\n time AS created,
\n changetime AS _changetime, description AS _description,
\n reporter AS _reporter
\n FROM ticket t, enum p
\n WHERE status IN (‘new’, ‘assigned’, ‘reopened’)
\nAND p.name = t.priority AND p.type = ‘priority’
\n ORDER BY (owner = ‘$USER’) DESC, p.value, milestone, t.type, time
\n[\/CODE]<\/p>\n
\ucd5c\uadfc\ubcc0\uacbd\uc0ac\ud56d\uc740 \ud2f0\ucf13\uc5d0 \uc77c\uc5b4\ub09c \ucd5c\uadfc \ubcc0\uacbd \uc0ac\ud56d\uc744 20\uac1c \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. \ubb3c\ub860 Timeline\uc5d0\uc11c\ub3c4 \ubcfc\uc218 \uc788\uc9c0\ub9cc, Timeline\uc744 \uac1c\ubc1c\uc790\ub9cc \ubcfc\uc218 \uc788\uace0, \uc18c\uc2a4 \ucee4\ubc0b\uacfc\ub294 \ubcc4\ub3c4\ub85c \ubcfc\uc218 \uc788\ub3c4\ub85d \ud558\ub294\uac8c \ud3b8\ub9ac\ud560\uac83 \uac19\uc544\uc11c \ub530\ub85c report\ub97c \uc0dd\uc131\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n
[CODE]
\nSELECT
\n id AS ticket,
\n summary,
\n changetime AS modified,
\n status,
\n component,
\n t.type AS type,
\n (CASE status WHEN ‘assigned’ THEN owner||’ *’ ELSE owner END) AS owner,
\n time AS created,
\n description AS description,
\n reporter AS _reporter
\n FROM ticket t
\n ORDER BY changetime desc limit 0,20
\n[\/CODE]<\/p>\n
\ntrac report \ub9cc\ub4dc\ub294\ub370 \ucc38\uace0\ud560 \ubb38\uc11c\uac00 \ubcc4\ub85c \uc5c6\uc5b4\uc11c \uc880 \ud5e4\ub9f8\ub294\ub370… \uc704\uc5d0\uc11c reporter as _reporter\uc2dd\uc73c\ub85c “as _*”\ub85c \ud558\uba74 \ud14c\uc774\ube14\uc5d0\uc11c \ud56d\ubaa9\uc774 \ud45c\uc2dc\uac00 \uc548\ub429\ub2c8\ub2e4. \uae30\ubcf8 \uc608\uc81c\ub4e4\uc744 \uc790\uc138\ud788 \ubcf4\uba74 \ud56d\ubaa9\uc774 \ubb50\uac00 \uc788\ub294\uc9c0 \ubcfc\uc218 \uc788\uc73c\ubbc0\ub85c \uae30\ubcf8 \uc608\uc81c\ub4e4\uc744 \ucc38\uace0\ud558\uc2dc\uace0 \uc870\uae08\uc529 \ubc14\uafb8\uba74 \uc6d0\ud558\ub294 \ucd9c\ub825\uc744 \uc5bb\uc744\uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n