\uc0ac\uc6a9\uc790\ubcc4 \ucd5c\uadfc \ubcc0\uacbd \uc0ac\ud56d \ubcf4\ub294\ub370 Trac report \ub9cc\ub4dc\ub294\uac8c \uc27d\uc9c0 \uc54a\ub354\uad70\uc694. \ub354 \uc26c\uc6b4 \ubc29\ubc95\uc774 \uc788\ub294\uc9c0 \uc798 \ubaa8\ub974\uaca0\uc9c0\ub9cc… SQL \uc798 \ud558\uc2dc\ub294 \ubd84\uc758 \ub3c4\uc6c0\uc744 \ubc1b\uc544 \ub9cc\ub4e0 \ucffc\ub9ac\uc785\ub2c8\ub2e4. \uc800\ub294 SQL\uc744 \uc798\uac8c \uc9e4\ub77c\uc11c \ub9cc\ub4dc\ub294 \ud3b8\uc778\ub370, SQL \uc870\uae08 \ubcf5\uc7a1\ud574\uc9c0\uba74 \uc5b4\ub835\uace0, \ucd5c\uc801\ud654\ub3c4 \uc5b4\ub824\uc6cc\uc9c0\uc8e0.. \uc0ac\uc6a9\uc790 \uc544\uc774\ub514\uc640 \ucd9c\ub825\ub418\ub294 \uac2f\uc218\uac00 \ud558\ub4dc\ucf54\ub529 \ub418\uc5b4\uc57c \ud574\uc11c \uc880 \uadf8\ub807\uae34 \ud558\uc9c0\ub9cc… \uadf8\ub798\ub3c4 \uc6d0\ud558\ub294\ub300\ub85c \ucd9c\ub825\uc740 \uc798 \ud574\uc90d\ub2c8\ub2e4.<\/p>\n
[code]
\nselect
\n p.value AS __color__,
\n owner AS __group__,
\n id AS ticket,
\n (CASE status WHEN ‘assigned’ THEN owner||’ *’ ELSE owner END) AS owner,
\n summary,
\n component,
\n priority,
\n t.type AS type,
\n status,
\n time AS _created,
\n changetime AS modified,
\n description AS _description,
\n reporter AS _reporter<\/p>\n
from (<\/p>\n
select * from (SELECT * FROM ticket WHERE owner=’mix1009′ ORDER by changetime desc limit 0,5) u1<\/p>\n
union <\/p>\n
select * from (SELECT * FROM ticket WHERE owner=’user2′ ORDER by changetime desc limit 0,5) u2<\/p>\n
union <\/p>\n
select * from (SELECT * FROM ticket WHERE owner=’user3′ ORDER by changetime desc limit 0,5) u3<\/p>\n
union <\/p>\n
select * from (SELECT * FROM ticket WHERE owner=’user4′ ORDER by changetime desc limit 0,5) u4<\/p>\n
union <\/p>\n
select * from (SELECT * FROM ticket WHERE owner=’user5′ ORDER by changetime desc limit 0,5) u5<\/p>\n
\n) t, enum p<\/p>\n
where p.name = t.priority AND p.type = ‘priority’
\norder by owner, changetime desc
\n[\/code]<\/p>\n","protected":false},"excerpt":{"rendered":"
\uc0ac\uc6a9\uc790\ubcc4 \ucd5c\uadfc \ubcc0\uacbd \uc0ac\ud56d \ubcf4\ub294\ub370 Trac report \ub9cc\ub4dc\ub294\uac8c \uc27d\uc9c0 \uc54a\ub354\uad70\uc694. \ub354 \uc26c\uc6b4 \ubc29\ubc95\uc774 \uc788\ub294\uc9c0 \uc798 \ubaa8\ub974\uaca0\uc9c0\ub9cc… SQL \uc798 \ud558\uc2dc\ub294 \ubd84\uc758 \ub3c4\uc6c0\uc744 \ubc1b\uc544 \ub9cc\ub4e0 \ucffc\ub9ac\uc785\ub2c8\ub2e4. \uc800\ub294 SQL\uc744 \uc798\uac8c \uc9e4\ub77c\uc11c \ub9cc\ub4dc\ub294 \ud3b8\uc778\ub370, SQL \uc870\uae08 \ubcf5\uc7a1\ud574\uc9c0\uba74 \uc5b4\ub835\uace0, \ucd5c\uc801\ud654\ub3c4 \uc5b4\ub824\uc6cc\uc9c0\uc8e0.. \uc0ac\uc6a9\uc790 \uc544\uc774\ub514\uc640 \ucd9c\ub825\ub418\ub294 \uac2f\uc218\uac00 \ud558\ub4dc\ucf54\ub529 \ub418\uc5b4\uc57c \ud574\uc11c \uc880 \uadf8\ub807\uae34 \ud558\uc9c0\ub9cc… \uadf8\ub798\ub3c4 \uc6d0\ud558\ub294\ub300\ub85c \ucd9c\ub825\uc740 \uc798 \ud574\uc90d\ub2c8\ub2e4. [code] select p.value […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[31,114],"class_list":["post-146","post","type-post","status-publish","format-standard","hentry","category-19","tag-trac","tag-trac-report"],"_links":{"self":[{"href":"https:\/\/mix1009.net\/index.php?rest_route=\/wp\/v2\/posts\/146","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mix1009.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mix1009.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mix1009.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mix1009.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=146"}],"version-history":[{"count":0,"href":"https:\/\/mix1009.net\/index.php?rest_route=\/wp\/v2\/posts\/146\/revisions"}],"wp:attachment":[{"href":"https:\/\/mix1009.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=146"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mix1009.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=146"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mix1009.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=146"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}