[汇科天下] Pages Feed
Confluence Syndication Feed
https://confluence.hktx.cn
07-数据库库表结构
张扬
tag:confluence.hktx.cn,2009:page-58884666-8
2024-03-25T13:12:28Z
2019-12-17T07:10:59Z
<div class="feed"> <p>
Page
<b>edited</b> by
<a href=" https://confluence.hktx.cn/display/~zhangyang
">张扬</a>
</p>
<div style="border-top: 1px solid #ddd; border-bottom: 1px solid #ddd; padding: 10px;">
<p>
<div class="plugin_attachments_container">
<div class="plugin_attachments_table_container">
<fieldset class="hidden">
<input type="hidden" class="plugin_attachments_macro_render_param" name="pageId" value="58884666">
<input type="hidden" name="deleteConfirmMessage" value="Are you sure you want to send the attached file "{0}" to the trash? Only a space administrator can undo this action."/>
<input type="hidden" name="outputType" value="feed">
</fieldset>
<table class="attachments aui">
<thead>
<tr>
<th class="expand-column attachment-summary-toggle"> </th>
<th class="filename-column"> <a href="/pages/viewpage.action?pageId=58884666&sortBy=name&sortOrder=ascending">File</a>
</th>
<th class="modified-column"> <span class="propersortedby $sortOrder"><a href="/pages/viewpage.action?pageId=58884666&sortBy=date&sortOrder=descending">Modified</a></span>
</th>
</tr>
</thead>
<tbody>
<tr id="attachment-58884667"
class="attachment-row"
data-attachment-id="58884667"
data-attachment-idx="1">
<td class="attachment-summary-toggle">
<span class="icon icon-section-closed" title="Show more info"></span>
</td>
<td class="filename-column">
<span class="aui-icon content-type-attachment-pdf" title="PDF File">PDF File</span> <a class="filename" href="/download/attachments/58884666/jira70_schema.pdf?api=v2"
title="Download"
data-filename="jira70_schema.pdf"
data-type="application/pdf"
data-linked-resource-container-id="58884666">
jira70_schema.pdf
</a>
</td>
<td class="attachment-created modified-column">
<span>2019-12-17</span>
<span>by</span>
<a href=" /display/~gears
"
class="url fn"
>红旗公</a> </td>
</tr>
<tr class="attachment-summary attachment-summary-58884667 hidden"
data-attachment-id="58884667"
data-attachment-filename="jira70_schema.pdf">
<td class="attachment-summary-toggle"></td>
<td class="attachment-details-wrapper" colspan="2">
<div class="attachment-image-preview"></div>
<p class="attachment-labels">Labels</p>
<div class="labels-section-content content-column" entityid="58884667" entitytype="attachment">
<div class="labels-content">
<ul class="label-list ">
<li class="no-labels-message">
No labels
</li>
</ul>
</div>
</div>
<div class="attachment-history-wrapper"></div>
<div class="attachment-buttons">
<a class="aui-button previewAttachmentLink"
data-filename="jira70_schema.pdf"
data-file-src="/download/attachments/58884666/jira70_schema.pdf?api=v2"
data-linked-resource-default-alias="jira70_schema.pdf"
data-mime-type="application/pdf"
data-linked-resource-container-id="58884666"
data-linked-resource-id="58884667">Preview</a>
<a class="aui-button preview-attachment-link" href="/pages/worddav/preview.action?fileName=jira70_schema.pdf&pageId=58884666" >View</a>
</div>
</td>
</tr>
<tr id="attachment-101288782"
class="attachment-row"
data-attachment-id="101288782"
data-attachment-idx="2">
<td class="attachment-summary-toggle">
<span class="icon icon-section-closed" title="Show more info"></span>
</td>
<td class="filename-column">
<span class="aui-icon content-type-attachment-pdf" title="PDF File">PDF File</span> <a class="filename" href="/download/attachments/58884666/Jira7.9.2-db-schema.pdf?api=v2"
title="Download"
data-filename="Jira7.9.2-db-schema.pdf"
data-type="application/pdf"
data-linked-resource-container-id="58884666">
Jira7.9.2-db-schema.pdf
</a>
</td>
<td class="attachment-created modified-column">
<span>2021-05-10</span>
<span>by</span>
<a href=" /display/~gears
"
class="url fn"
>红旗公</a> </td>
</tr>
<tr class="attachment-summary attachment-summary-101288782 hidden"
data-attachment-id="101288782"
data-attachment-filename="Jira7.9.2-db-schema.pdf">
<td class="attachment-summary-toggle"></td>
<td class="attachment-details-wrapper" colspan="2">
<div class="attachment-image-preview"></div>
<p class="attachment-labels">Labels</p>
<div class="labels-section-content content-column" entityid="101288782" entitytype="attachment">
<div class="labels-content">
<ul class="label-list ">
<li class="no-labels-message">
No labels
</li>
</ul>
</div>
</div>
<div class="attachment-history-wrapper"></div>
<div class="attachment-buttons">
<a class="aui-button previewAttachmentLink"
data-filename="Jira7.9.2-db-schema.pdf"
data-file-src="/download/attachments/58884666/Jira7.9.2-db-schema.pdf?api=v2"
data-linked-resource-default-alias="Jira7.9.2-db-schema.pdf"
data-mime-type="application/pdf"
data-linked-resource-container-id="58884666"
data-linked-resource-id="101288782">Preview</a>
<a class="aui-button preview-attachment-link" href="/pages/worddav/preview.action?fileName=Jira7.9.2-db-schema.pdf&pageId=58884666" >View</a>
</div>
</td>
</tr>
<tr id="attachment-139919728"
class="attachment-row"
data-attachment-id="139919728"
data-attachment-idx="3">
<td class="attachment-summary-toggle">
<span class="icon icon-section-closed" title="Show more info"></span>
</td>
<td class="filename-column">
<span class="aui-icon content-type-attachment-pdf" title="PDF File">PDF File</span> <a class="filename" href="/download/attachments/58884666/jira_8.20_database_schema.pdf?api=v2"
title="Download"
data-filename="jira_8.20_database_schema.pdf"
data-type="application/pdf"
data-linked-resource-container-id="58884666">
jira_8.20_database_schema.pdf
</a>
</td>
<td class="attachment-created modified-column">
<span>2022-07-25</span>
<span>by</span>
<a href=" /display/~gears
"
class="url fn"
>红旗公</a> </td>
</tr>
<tr class="attachment-summary attachment-summary-139919728 hidden"
data-attachment-id="139919728"
data-attachment-filename="jira_8.20_database_schema.pdf">
<td class="attachment-summary-toggle"></td>
<td class="attachment-details-wrapper" colspan="2">
<div class="attachment-image-preview"></div>
<p class="attachment-labels">Labels</p>
<div class="labels-section-content content-column" entityid="139919728" entitytype="attachment">
<div class="labels-content">
<ul class="label-list ">
<li class="no-labels-message">
No labels
</li>
</ul>
</div>
</div>
<div class="attachment-history-wrapper"></div>
<div class="attachment-buttons">
<a class="aui-button previewAttachmentLink"
data-filename="jira_8.20_database_schema.pdf"
data-file-src="/download/attachments/58884666/jira_8.20_database_schema.pdf?api=v2"
data-linked-resource-default-alias="jira_8.20_database_schema.pdf"
data-mime-type="application/pdf"
data-linked-resource-container-id="58884666"
data-linked-resource-id="139919728">Preview</a>
<a class="aui-button preview-attachment-link" href="/pages/worddav/preview.action?fileName=jira_8.20_database_schema.pdf&pageId=58884666" >View</a>
</div>
</td>
</tr>
<tr id="attachment-207552532"
class="attachment-row"
data-attachment-id="207552532"
data-attachment-idx="4">
<td class="attachment-summary-toggle">
<span class="icon icon-section-closed" title="Show more info"></span>
</td>
<td class="filename-column">
<span class="aui-icon content-type-attachment-word97" title="Microsoft Word 97 Document">Microsoft Word 97 Document</span> <a class="filename" href="/download/attachments/58884666/jira%E6%95%B0%E6%8D%AE%E5%BA%93%E6%9F%A5%E8%AF%A2sql%E7%A4%BA%E4%BE%8B%E5%8F%82%E8%80%83.doc?api=v2"
title="Download"
data-filename="jira数据库查询sql示例参考.doc"
data-type="application/msword"
data-linked-resource-container-id="58884666">
jira数据库查询sql示例参考.doc
</a>
</td>
<td class="attachment-created modified-column">
<span>2024-03-22</span>
<span>by</span>
<a href=" /display/~matengfei
"
class="url fn"
>马腾飞</a> </td>
</tr>
<tr class="attachment-summary attachment-summary-207552532 hidden"
data-attachment-id="207552532"
data-attachment-filename="jira数据库查询sql示例参考.doc">
<td class="attachment-summary-toggle"></td>
<td class="attachment-details-wrapper" colspan="2">
<p class="attachment-labels">Labels</p>
<div class="labels-section-content content-column" entityid="207552532" entitytype="attachment">
<div class="labels-content">
<ul class="label-list ">
<li class="no-labels-message">
No labels
</li>
</ul>
</div>
</div>
<div class="attachment-history-wrapper"></div>
<div class="attachment-buttons">
<a class="aui-button previewAttachmentLink"
data-filename="jira数据库查询sql示例参考.doc"
data-file-src="/download/attachments/58884666/jira%E6%95%B0%E6%8D%AE%E5%BA%93%E6%9F%A5%E8%AF%A2sql%E7%A4%BA%E4%BE%8B%E5%8F%82%E8%80%83.doc?api=v2"
data-linked-resource-default-alias="jira数据库查询sql示例参考.doc"
data-mime-type="application/msword"
data-linked-resource-container-id="58884666"
data-linked-resource-id="207552532">Preview</a>
<a class="aui-button preview-attachment-link" href="/pages/worddav/preview.action?fileName=jira%E6%95%B0%E6%8D%AE%E5%BA%93%E6%9F%A5%E8%AF%A2sql%E7%A4%BA%E4%BE%8B%E5%8F%82%E8%80%83.doc&pageId=58884666" >View</a>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<div class="plugin_attachments_upload_container">
</div>
<div>
<a class="download-all-link" href="/pages/downloadallattachments.action?pageId=58884666" title="Download all the latest versions of attachments on this page as single zip file.">Download All</a>
</div>
</div>
</p><p><br/></p><h1 id="id-07数据库库表结构-示例">示例</h1><div class="confluence-information-macro confluence-information-macro-tip"><span class="aui-icon aui-icon-small aui-iconfont-approve confluence-information-macro-icon"></span><div class="confluence-information-macro-body"><p><span style="color: rgb(255,0,0);">示例仅供参考,请勿直接在生产环境运行,否则可能导致生产数据库负载异常!!!</span></p></div></div><p><br/></p><h2 id="id-07数据库库表结构-查询项目">查询项目</h2><p>GEARS为需要导出的项目的KEY值</p><div class="code panel pdl" style="border-width: 1px;"><div class="codeContent panelContent pdl">
<pre class="syntaxhighlighter-pre" data-syntaxhighlighter-params="brush: java; gutter: false; theme: Confluence" data-theme="Confluence">SELECT ID,PKEY FROM project WHERE PKEY = 'GEARS'</pre>
</div></div><p><br/></p><h2 id="id-07数据库库表结构-查询项目下的问题">查询项目下的问题</h2><div class="code panel pdl" style="border-width: 1px;">
<div class="codeHeader panelHeader pdl hide-border-bottom">
<b class="code-title"></b>
<span class="collapse-source expand-control" style="display:none;"><span class="expand-control-icon icon"> </span><span class="expand-control-text">Expand source</span></span>
<span class="collapse-spinner-wrapper"></span>
</div>
<div class="codeContent panelContent pdl hide-toolbar">
<pre class="syntaxhighlighter-pre" data-syntaxhighlighter-params="brush: java; gutter: true; theme: Confluence; collapse: true" data-theme="Confluence">SELECT a.id,
b.pkey,
issuenum,
TIMEORIGINALESTIMATE,
TIMEESTIMATE,
TIMESPENT,
created,
updated,
creator
FROM
jiraissue a,
project b
WHERE
b.PKEY = 'GEARS' AND a.project = b.id;</pre>
</div>
</div><h2 id="id-07数据库库表结构-查询问题的字段数据">查询问题的字段数据</h2><div class="code panel pdl" style="border-width: 1px;">
<div class="codeHeader panelHeader pdl hide-border-bottom">
<b class="code-title"></b>
<span class="collapse-source expand-control" style="display:none;"><span class="expand-control-icon icon"> </span><span class="expand-control-text">Expand source</span></span>
<span class="collapse-spinner-wrapper"></span>
</div>
<div class="codeContent panelContent pdl hide-toolbar">
<pre class="syntaxhighlighter-pre" data-syntaxhighlighter-params="brush: java; gutter: true; theme: Confluence; collapse: true" data-theme="Confluence">SELECT
j.REPORTER,
j.ASSIGNEE,
j.CREATOR,
j.SUMMARY,
j.DESCRIPTION,
j.CREATED,
j.UPDATED,
j.DUEDATE,
j.RESOLUTIONDATE,
j.COMPONENT,
cf.cfname,
cf.CUSTOMFIELDTYPEKEY,
cfv.CUSTOMFIELD,
cfv.STRINGVALUE,
cfv.TEXTVALUE,
cfv.NUMBERVALUE,
cfv.DATEVALUE,
cfv.VALUETYPE ,
cfo.customvalue
FROM
jiraissue j
LEFT JOIN customfieldvalue cfv ON j.ID = cfv.ISSUE
LEFT JOIN customfield cf ON cfv.CUSTOMFIELD = cf.ID
LEFT JOIN customfieldoption cfo on cfv.STRINGVALUE=cfo.ID
WHERE
j.issuenum = 8 -- 比如issuekey=DEMO-8,这里的issuenum=8
AND j.PROJECT = 10001;</pre>
</div>
</div><p><br/></p><h2 id="id-07数据库库表结构-查询评论信息">查询评论信息</h2><div class="code panel pdl" style="border-width: 1px;">
<div class="codeHeader panelHeader pdl hide-border-bottom">
<b class="code-title"></b>
<span class="collapse-source expand-control" style="display:none;"><span class="expand-control-icon icon"> </span><span class="expand-control-text">Expand source</span></span>
<span class="collapse-spinner-wrapper"></span>
</div>
<div class="codeContent panelContent pdl hide-toolbar">
<pre class="syntaxhighlighter-pre" data-syntaxhighlighter-params="brush: java; gutter: true; theme: Confluence; collapse: true" data-theme="Confluence">SELECT
*
FROM
jiraaction aa
WHERE
aa.issueid IN (
SELECT
a.id
FROM
jiraissue a,
project b
WHERE
b.PKEY = 'GEARS'
AND a.project = b.id);</pre>
</div>
</div><p><br/></p><h2 id="id-07数据库库表结构-查询附件">查询附件</h2><div class="code panel pdl" style="border-width: 1px;">
<div class="codeHeader panelHeader pdl hide-border-bottom">
<b class="code-title"></b>
<span class="collapse-source expand-control" style="display:none;"><span class="expand-control-icon icon"> </span><span class="expand-control-text">Expand source</span></span>
<span class="collapse-spinner-wrapper"></span>
</div>
<div class="codeContent panelContent pdl hide-toolbar">
<pre class="syntaxhighlighter-pre" data-syntaxhighlighter-params="brush: java; gutter: true; theme: Confluence; collapse: true" data-theme="Confluence">SELECT
*
FROM
fileattachment aa
WHERE
aa.issueid IN (
SELECT
a.id
FROM
jiraissue a,
project b
WHERE
b.PKEY = 'GEARS'
AND a.project = b.id)</pre>
</div>
</div><p><br/></p><h2 id="id-07数据库库表结构-查询工时日志">查询工时日志</h2><div class="code panel pdl" style="border-width: 1px;">
<div class="codeHeader panelHeader pdl hide-border-bottom">
<b class="code-title"></b>
<span class="collapse-source expand-control" style="display:none;"><span class="expand-control-icon icon"> </span><span class="expand-control-text">Expand source</span></span>
<span class="collapse-spinner-wrapper"></span>
</div>
<div class="codeContent panelContent pdl hide-toolbar">
<pre class="syntaxhighlighter-pre" data-syntaxhighlighter-params="brush: java; gutter: true; theme: Confluence; collapse: true" data-theme="Confluence">SELECT
*
FROM
worklog aa
WHERE
aa.issueid IN (
SELECT
a.id
FROM
jiraissue a,
project b
WHERE
b.PKEY = 'GEARS'
AND a.project = b.id)</pre>
</div>
</div><p><br/></p><h2 id="id-07数据库库表结构-查询变更历史">查询变更历史</h2><p>变更历史</p><div class="code panel pdl" style="border-width: 1px;">
<div class="codeHeader panelHeader pdl hide-border-bottom">
<b class="code-title"></b>
<span class="collapse-source expand-control" style="display:none;"><span class="expand-control-icon icon"> </span><span class="expand-control-text">Expand source</span></span>
<span class="collapse-spinner-wrapper"></span>
</div>
<div class="codeContent panelContent pdl hide-toolbar">
<pre class="syntaxhighlighter-pre" data-syntaxhighlighter-params="brush: java; gutter: true; theme: Confluence; collapse: true" data-theme="Confluence">SELECT
*
FROM
changegroup aa
WHERE
aa.issueid IN (
SELECT
a.id
FROM
jiraissue a,
project b
WHERE
b.PKEY = 'GEARS'
AND a.project = b.id
)</pre>
</div>
</div><p><br/></p><p>变更详情</p><div class="code panel pdl" style="border-width: 1px;">
<div class="codeHeader panelHeader pdl hide-border-bottom">
<b class="code-title"></b>
<span class="collapse-source expand-control" style="display:none;"><span class="expand-control-icon icon"> </span><span class="expand-control-text">Expand source</span></span>
<span class="collapse-spinner-wrapper"></span>
</div>
<div class="codeContent panelContent pdl hide-toolbar">
<pre class="syntaxhighlighter-pre" data-syntaxhighlighter-params="brush: java; gutter: true; theme: Confluence; collapse: true" data-theme="Confluence">SELECT
*
FROM
changeitem bb
WHERE
bb.groupid IN (
SELECT
id
FROM
changegroup aa
WHERE
aa.issueid IN ( SELECT a.id FROM jiraissue a, project b WHERE b.PKEY = 'GEARS' AND a.project = b.id )
)</pre>
</div>
</div><p><br/></p><p><br/></p><p><br/></p><h2 id="id-07数据库库表结构-链接关系">链接关系</h2><p>基础数据</p><div class="code panel pdl" style="border-width: 1px;">
<div class="codeHeader panelHeader pdl hide-border-bottom">
<b class="code-title"></b>
<span class="collapse-source expand-control" style="display:none;"><span class="expand-control-icon icon"> </span><span class="expand-control-text">Expand source</span></span>
<span class="collapse-spinner-wrapper"></span>
</div>
<div class="codeContent panelContent pdl hide-toolbar">
<pre class="syntaxhighlighter-pre" data-syntaxhighlighter-params="brush: java; gutter: true; theme: Confluence; collapse: true" data-theme="Confluence">SELECT * FROM issuelinktype</pre>
</div>
</div><p><br/></p><p>业务数据</p><div class="code panel pdl" style="border-width: 1px;">
<div class="codeHeader panelHeader pdl hide-border-bottom">
<b class="code-title"></b>
<span class="collapse-source expand-control" style="display:none;"><span class="expand-control-icon icon"> </span><span class="expand-control-text">Expand source</span></span>
<span class="collapse-spinner-wrapper"></span>
</div>
<div class="codeContent panelContent pdl hide-toolbar">
<pre class="syntaxhighlighter-pre" data-syntaxhighlighter-params="brush: java; gutter: true; theme: Confluence; collapse: true" data-theme="Confluence">SELECT * FROM issuelink aa WHERE source IN(
SELECT a.id FROM jiraissue a,project b WHERE b.PKEY = 'GEARS'
AND a.project = b.id
)
UNION
SELECT * FROM issuelink aa WHERE destination IN(
SELECT a.id FROM jiraissue a,project b WHERE b.PKEY = 'GEARS'
AND a.project = b.id
)</pre>
</div>
</div><p><br/></p><p><br/></p><h2 id="id-07数据库库表结构-关注和投票">关注和投票</h2><div class="code panel pdl" style="border-width: 1px;">
<div class="codeHeader panelHeader pdl hide-border-bottom">
<b class="code-title"></b>
<span class="collapse-source expand-control" style="display:none;"><span class="expand-control-icon icon"> </span><span class="expand-control-text">Expand source</span></span>
<span class="collapse-spinner-wrapper"></span>
</div>
<div class="codeContent panelContent pdl hide-toolbar">
<pre class="syntaxhighlighter-pre" data-syntaxhighlighter-params="brush: java; gutter: true; theme: Confluence; collapse: true" data-theme="Confluence">SELECT
*
FROM
userassociation aa
WHERE
aa.`SINK_NODE_ENTITY` = 'Issue'
AND aa.`ASSOCIATION_TYPE` = 'WatchIssue'
AND aa.sink_node_id IN (
SELECT
a.id
FROM
jiraissue a,
project b
WHERE
b.PKEY = 'GEARS'
AND a.project = b.id
)</pre>
</div>
</div><p><br/></p><h2 id="id-07数据库库表结构-人员关系对照表">人员关系对照表</h2><div class="code panel pdl" style="border-width: 1px;">
<div class="codeHeader panelHeader pdl hide-border-bottom">
<b class="code-title"></b>
<span class="collapse-source expand-control" style="display:none;"><span class="expand-control-icon icon"> </span><span class="expand-control-text">Expand source</span></span>
<span class="collapse-spinner-wrapper"></span>
</div>
<div class="codeContent panelContent pdl hide-toolbar">
<pre class="syntaxhighlighter-pre" data-syntaxhighlighter-params="brush: java; gutter: true; theme: Confluence; collapse: true" data-theme="Confluence">SELECT bb.`lower_user_name`,bb.`user_key`,aa.`email_address`,aa.`display_name` FROM cwd_user aa,app_user bb
WHERE aa.`lower_user_name` = bb.`lower_user_name`</pre>
</div>
</div><p><br/></p><h2 id="id-07数据库库表结构-模块(版本/问题类型页面方案/通知方案/权限方案/工作流方案/安全级别方案)">模块(版本/问题类型页面方案/通知方案/权限方案/工作流方案/安全级别方案)</h2><div class="confluence-information-macro confluence-information-macro-tip"><span class="aui-icon aui-icon-small aui-iconfont-approve confluence-information-macro-icon"></span><div class="confluence-information-macro-body"><ul><li>版本(SINK_NODE_ENTITY = 'Version')</li><li>问题类型页面方案(SINK_NODE_ENTITY=‘IssueTypeScreenScheme’)</li><li>通知方案(SINK_NODE_ENTITY =‘NotificationScheme’)</li><li>权限方案(SINK_NODE_ENTITY =‘PermissionScheme’)</li><li>工作流方案(SINK_NODE_ENTITY =‘WorkflowScheme’)</li><li>安全级别方案(SINK_NODE_ENTITY =‘IssueSecurityScheme’)</li></ul></div></div><div class="code panel pdl" style="border-width: 1px;">
<div class="codeHeader panelHeader pdl hide-border-bottom">
<b class="code-title"></b>
<span class="collapse-source expand-control" style="display:none;"><span class="expand-control-icon icon"> </span><span class="expand-control-text">Expand source</span></span>
<span class="collapse-spinner-wrapper"></span>
</div>
<div class="codeContent panelContent pdl hide-toolbar">
<pre class="syntaxhighlighter-pre" data-syntaxhighlighter-params="brush: java; gutter: true; theme: Confluence; collapse: true" data-theme="Confluence">SELECT
na.SOURCE_NODE_ID as "问题id",
na.SINK_NODE_ID as "模块id",
c.cname as "模块名称"
FROM
nodeassociation na
LEFT JOIN component c on na.SINK_NODE_ID=c.ID
WHERE
SOURCE_NODE_ID = 10939
AND SINK_NODE_ENTITY = 'Component';</pre>
</div>
</div><p><br/></p><p><br/></p><p><br/></p><p><br/></p>
</div>
<div style="padding: 10px 0;">
<a href="https://confluence.hktx.cn/pages/viewpage.action?pageId=58884666">View Online</a>
·
<a href="https://confluence.hktx.cn/pages/diffpagesbyversion.action?pageId=58884666&revisedVersion=8&originalVersion=7">View Changes Online</a>
</div>
</div>
张扬
2019-12-17T07:10:59Z
01-JIRA各版本重要特性变更
红旗公
tag:confluence.hktx.cn,2009:page-174817501-4
2024-03-25T01:13:18Z
2023-09-17T09:17:26Z
<div class="feed"> <p>
Page
<b>edited</b> by
<a href=" https://confluence.hktx.cn/display/~gears
">红旗公</a>
</p>
<div style="border-top: 1px solid #ddd; border-bottom: 1px solid #ddd; padding: 10px;">
<div class="table-wrap"><table class="relative-table wrapped confluenceTable" style="width: 66.2722%;"><colgroup><col style="width: 28.4845%;"/><col style="width: 71.5283%;"/></colgroup><tbody><tr><th class="confluenceTh">版本</th><th class="confluenceTh">重要变更项</th></tr><tr><td colspan="1" class="confluenceTd">9.14</td><td colspan="1" class="confluenceTd"><p>自动化增加归档功能</p><p>采用新有健康检查模式</p></td></tr><tr><td colspan="1" class="confluenceTd">9.13</td><td colspan="1" class="confluenceTd"><p>详情页中默认查看最旧或最新显示的评论</p><p>可同时更新多个问题的描述</p><p>创建问题时可直接增加关注者</p></td></tr><tr><td colspan="1" class="confluenceTd">9.12</td><td colspan="1" class="confluenceTd">LTS版本,无新特性</td></tr><tr><td colspan="1" class="confluenceTd">9.11</td><td colspan="1" class="confluenceTd"><p>项目快捷方式可以重新排序</p><p>项目权限获取扩展配置</p><p>仅从有权访问您的项目的用户中选择问题watcher</p><p>Rich Text小工具替代了弃用的Text小工具</p><p>使用AWS Secrets Manager管理Jira软件配置</p></td></tr><tr><td colspan="1" class="confluenceTd">9.10</td><td colspan="1" class="confluenceTd"><p>在自定义字段上下文中搜索项目和问题类型</p><p>一键将链接的问题添加到现有问题</p></td></tr><tr><td colspan="1" class="confluenceTd">9.9</td><td colspan="1" class="confluenceTd"><p>自定义字段改进</p><p>在快速搜索中禁用智能查询</p><p>用于传入邮件的Microsoft Graph API集成</p></td></tr><tr><td colspan="1" class="confluenceTd">9.8</td><td colspan="1" class="confluenceTd"><p>改进的评论体验</p><p>自动管理冲刺</p><p>更新邮件队列运行状况检查</p></td></tr><tr><td colspan="1" class="confluenceTd">9.7</td><td colspan="1" class="confluenceTd"><p>为自定义字段配置上下文:新设计、增强功能</p><p>在Jira问题详情页增加Pin评论</p><p>修复了对选择列表(级联)类型的必需自定义字段的验证</p><p>提供对索引快照进行恢复功能</p><p>新的邮件队列健康检查可确保发送电子邮件时没有任何问题</p></td></tr><tr><td colspan="1" class="confluenceTd">9.6</td><td colspan="1" class="confluenceTd"><p>用户同时时,采用热量群组成员身份更改</p><p>放弃 Cache API</p><p>jira.diagnostics.ipdlog.poll.seconds系统属性已从产品内诊断中删除</p></td></tr><tr><td colspan="1" class="confluenceTd">9.5</td><td colspan="1" class="confluenceTd"><p>Jira采用Log4j2</p><p>审核日志改进</p><p>产品内诊断更新:增加REST API和性能指标</p><p>开始对Java 17的支持</p><p>增加定时功能对Jira临时目录 文件进行清理</p></td></tr><tr><td colspan="1" class="confluenceTd">9.4</td><td colspan="1" class="confluenceTd"><p>LTS版本</p></td></tr><tr><td colspan="1" class="confluenceTd">9.3</td><td colspan="1" class="confluenceTd"><p>提供多线程进行索引,加快索引速度</p><p>提高了数据库使用情况下应用程序准确性</p><p>用于产品内诊断的新数据库连接度量</p><p>修复活动选项卡BUG</p></td></tr><tr><td colspan="1" class="confluenceTd">9.2</td><td colspan="1" class="confluenceTd"><p>JIRA面板优化,改进加载</p><p>使用OAuth 2.0集成外发邮件</p><p>提供picker来获得性能的监控信息</p><p>通过JFlight Recorde来配置相关诊断信息</p></td></tr><tr><td class="confluenceTd">9.1</td><td class="confluenceTd"><p>敏捷面板性能改进</p><p>从审核日志中排除事件,减少审核日志中的内容</p><p>用JFlight Recorde诊断和排除Jira故障</p><p>优化问题导航器中查询的结果</p><p>提供应用程序监控</p><p>Jira启动时改进了索引管理,启动速度会快</p></td></tr><tr><td class="confluenceTd">9.0</td><td class="confluenceTd"><p>活动选项卡改进(数据中心)</p><p>安全措施的过度活动限制(数据中心)</p><p>API端点的安全修复</p><p>优化bord功能,获得更好的性能</p><p>问题状态菜单改进(工作流动作按钮进行异常加载,减少一次性加载压力 )</p><p>提供<span class="inline-highlight">Flight Recorder</span> 功用,排除Jira故障</p><p>内置automation插件</p></td></tr><tr><td colspan="1" class="confluenceTd">8.22</td><td colspan="1" class="confluenceTd"><p>Jira现在可以配置为OAuth 2.0提供程序</p><p>基本身份验证的登录性能改进</p><p>从数据管道中排除项目</p></td></tr><tr><td colspan="1" class="confluenceTd">8.21</td><td colspan="1" class="confluenceTd"><p>改进的小工具配置体验</p><p>项目选择器搜索改进</p></td></tr><tr><td colspan="1" class="confluenceTd">8.20</td><td colspan="1" class="confluenceTd"><p>集成plan插件,全面支持路线图</p><p>电子邮件通知增加信息访问的高安全性</p></td></tr><tr><td colspan="1" class="confluenceTd">8.19</td><td colspan="1" class="confluenceTd"><span class="conf-macro output-inline">查看数据管道功能,了解数据api的调用</span></td></tr><tr><td colspan="1" class="confluenceTd">8.18</td><td colspan="1" class="confluenceTd"><p>导出和导入问题历史记录</p></td></tr><tr><td colspan="1" class="confluenceTd">8.17</td><td colspan="1" class="confluenceTd"><p>UI的体验升级,包括工作流动作及备注的展示</p><p>自定义字段现在包含在数据管道导出中(数据中心)</p><p>加强Jira安全</p><p>支持高版本的数据库</p></td></tr></tbody></table></div>
</div>
<div style="padding: 10px 0;">
<a href="https://confluence.hktx.cn/pages/viewpage.action?pageId=174817501">View Online</a>
·
<a href="https://confluence.hktx.cn/pages/diffpagesbyversion.action?pageId=174817501&revisedVersion=4&originalVersion=3">View Changes Online</a>
</div>
</div>
红旗公
2023-09-17T09:17:26Z