{"id":117,"date":"2019-12-03T14:17:41","date_gmt":"2019-12-03T13:17:41","guid":{"rendered":"https:\/\/www.actonic.de\/?page_id=117"},"modified":"2021-02-17T13:57:53","modified_gmt":"2021-02-17T12:57:53","slug":"power-jql","status":"publish","type":"page","link":"https:\/\/actonic.de\/en\/products\/power-jql\/","title":{"rendered":"Power JQL: Extended Search Functions"},"content":{"rendered":"<div class=\"wpb-content-wrapper\"><p>[vc_row css=&#8221;.vc_custom_1575556115252{margin-top: 50px !important;}&#8221;][vc_column width=&#8221;1\/2&#8243;][vc_single_image image=&#8221;244&#8243; img_size=&#8221;full&#8221;][\/vc_column][vc_column width=&#8221;1\/2&#8243; css=&#8221;.vc_custom_1575558783543{margin-top: 20px !important;margin-left: -160px !important;}&#8221;][vc_column_text css=&#8221;.vc_custom_1605685570091{margin-top: 50px !important;}&#8221;]<strong>Additional useful JQL functions to search for issues across Jira using the power of regular expressions (Regex).<\/strong><\/p>\n<p>Available for Jira Server and Jira Service Management.[\/vc_column_text][button title=&#8221;Free trial&#8221; link=&#8221;https:\/\/marketplace.atlassian.com\/1216891&#8243; button_align=&#8221;center&#8221; button_size=&#8221;btn-lg&#8221; el_id=&#8221;1575556050809-5265cfb0-84b5&#8243; css=&#8221;.vc_custom_1592813274697{background-color: #f7a600 !important;}&#8221;][vc_empty_space][button title=&#8221;Have a look at our documentation&#8221; link=&#8221;https:\/\/actonic.atlassian.net\/wiki\/spaces\/PROD\/pages\/14942237\/Power%20JQL&#8221; button_align=&#8221;center&#8221; button_size=&#8221;btn-lg&#8221; el_id=&#8221;1592813195864-b7c06125-82b3&#8243; css=&#8221;.vc_custom_1592813223877{background-color: #f7a600 !important;}&#8221;][\/vc_column][\/vc_row][vc_row][vc_column][heading title=&#8221;Screenshots&#8221; heading=&#8221;h2&#8243; font_weight=&#8221;&#8221; el_id=&#8221;1575556436712-70ca7a07-22af&#8221; css=&#8221;.vc_custom_1575557930166{margin-top: 50px !important;margin-bottom: 30px !important;}&#8221;][\/vc_column][\/vc_row][vc_row][vc_column width=&#8221;1\/3&#8243;][vc_row_inner][vc_column_inner][vc_single_image image=&#8221;310&#8243; img_size=&#8221;500&#215;500&#8243; style=&#8221;vc_box_shadow&#8221; onclick=&#8221;link_image&#8221; css=&#8221;.vc_custom_1575566157221{margin-top: 0px !important;margin-right: 0px !important;margin-bottom: 20px !important;margin-left: 0px !important;}&#8221;][heading title=&#8221;powerIssue in action&#8221; heading=&#8221;h6&#8243; font_weight=&#8221;&#8221; el_id=&#8221;1575556928401-85791452-97b3&#8243;][vc_column_text]<strong>Task:<\/strong> Find issues whose summary or description contain any of the listed words in a particular project.<\/p>\n<p><strong>Solution:<\/strong> Issue in powerIssue(&#8220;project=POWERJQL&#8221;, &#8220;summary, description&#8221;, &#8220;(?i).*(text1|text2).*&#8221;)[\/vc_column_text][\/vc_column_inner][\/vc_row_inner][\/vc_column][vc_column width=&#8221;1\/3&#8243;][vc_single_image image=&#8221;312&#8243; img_size=&#8221;500&#215;500&#8243; style=&#8221;vc_box_shadow&#8221; onclick=&#8221;link_image&#8221; css=&#8221;.vc_custom_1575566207824{margin-top: 0px !important;margin-right: 0px !important;margin-bottom: 20px !important;margin-left: 0px !important;}&#8221;][heading title=&#8221;powerComponent in action&#8221; heading=&#8221;h6&#8243; font_weight=&#8221;&#8221; el_id=&#8221;1575557040048-53975851-9658&#8243;][vc_column_text]<strong>Task:<\/strong> find all unresolved issues where any component contains words &#8220;mobile&#8221; or &#8220;dev&#8221;.<\/p>\n<p><strong>Solution:<\/strong> component in powerComponent(&#8220;resolution = EMPTY&#8221;, &#8220;(?i).*(mobile|dev).*&#8221;)[\/vc_column_text][\/vc_column][vc_column width=&#8221;1\/3&#8243;][vc_single_image image=&#8221;314&#8243; img_size=&#8221;500&#215;500&#8243; style=&#8221;vc_box_shadow&#8221; onclick=&#8221;link_image&#8221; css=&#8221;.vc_custom_1575566241314{margin-top: 0px !important;margin-right: 0px !important;margin-bottom: 20px !important;margin-left: 0px !important;}&#8221;][heading title=&#8221;powerAttachment in action&#8221; heading=&#8221;h6&#8243; font_weight=&#8221;&#8221; el_id=&#8221;1575557161593-a3e506cf-c4c3&#8243;][vc_column_text]<strong>Task:<\/strong> Find all issues with the attachments in pdf format containing the word &#8220;android&#8221; in the title.<\/p>\n<p><strong>Solution:<\/strong> Issue in powerAttachment(&#8220;.*(?=android).*(?=pdf).*&#8221;)[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column width=&#8221;1\/3&#8243;][vc_row_inner][vc_column_inner][vc_single_image image=&#8221;316&#8243; img_size=&#8221;500&#215;500&#8243; style=&#8221;vc_box_shadow&#8221; onclick=&#8221;link_image&#8221; css=&#8221;.vc_custom_1575566281571{margin-top: 0px !important;margin-right: 0px !important;margin-bottom: 20px !important;margin-left: 0px !important;}&#8221;][heading title=&#8221;powerProject in action&#8221; heading=&#8221;h6&#8243; font_weight=&#8221;&#8221; el_id=&#8221;1575557249407-8c4131f5-7a17&#8243;][vc_column_text]<strong>Task:<\/strong> find all issues with the particular text in the title.<\/p>\n<p><strong>Solution:<\/strong> project in powerProject(&#8220;.*(Customer).*&#8221;)[\/vc_column_text][\/vc_column_inner][\/vc_row_inner][\/vc_column][\/vc_row][vc_row][vc_column][button title=&#8221;Free trial&#8221; link=&#8221;https:\/\/marketplace.atlassian.com\/1216891&#8243; button_align=&#8221;center&#8221; button_size=&#8221;btn-lg&#8221; el_id=&#8221;1589973445632-b0bd233e-9fac&#8221; css=&#8221;.vc_custom_1589973460666{background-color: #f7a600 !important;}&#8221;][heading title=&#8221;More Details&#8221; heading=&#8221;h2&#8243; font_weight=&#8221;&#8221; el_id=&#8221;1575557752653-21c83d98-a228&#8243; css=&#8221;.vc_custom_1581434077052{margin-top: 50px !important;}&#8221;][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]<strong>JQL functions:<\/strong><\/p>\n<ul>\n<li>powerIssue([JQL subQuery, optional], field names, regex expression)<\/li>\n<li>powerComponent([JQL subQuery, optional], regex expression)<\/li>\n<li>powerAttachment([JQL subQuery, optional], regex expression)<\/li>\n<li>powerProject(regex expression)<\/li>\n<\/ul>\n<p><strong>Examples:<\/strong><\/p>\n<ul>\n<li>issue in powerIssue(&#8220;project=POWERJQL&#8221;, &#8220;summary, description&#8221;, &#8220;(?i).*(text1|text2).*&#8221;)<\/li>\n<li>component in powerComponent(&#8220;resolution=EMPTY&#8221;, &#8220;.*(modile|dev).*&#8221;)<\/li>\n<li>project in powerProject(&#8220;.*(Customer).*&#8221;)<\/li>\n<li>issue in powerAttachment(&#8220;.*(?=android).*(?=pdf).*&#8221;)<\/li>\n<\/ul>\n<p>Leverage the power of pattern-based search across all Jira fields.[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][heading title=&#8221;Brands using this app&#8221; heading=&#8221;h1&#8243; text_align=&#8221;center&#8221; font_weight=&#8221;&#8221; el_id=&#8221;1593077664062-4577ede1-a011&#8243; css=&#8221;.vc_custom_1593078348955{margin-top: 50px !important;}&#8221;][vc_column_text css=&#8221;.vc_custom_1593084421943{margin-top: -15px !important;}&#8221;]<\/p>\n<p style=\"text-align: center;\">These companies are already using Power JQL successfully:<\/p>\n<p>[\/vc_column_text][vc_row_inner content_placement=&#8221;middle&#8221; css=&#8221;.vc_custom_1593084433742{margin-top: 75px !important;margin-bottom: 50px !important;}&#8221;][vc_column_inner][vc_single_image image=&#8221;1274&#8243; img_size=&#8221;full&#8221; alignment=&#8221;center&#8221;][\/vc_column_inner][\/vc_row_inner][\/vc_column][\/vc_row][vc_row][vc_column][button title=&#8221;Free trial&#8221; link=&#8221;https:\/\/marketplace.atlassian.com\/1216891&#8243; button_align=&#8221;center&#8221; button_size=&#8221;btn-lg&#8221; el_id=&#8221;1589973462733-a1e0c159-54d8&#8243; css=&#8221;.vc_custom_1589973460666{background-color: #f7a600 !important;}&#8221;][vc_empty_space][button title=&#8221;Read our documentation&#8221; link=&#8221;https:\/\/actonic.atlassian.net\/wiki\/spaces\/PROD\/pages\/14942237\/Power%20JQL&#8221; button_align=&#8221;center&#8221; button_size=&#8221;btn-lg&#8221; el_id=&#8221;1592813227809-f2ae8a51-808e&#8221; css=&#8221;.vc_custom_1592813243245{background-color: #f7a600 !important;}&#8221;][\/vc_column][\/vc_row][vc_row][vc_column css=&#8221;.vc_custom_1575559142343{margin-top: 100px !important;}&#8221;][vc_column_text]<\/p>\n<p style=\"text-align: center;\">Find all of our apps<br \/>\non the Atlassian Marketplace:<\/p>\n<p>[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][vc_single_image image=&#8221;268&#8243; img_size=&#8221;full&#8221; alignment=&#8221;center&#8221; onclick=&#8221;custom_link&#8221; img_link_target=&#8221;_blank&#8221; link=&#8221;https:\/\/marketplace.atlassian.com\/vendors\/1214306\/actonic-gmbh&#8221;][\/vc_column][\/vc_row][vc_row][vc_column][vc_raw_js]JTNDc2NyaXB0JTIwdHlwZSUzRCUyMmFwcGxpY2F0aW9uJTJGbGQlMkJqc29uJTIyJTNFJTBBJTdCJTBBJTIwJTIwJTIyJTQwY29udGV4dCUyMiUzQSUyMCUyMmh0dHBzJTNBJTJGJTJGc2NoZW1hLm9yZyUyRiUyMiUyQyUyMCUwQSUyMCUyMCUyMiU0MHR5cGUlMjIlM0ElMjAlMjJTb2Z0d2FyZUFwcGxpY2F0aW9uJTIyJTJDJTBBJTIyYXBwbGljYXRpb25DYXRlZ29yeSUyMiUyMCUzQSUyMCUyMkFkZC1vbnMlMjIlMkMlMjAlMEElMjJhcHBsaWNhdGlvblN1aXRlJTIyJTIwJTNBJTIwJTIySmlyYSUyMiUyQyUwQSUyMCUyMCUyMm5hbWUlMjIlM0ElMjAlMjJQb3dlciUyMEpRTCUzQSUyMEV4dGVuZGVkJTIwU2VhcmNoJTIwRnVuY3Rpb25zJTIyJTJDJTBBJTIwJTIwJTIyaW1hZ2UlMjIlM0ElMjAlMjJodHRwcyUzQSUyRiUyRnd3dy5hY3RvbmljLmRlJTJGd3AtY29udGVudCUyRnVwbG9hZHMlMkYyMDE5JTJGMTIlMkZwYWNrc2hvdF9wb3dlcmpxbC5wbmclMjIlMkMlMEElMjAlMjAlMjJkZXNjcmlwdGlvbiUyMiUzQSUyMCUyMkFkZGl0aW9uYWwlMjB1c2VmdWwlMjBKUUwlMjBmdW5jdGlvbnMlMjB0byUyMHNlYXJjaCUyMGZvciUyMGlzc3VlcyUyMGFjcm9zcyUyMEppcmElMjB1c2luZyUyMHRoZSUyMHBvd2VyJTIwb2YlMjByZWd1bGFyJTIwZXhwcmVzc2lvbnMlMjAlMjhSZWdleCUyOS4lMjIlMkMlMEElMjAlMjAlMjJhZ2dyZWdhdGVSYXRpbmclMjIlM0ElMjAlN0IlMEElMjAlMjAlMjAlMjAlMjIlNDB0eXBlJTIyJTNBJTIwJTIyQWdncmVnYXRlUmF0aW5nJTIyJTJDJTBBJTIwJTIwJTIwJTIwJTIycmF0aW5nVmFsdWUlMjIlM0ElMjAlMjI0JTIyJTJDJTBBJTIwJTIwJTIwJTIwJTIyYmVzdFJhdGluZyUyMiUzQSUyMCUyMjQlMjIlMkMlMEElMjAlMjAlMjAlMjAlMjJ3b3JzdFJhdGluZyUyMiUzQSUyMCUyMjElMjIlMkMlMEElMjAlMjAlMjAlMjAlMjJyYXRpbmdDb3VudCUyMiUzQSUyMCUyMjEwJTIyJTBBJTIwJTIwJTdEJTBBJTdEJTBBJTNDJTJGc2NyaXB0JTNF[\/vc_raw_js][\/vc_column][\/vc_row]<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>[vc_row css=&#8221;.vc_custom_1575556115252{margin-top: 50px !important;}&#8221;][vc_column width=&#8221;1\/2&#8243;][vc_single_image image=&#8221;244&#8243; img_size=&#8221;full&#8221;][\/vc_column][vc_column width=&#8221;1\/2&#8243; css=&#8221;.vc_custom_1575558783543{margin-top: 20px !important;margin-left: -160px !important;}&#8221;][vc_column_text css=&#8221;.vc_custom_1605685570091{margin-top: 50px !important;}&#8221;]Additional useful JQL functions to search for issues across Jira using the power of regular expressions (Regex). Available for Jira Server and Jira Service Management.[\/vc_column_text][button title=&#8221;Free trial&#8221; link=&#8221;https:\/\/marketplace.atlassian.com\/1216891&#8243; button_align=&#8221;center&#8221; button_size=&#8221;btn-lg&#8221; el_id=&#8221;1575556050809-5265cfb0-84b5&#8243; css=&#8221;.vc_custom_1592813274697{background-color: #f7a600 !important;}&#8221;][vc_empty_space][button title=&#8221;Have a look at our documentation&#8221;\u2026<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":507,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"product-page-temp.php","meta":{"_acf_changed":false,"footnotes":""},"class_list":["post-117","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.5 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>JQL functions f\u00fcr advanced search in Jira - Actonic \u2013 Unfolding your potential<\/title>\n<meta name=\"description\" content=\"Useful JQL-functions for ticket-search in Jira using the power of regular expressions (Regex).\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/actonic.de\/en\/products\/power-jql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power JQL: Extended Search Functions\" \/>\n<meta property=\"og:description\" content=\"Useful JQL-functions for ticket-search in Jira using the power of regular expressions (Regex).\" \/>\n<meta property=\"og:url\" content=\"https:\/\/actonic.de\/en\/products\/power-jql\/\" \/>\n<meta property=\"og:site_name\" content=\"Actonic \u2013 Unfolding your potential\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-17T12:57:53+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/products\\\/power-jql\\\/\",\"url\":\"https:\\\/\\\/actonic.de\\\/en\\\/products\\\/power-jql\\\/\",\"name\":\"JQL functions f\u00fcr advanced search in Jira - Actonic \u2013 Unfolding your potential\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/#website\"},\"datePublished\":\"2019-12-03T13:17:41+00:00\",\"dateModified\":\"2021-02-17T12:57:53+00:00\",\"description\":\"Useful JQL-functions for ticket-search in Jira using the power of regular expressions (Regex).\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/products\\\/power-jql\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/actonic.de\\\/en\\\/products\\\/power-jql\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/products\\\/power-jql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/actonic.de\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Actonic Apps for Jira and Confluence\",\"item\":\"https:\\\/\\\/actonic.de\\\/en\\\/products\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Power JQL: Extended Search Functions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/actonic.de\\\/en\\\/\",\"name\":\"Actonic \u2013 Unfolding your potential\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/actonic.de\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"JQL functions f\u00fcr advanced search in Jira - Actonic \u2013 Unfolding your potential","description":"Useful JQL-functions for ticket-search in Jira using the power of regular expressions (Regex).","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/actonic.de\/en\/products\/power-jql\/","og_locale":"en_US","og_type":"article","og_title":"Power JQL: Extended Search Functions","og_description":"Useful JQL-functions for ticket-search in Jira using the power of regular expressions (Regex).","og_url":"https:\/\/actonic.de\/en\/products\/power-jql\/","og_site_name":"Actonic \u2013 Unfolding your potential","article_modified_time":"2021-02-17T12:57:53+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/actonic.de\/en\/products\/power-jql\/","url":"https:\/\/actonic.de\/en\/products\/power-jql\/","name":"JQL functions f\u00fcr advanced search in Jira - Actonic \u2013 Unfolding your potential","isPartOf":{"@id":"https:\/\/actonic.de\/en\/#website"},"datePublished":"2019-12-03T13:17:41+00:00","dateModified":"2021-02-17T12:57:53+00:00","description":"Useful JQL-functions for ticket-search in Jira using the power of regular expressions (Regex).","breadcrumb":{"@id":"https:\/\/actonic.de\/en\/products\/power-jql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/actonic.de\/en\/products\/power-jql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/actonic.de\/en\/products\/power-jql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/actonic.de\/en\/"},{"@type":"ListItem","position":2,"name":"Actonic Apps for Jira and Confluence","item":"https:\/\/actonic.de\/en\/products\/"},{"@type":"ListItem","position":3,"name":"Power JQL: Extended Search Functions"}]},{"@type":"WebSite","@id":"https:\/\/actonic.de\/en\/#website","url":"https:\/\/actonic.de\/en\/","name":"Actonic \u2013 Unfolding your potential","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/actonic.de\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/pages\/117","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/comments?post=117"}],"version-history":[{"count":0,"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/pages\/117\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/pages\/507"}],"wp:attachment":[{"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/media?parent=117"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}