{"id":7899,"date":"2023-11-29T17:50:08","date_gmt":"2023-11-29T08:50:08","guid":{"rendered":"\/blog\/?p=7899"},"modified":"2023-11-29T17:50:09","modified_gmt":"2023-11-29T08:50:09","slug":"sql","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=7899","title":{"rendered":"SQL"},"content":{"rendered":"\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT A.name                      AS '\uc560\ud50c\ub9ac\ucf00\uc774\uc158',\n       B.name                      AS '\ubc84\uc804\uba85',\n       (SELECT TOP 1 CONVERT(VARCHAR(20), artifact.uploadDate, 20)\n        FROM   artifact\n        WHERE  artifact.projectVersion_id = B.project_id\n        ORDER  BY uploadDate DESC) AS '\ub0a0\uc9dc',\n       C.friority                  AS '\uc704\ud5d8\ub3c4',\n       C.kingdom                   AS '\ucde8\uc57d\uc810 \ub300\ubd84\ub958',\n       C.issueType                 AS '\ucde8\uc57d\uc810 \uc911\ubd84\ub958',\n       C.issueSubtype              AS '\ucde8\uc57d \uc810 \uc18c\ubd84\ub958',\n       C.fileName                  AS '\ucde8\uc57d\uc810 \uacbd\ub85c',\n       C.packageName               AS '\ucde8\uc57d\uc810 \ud328\ud0a4\uc9c0',\n       C.className                 AS '\ucde8\uc57d\uc810 \ud074\ub798\uc2a4',\n       C.functionName              AS '\ucde8\uc57d\uc810 \uba54\uc18c\ub4dc',\n       C.lineNumber                AS '\ucde8\uc57d\uc810 \ub77c\uc778'\nFROM   project AS A\n       INNER JOIN projectversion AS B\n               ON A.id = B.project_id\n       INNER JOIN issue AS C\n               ON B.id = C.projectVersion_id\nWHERE  C.hidden = 'N'\n       AND C.suppressed = 'N'\n       AND C.scanStatus &lt;> 'REMOVED'\n       AND C.friority &lt;> 'Medium'\n       AND C.friority &lt;> 'Low'\nGROUP  BY A.name,\n          B.name,\n          C.friority,\n          C.kingdom,\n          C.issueType,\n          C.issueSubtype,\n          C.fileName,\n          C.lineNumber,\n          C.packageName,\n          C.className,\n          C.functionName,\n          B.project_id;<\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[45],"tags":[],"class_list":["post-7899","post","type-post","status-publish","format-standard","hentry","category-private_memo"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/7899","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7899"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/7899\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7899"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7899"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7899"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}