{"id":5763,"date":"2023-03-24T18:11:31","date_gmt":"2023-03-24T09:11:31","guid":{"rendered":"\/blog\/?p=5763"},"modified":"2024-04-26T15:39:23","modified_gmt":"2024-04-26T06:39:23","slug":"ssc-birt-%eb%a6%ac%ed%8f%ac%ed%8a%b8-%ec%9e%91%ec%84%b1-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=5763","title":{"rendered":"SSC BIRT \ub9ac\ud3ec\ud2b8 \uc791\uc131 \ubc29\ubc95"},"content":{"rendered":"\n1.plugins\\org.eclipse.birt.report.data.oda.jdbc_4.9.0.v202203150031\\drivers\uc5d0 JDBC\ub97c \ub123\ub294\ub2e4.(\ubcf5\uc218 \uac00\ub2a5)

2.Data Explorer > Data Sources | New Data Source > JDBC Data Source
  Data source\ub97c \uc785\ub825\ud558\uace0 \uc5f0\ub3d9\ud55c\ub2e4.

  \u25a8Sample:
    MYSQL: jdbc:mysql:\/\/10.10.10.105:3306\/db_ssc_2220?connectionCollation=utf8mb3_bin&rewriteBatchedStatements=true
    Oracle: jdbc:oracle:thin:@10.10.10.105:1521:orcl
    MS-SQL: jdbc:sqlserver:\/\/10.10.10.105:1433;database=db_ssc_2020;connectionCollation=korean_wansung_cs_as;sendStringParametersAsUnicode=false

3.Data Explorer > Data Sets | New Data Set
  \u2460Query Text\ub97c \uc785\ub825\ud55c\ub2e4.
  \u2461ApplicationID\ub85c \ucc98\ub9ac\ub420 \ubd80\ubd84\uc740 Query\uc5d0\uc11c \"WHERE projectversion.id IN @ID\"\ub85c \ucc98\ub9ac\ud55c\ub2e4.
    \ud14c\uc2a4\ud2b8 \uc2dc\uc5d0\ub294 (2) \uc640 \uac19\uc774 projectversion \ud14c\uc774\ube14\uc5d0\uc11c \uc2e4\uc874\ud558\ub294 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ubc88\ud638\ub97c \uad04\ud638\ub85c \ubb36\uc5b4 \ub123\uc5b4\uc900\ub2e4.
  \u2462\ubcc0\uc218 \uc801\uc6a9\uc774 \ud544\uc694\ud55c \uacbd\uc6b0 Query\uc5d0\uc11c \ubcc0\uc218 \ubd80\ubd84\uc744 \"?\"\ub85c \ucc98\ub9ac\ud558\uace0 Parameters\uc5d0\uc11c \ucd94\uac00\ud574 \uc900\ub2e4.
  \u203bOracle\uc740 AS \uad6c\ubb38 \ub4a4\uc5d0 'Alias\uba85'\uc740 \ud5c8\uc6a9\ud558\uc9c0 \uc54a\ub294\ub2e4. \"Alias\uba85\"\uc73c\ub85c \uc791\uc131\ud574\uc57c \ud55c\ub2e4.
  \u203bOracle\uc740 SQL \ub05d\uc5d0 ;\uc73c\ub85c \ub05d\uc744 \ub0b4\uba74 \uc548\ub41c\ub2e4. ;\uc744 \uc81c\uac70\ud574\uc57c \ud55c\ub2e4.

4.Outline > MasterPages > General \uc5d0\uc11c \ud398\uc774\uc9c0 \uc124\uc815

5.Data Sets > (My data set) \ud074\ub9ad
  Property Editor > Properties > Advanced > Before open: queryText = queryText.replace(\"@ID\", params[\"projectversionids\"]);
  \u203b\ud14c\uc2a4\ud2b8 \uc2dc\uc5d0\ub294 @ID\ub97c \uc2e4\uc874\ud558\ub294 projectversion \ubc88\ud638\ub97c \ub123\uc5b4\uc900\ub2e4.

6.\uba54\uc778 > \ub9ac\ud3ec\ud2b8\ub97c \uadf8\ub9ac\uae30 \uc704\ud574 \ud14c\uc774\ube14 \ucd94\uac00

7.\ud574\ub2f9 Data Set\uc758 \ubcc0\uc218\ub97c \ud558\ub098\uc529 \ud14c\uc774\ube14\uc5d0 \ub4dc\ub798\uadf8 \uc564 \ub4dc\ub86d\uc73c\ub85c \uc62e\uae40

8.\uba54\uc778 > \ud558\ub2e8 Master Page \ud0ed > \ubd88\ud544\uc694\ud55c \uad6c\uc131\uc694\uc18c \uc0ad\uc81c

\u203bFortify SSC 18.2.0\uc740 Report XML\uc758 \ubc84\uc804\uc774 3.2.23(BIRT 4.8.0) \uc774\ud558\ub9cc \uc778\uc2dd\ub428.

9.Fortify SSC\uc5d0 \ub4f1\ub85d

ADMINISTRATION > Templates > Reports > IMPORT

Name: XXXXX
Category: Issue Reports
Report Engine: BIRT
Template: IssueCountByProjectVerson.rptdesign

+ADD PARAMETER
Name: projectversionids
Identifier: projectversionids
Data Type: Multiple Application Version<\/span>\n","protected":false},"excerpt":{"rendered":"

1.plugins\\org.eclipse.birt.report.data.oda.jdbc_4.9.0.v202203150031\\drivers\uc5d0 JDBC\ub97c \ub123\ub294\ub2e4.(\ubcf5\uc218 \uac00\ub2a5) 2.Data Explorer > Data Sources | New Data Source > JDBC Data Source  Data source\ub97c \uc785\ub825\ud558\uace0 \uc5f0\ub3d9\ud55c\ub2e4.   \u25a8Sample:    MYSQL: jdbc:mysql:\/\/10.10.10.105:3306\/db_ssc_2220?connectionCollation=utf8mb3_bin&rewriteBatchedStatements=true    Oracle: jdbc:oracle:thin:@10.10.10.105:1521:orcl    MS-SQL: jdbc:sqlserver:\/\/10.10.10.105:1433;database=db_ssc_2020;connectionCollation=korean_wansung_cs_as;sendStringParametersAsUnicode=false 3.Data Explorer > Data Sets | New Data Set  \u2460Query Text\ub97c \uc785\ub825\ud55c\ub2e4.  \u2461ApplicationID\ub85c \ucc98\ub9ac\ub420 \ubd80\ubd84\uc740 Query\uc5d0\uc11c “WHERE projectversion.id IN @ID”\ub85c \ucc98\ub9ac\ud55c\ub2e4.    \ud14c\uc2a4\ud2b8 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","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":[66],"tags":[],"class_list":["post-5763","post","type-post","status-publish","format-standard","hentry","category-computing_fortify"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/5763","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=5763"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/5763\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5763"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5763"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5763"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}