{"id":4419,"date":"2018-08-22T11:52:26","date_gmt":"2018-08-22T17:52:26","guid":{"rendered":"http:\/\/www.designandexecute.com\/designs\/?p=4419"},"modified":"2020-12-18T16:06:23","modified_gmt":"2020-12-18T22:06:23","slug":"10-questions-every-project-should-answer-using-jira-query-language","status":"publish","type":"post","link":"https:\/\/www.designandexecute.com\/designs\/10-questions-every-project-should-answer-using-jira-query-language\/","title":{"rendered":"10 Questions Every Project Should Answer Using Jira Query Language"},"content":{"rendered":"<p><span data-preserver-spaces=\"true\">After 25 years of building software and leading project teams, I have seen only one consistent software industry trend. Everyone who decided to lead a team will be faced with the same set of questions if they will be successful at delivering. All successful projects are similar in the same way, and all failed projects are unique in their way.<\/span><\/p>\n<p><span data-preserver-spaces=\"true\">The Scrum Agile Framework was born out of a common denominator of best practices that have worked. Scrum can be practiced in any format. E.g., contrast using sticky paper on walls or using the software in a purely digital form. One of the most popular agile software is Jira, developed by\u00a0<\/span><a class=\"editor-rtfLink\" href=\"https:\/\/www.atlassian.com\/software\/jira\" target=\"_blank\" rel=\"noopener noreferrer\"><span data-preserver-spaces=\"true\">Atlassian.com.\u00a0\u00a0<\/span><\/a><span data-preserver-spaces=\"true\">which is especially helpful when managing distributed teams that require enterprise reporting and transparency to upper management.<\/span><\/p>\n<p><span data-preserver-spaces=\"true\">It does not matter if you use the Capability Maturity Model (CMM), Lean, Six Sigma, Agile, Theory of Constraints, or another management methodology from PMI. Any successful Project Manager or Lead must answer some fundamental questions. These are a few that come to mind.<\/span><\/p>\n<ol>\n<li>How Many Stories\/Tasks were <strong>closed<\/strong> today\/this week\/month\/year (achieved)\n<pre class=\" language-none\"><code class=\" language-none\">project = \"TEST\" AND status = closed<\/code><\/pre>\n<\/li>\n<li>How Many Stories\/Tasks were <strong>opened<\/strong> today\/this week? (increasing product back log or PBI is a sign of usage and value)\n<pre class=\" language-none\"><code class=\" language-none\">project = \"TEST\" AND status != closed<\/code><\/pre>\n<\/li>\n<li>What is the baseline <strong>velocity<\/strong> of the team to complete stories\/tasks decomposed to the <strong>same complexity<\/strong> by day\/week\/month?\n<pre class=\" language-none\"><code class=\" language-none\">project = \"TEST\" AND Sprint = \"YourPreviousSprint\"<\/code><\/pre>\n<\/li>\n<li>What is the <strong>ratio<\/strong> of burn down task to the burn up task? (close to open ratio)\n<pre class=\" language-none\"><code class=\" language-none\">Results of question1 \/ Results of question2<\/code><\/pre>\n<\/li>\n<li>How many Stories\/Tasks\/ Story Points are we <strong>currently working on?<\/strong> (in scrum language: the active sprint)\n<pre class=\" language-none\"><code class=\" language-none\">project = \"TEST\" AND Sprint = \"YourActiveSprint\"<\/code><\/pre>\n<\/li>\n<li>What is the <strong>persons allocation<\/strong> to the active work? (budget), is the load balanced?\n<pre class=\" language-none\"><code class=\" language-none\">project = \"TEST\" AND assignee = currentuser()<\/code><\/pre>\n<\/li>\n<li>Do we have any <strong>slack capacity<\/strong> in the team? (ability to manage change and variance)\n<pre class=\" language-none\"><code class=\" language-none\">project = \"TEST\" AND assignee in(member1, member2, member3)<\/code><\/pre>\n<\/li>\n<li>What are the <strong>current risks<\/strong> that can impact the <strong>timeline\/scope<\/strong> of the deliverable?\n<pre class=\" language-none\"><code class=\" language-none\">project = \"TEST\" AND <code>priority in (Blocker, Critical)<\/code><\/code><\/pre>\n<\/li>\n<li>Did we get any daily\/weekly feedback?\n<pre class=\" language-none\"><code class=\" language-none\">project = \"TEST\" AND <code>assignee is EMPTY and updatedDate &lt; -1d<\/code><\/code><\/pre>\n<\/li>\n<li>How much inter group dependencies and coordination are involved (meetings with different teams)?\n<pre class=\" language-none\"><code class=\" language-none\">OK Jira cannot answer this one. Lol<code><\/code><\/code><\/pre>\n<\/li>\n<\/ol>\n<h3>To get the command line for the Jira Query Language (JQL) do the following:<\/h3>\n<ul>\n<li>Click <strong>Issues<em> &gt; Search for issue<\/em><\/strong><\/li>\n<li>Click\u00a0<strong>Edit\u00a0<\/strong>(If you have a search in progress)<\/li>\n<li>Click\u00a0<strong>Advanced Searching<\/strong><\/li>\n<\/ul>\n<p>Advance Design Tip: you can stack filters for high impact with little changes on all dashboards that use the filter. eg<\/p>\n<pre class=\" language-none\"><code class=\" language-none\">filter= \"MY FILTER\" AND <code>assignee is EMPTY and updatedDate &lt; -1d<\/code><\/code><\/pre>\n<pre>for more <a href=\"https:\/\/confluence.atlassian.com\/jiracoreserver073\/advanced-searching-functions-reference-861257222.html#AdvancedSearchingFunctions-openSprints()\" target=\"_blank\" rel=\"noopener noreferrer\">great functions check out this site<\/a><\/pre>\n<h2><span data-preserver-spaces=\"true\">It is important to note that these questions are crystallized in the crucible of critical first principles:<\/span><\/h2>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li><strong><span data-preserver-spaces=\"true\">Trust takes time to build\u00a0<\/span><\/strong><span data-preserver-spaces=\"true\">and is easily lost. We can have a fixed timeline or a fixed scope, but we cannot remain fixed on both and still maintain trust. Sometimes we get what we need but not what we want.<\/span><\/li>\n<li><strong><span data-preserver-spaces=\"true\">Metric Questions above are NOT meant to weaponize<\/span><\/strong><span data-preserver-spaces=\"true\">\u00a0management but serve as a north star about how a team works and its capability to deliver. Management must trust the team to do its job.<\/span><\/li>\n<li><strong><span data-preserver-spaces=\"true\">From the Outside In.\u00a0<\/span><\/strong><span data-preserver-spaces=\"true\">\u00a0The ability to estimate and deliver value is still driven from the outside,\u00a0<\/span><strong><span data-preserver-spaces=\"true\">where the customer defines value.\u00a0<\/span><\/strong><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<h2><span data-preserver-spaces=\"true\">Stephen Choo Quan<\/span><\/h2>\n<p><strong>Sharing is Caring. Thanks for reading and Sharing \u2764<\/strong><\/p>\n<p><strong>Follow me\u00a0On:\u00a0<a href=\"https:\/\/www.instagram.com\/taylorchooquan\/\" target=\"_blank\" rel=\"noreferrer noopener\">Instagram<\/a>\u00a0|\u00a0<a href=\"https:\/\/www.facebook.com\/stephen.chooquan\" target=\"_blank\" rel=\"noreferrer noopener\">Facebook<\/a>\u00a0|\u00a0<a href=\"https:\/\/www.linkedin.com\/in\/stephenchooquan\/\">Linked in<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>After 25 years of building software and leading project teams, I have seen only one consistent software industry trend. Everyone who decided to lead a team will be faced with the same set of questions if they will be successful at delivering. All successful projects are similar in the same way, and all failed projects [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":4420,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,7],"tags":[44],"class_list":["post-4419","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-leadership-innovation","category-faq","tag-jira-scrum-agile"],"jetpack_featured_media_url":"https:\/\/www.designandexecute.com\/designs\/wp-content\/uploads\/2018\/08\/jira-scrum-agile-query-language.png","_links":{"self":[{"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/posts\/4419","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/comments?post=4419"}],"version-history":[{"count":6,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/posts\/4419\/revisions"}],"predecessor-version":[{"id":10441,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/posts\/4419\/revisions\/10441"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/media\/4420"}],"wp:attachment":[{"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/media?parent=4419"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/categories?post=4419"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/tags?post=4419"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}