我在JIRA中评论的问题 [英] Issues commented by me in JIRA

问题描述

根据JIRA文档 http://www.atlassian.com/software/jira/docs/latest

以下过滤器将显示我(当前用户)选择的问题.

The following filter will show the issues opned by me (Current User).

reporter = currentUser()

是否有文件管理器显示我所评论的问题?像下面这样的东西不起作用...

Is there a filer that will show issues commented by me? something like the following does not work...

comment by = currentUser()

推荐答案

这是了解我所涉及的问题的查询:

This is the query to know the issues I am involved in:

SELECT a.pkey, a.summary FROM jiraissue AS a left join jiraaction AS b on a.id = b.issueid 
where b.author = 'jira_username' OR a.REPORTER = 'jira_username' OR a.ASSIGNEE = 'jira_username' 
group by a.pkey order by a.CREATED

此查询可了解过去24小时内提出的所有问题.

This is the query to know all issues raised in the last 24 hours.

select REPORTER, SUMMARY from jiraissue 
WHERE CREATED > DATE_SUB(CURDATE(), INTERVAL 1 DAY)  order by CREATED DESC; 

这篇关于我在JIRA中评论的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！