m0_51100426的博客

-- 查询网签备案所有未关闭发布单(ID,编号，概述，状态，经办人，发布日期)SELECT a.ID,CONCAT(b.pkey,'-',a.issuenum), a.SUMMARY,c.pname,d.first_name,DATE_FORMAT(e.DATEVALUE, '%Y-%m-%d')FROM jiraissue aLEFT join project b on a.PROJECT=b.IDLEFT join issuestatus c on a.issuestatus=c.IDLEFT

-- 已知自定义字段的ID和issue的ID，获取issue的自定义字段的值-- 状态为“测试经理审核”（获取issue的ID）select c.ID, c.SUMMARY,c.issuetypefrom changeitem a LEFT JOIN changegroup b on a.groupid=b.idLEFT JOIN jiraissue c ON b.issueid=c.IDwhere a.NEWVALUE in ('10112') and b.CREATED>DATE_S

jira数据库中表的概述app_useraudit_changed_valuechangegroupchangeitemcustomfieldcustomfieldoptioncustomfieldvaluecwd_userissuelinkissuelinktypeissuestatusissuetypejiraactionjiraissuelabelprojectresolutionapp_user系统用户表字段名注释有关联ID用户IDapp_useruser_ke