All notes
Jira

JQL

Find all open tasks and subtasks under some epic:


// https://community.atlassian.com/t5/JIRA-questions/Filter-by-epic/qaq-p/295309
project = MyProj AND issuetype in (standardIssueTypes(), subTaskIssueTypes()) AND status = Open AND "epic link" = MyProj-11001 ORDER BY priority

#---------- Find all issues resolved by me
# https://stackoverflow.com/questions/7239532/jira-resolved-by-me-query
status was "Resolved" by currentUser()
status changed to resolved by currentUser()  ORDER BY resolutiondate DESC

Text Formatting Notation Help

jira.atlassian.com.



#---------- Heading:
h1. Biggest heading
h2. Bigger heading
h6. Smallest heading

#---------- Effects:
*strong*
_emphasis_
??citation??
-deleted-
+inserted+
^superscript^
~subscript~
{{monospaced}}
bq. Some block quoted text. It makes an entire paragraph into a block quotation.
{quote}
    here is quotable
 content to be quoted
{quote}
{color:red}
    look ma, red text!
{color}

#---------- Text Breaks
(empty line)  Produces a new paragraph
\\  Creates a line break. Not often needed, most of the time the wiki renderer will guess new lines for you appropriately.
----  Creates a horizontal ruler.
--- Produces — symbol.
--  Produces – symbol.

#---------- Links
[#anchor]
[^attachment.ext]
[http://jira.atlassian.com]
[Atlassian|http://atlassian.com]
[mailto:[email protected]]
[file:///c:/temp/foo.txt]
[file:///z:/file/on/network/share.txt]
{anchor:anchorname}
[~username]

#---------- Lists
* some
* bullet
** indented
** bullets
* points
- Squared
- bullet
- types
# a
# numbered
# list
# a
# numbered
#* with
#* nested
#* bullet
# list

#---------- Images
!http://www.host.com/image.gif!
!attached-image.gif!
!image.jpg|thumbnail!
!image.gif|align=right, vspace=4!

FAQ

How to reference a Jira issue in comment

community.atlassian.com.

Alexey Zimarev Aug 22, 2016
Just writing the issue code is enough, JIRA recognizes it and makes a link of it. It will not create a full pledged issue link though.

Installation

license

Description=JIRA: Commercial,
CreationDate=你的安装日期,格式(yyyy-mm-dd),
jira.LicenseEdition=ENTERPRISE,
Evaluation=false,
jira.LicenseTypeName=COMMERCIAL,
jira.active=true,
licenseVersion=2,
MaintenanceExpiryDate=你想设置的失效日期如:2099-12-31,
Organisation=joiandjoin,
SEN=你申请到的SEN注意没有前缀LID,
ServerID=你申请到的ServerID,
jira.NumberOfUsers=-1,
LicenseID=LID你申请到的SEN,注意LID前缀不要丢掉,
LicenseExpiryDate=你想设置的失效日期如:2099-12-31,
PurchaseDate=你的安装日期,格式(yyyy-mm-dd)

本次安装授权码实例为:

Description=JIRA: Commercial,
CreationDate=2015-07-18,
jira.LicenseEdition=ENTERPRISE,
Evaluation=false,
jira.LicenseTypeName=COMMERCIAL,
jira.active=true,
licenseVersion=2,
MaintenanceExpiryDate=2099-12-31,
Organisation=wcf,
SEN=SEN-L6135732,
ServerID=BURP-KDXS-KH23-Q89S,
jira.NumberOfUsers=-1,
LicenseID=AAABLw0ODAoPeNptkEFvgkAQhe/7KzbppT2sAdSKJJvUwiZFESho00MvWzrqNrCYZaH13xddE9vGw
ySTvJnvzbybnGs8b0tsu9gaeSPHG0+xH6ywY9ljFEBTKLHXopZ0HmYzfJuD6kDdvXmYdbxs+VFCv
oJTE3AN9LhIrAmxXfQpFB9EogDZAPsQJwyLVyxLszBnyK+l5oVmSy5K+sXlttjxegNy+yB2sIFBU
Vfo4kK1auEPcnXYQ8wroH6yXLLMD2eR0Xuo6MAslGb2BVRzhDiod5MaJJcFsO+9UIdfV7vEnqBEb
bkUjTG9+OMzyVjEbfUOKtmsmx5MiY1MMGFAH9dZShbBa04WT86QPLvTHOUspn2R6N4ejidDB50/6
MejMLimXD8tbVWfUQP/g/4B8lmTITAsAhRSxn8Xh8V2VIjH1ZWWfu7qlcruxQIUO9tCU2+brTXSK
Pf/e4ZW+p9RLw4=X02f7,
LicenseExpiryDate=2099-12-31,
PurchaseDate=2015-07-18

Install chinese package

CSDNBBS.

1. 起始很简单,看看其他语言包在哪里就可以了,明显不是/WEB-INFO/lib目录下。
中文语言包拷贝到**/WEB-INFO/atlassian-bundled-plugins下面,就能在语言选项里看到中文了
2. 可以汉化的,破解以后也可以再汉化,破解以后打不开插件管理是应为破解不彻底,要把**/WEB-INFO/atlassian-bundled-plugins下面的atlassian-universal-plugin-manager-plugin-2.17.13.jar这个文件也替换成破解版本的。然后就可以打开插件管理了,通过插件管理上传汉化包,就汉化成功啦
3. wcf note: 通过addons上传语言包失败,说jar无法uninstall所以不能安装。最后我直接按照方法1搞定。

CSDNBBS.

1、如果使用mysql数据库,要把mysql的jdbc驱动jar包上传到jira安装目录下的lib目录里
2、破解jar包有两个,而不是一个,很多人都只上传了一个。一个是extra,一个是universal-plugin。
3、汉化包只有一个,STD-CN包有问题不能用

FAQ

[NoModule] There was an error getting a DBCP datasource

AtlassianJIRAKB. There are a number of different exceptions that cause the error. Take a look in the 'Caused by' section of the stack traces in the atlassian-jira.log.

Cause

When a database server reboots or a network failure has occurred, all connections in the database connection pool are broken, and JIRA would normally need restarting to recreate those connections.

Solution

So you have to write a crontab to monitor the JIRA port, and restart it when the it shuts down. See crontab.note.