Confluence tricks EazyBI Ethereum Dev JIRA Plugins / Add-on JIRA tricks JOBS JQL News Performance Tricks Services

IT Services, JIRA Plugins & Trainings @Barcelona(Spain) @Bologna(Italy)

We provide solutions and integrations for your business needs. We provide BPO Services. We share our know-how in Agile Software developments (Scrum & Kanban) providing consulting services with the best professional tools We are experts in all Atlassian products ( JIRA, Confluence, Bitbucket, Hip Chat) and of some of the best plugins (Tempo, EazyBI, JExcel,…

Read More
JQL Uncategorized

JIRA JQL trick: Filter issues based on transition state execution date in JIRA

Very easy, see the JQL example: Project = “JIRA” AND Status CHANGED TO “In Progress” DURING (“2015/08/01″,”2015/10/05”) Other Syntax: This JQL shows all issues which have been in “Status A” for more than 14 days project=XXX and status changed to “Status A” before startofday(-14) and status = “Status A” This JQL shows all issues which…

Read More
JQL

Script JQL Functions: Included Functions in Groovy ScriptRunner

JQL functions: hasComments commented lastComment lastUpdated hasAttachments fileAttached workLogged dateCompare hasSubtasks subtasksOf parentsOf hasLinks hasLinkType linkedIssuesOf linkedIssuesOfRecursive linkedIssuesOfRecursiveLimited expression aggregateExpression issueFieldMatch issueFieldExactMatch myProjects recentProjects projectMatch / componentMatch / ver earliestUnreleasedVersionByRelease addedAfterSprintStart removedAfterSprintStart incompleteInSprint completeInSprint nextSprint previousSprint inSprint(board name, sprint name) See more in Adaptavist ScriptRunner

Read More
JQL Other Performance Tricks

One simple way to obtain time measures of JIRA from terminal

The best way is using CURL from command line time curl -D- -u raul.pelaez:*** -X GET -H “Content-Type: application/json” http://127.0.0.1:8080/rest/api/2/search?jql=assignee=raul.pelaez real 0m7.098s user 0m0.004s sys 0m0.012s time curl -D- -u raul.pelaez:*** -X GET -H “Content-Type: application/json” http://10.2.29.224:8080/rest/api/2/search?jql=assignee=raul.pelaez real 0m7.562s user 0m0.008s sys 0m0.008s time curl -D- -u raul.pelaez:*** -X GET -H “Content-Type: application/json” https://jira.domain.com/rest/api/2/search?jql=assignee=raul.pelaez real…

Read More
JQL

JQL Reference manual (How to Perform an Advanced Search)

JQL Manual: https://confluence.excentia.es/pages/viewpage.action?pageId=27329688 JQL Atlassian Manual: https://confluence.atlassian.com/display/JIRA/Advanced+Searching How to Perform an Advanced Search Choose Issues > Search for Issues. The issue navigator will be displayed. If there are existing search criteria, click the New filter button to reset the search criteria. If the Advanced link is showing, click it to switch to advanced searching. Type your query…

Read More