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