Blue Light
Space shortcuts
Child pages
  • JIRA Filter
Skip to end of metadata
Go to start of metadata

J

 

  • Arranging issue in the JIRA dasboard by Names

  • status = Open AND assignee in (daniel) ORDER BY updated DESC, assignee ASC ok

  • project="foo" and "Date Created" >= "2013/06/01" and "DateCreated" <="2013/06/30"

  • duedate = empty order by created, priority asc ok

  • created >= 2015-08-01 AND created <= 2015-08-31 ok

  • resolved >= 2015-08-01 AND resolved <= 2015-08-31 ok

  • project = "Future School - 2622776, 2622596 Jerry" AND created >= 2006-04-01 AND created <= 2007-03-31 ORDER BY key ASC

p.pname, DATEDIFF(now(), ji.created) from project p, jiraissue ji where p.id = ji.project and ji.issuenum = 1 and DATEDIFF(now(), ji.created) <= 365 order by p.id (did not work)

 

spcial character:

https://confluence.atlassian.com/conf56/confluence-user-s-guide/creating-content/using-the-editor/using-symbols-emoticons-and-special-characters

 

 

created >= 2015-12-01 AND created <= 2015-12-31 ORDER BY key ASC, created ASC

 

  • No labels