{"id":91180,"date":"2017-09-25T10:15:45","date_gmt":"2017-09-25T08:15:45","guid":{"rendered":"http:\/\/artigianodelsoftware.it\/blog\/?p=91180"},"modified":"2017-09-25T10:15:45","modified_gmt":"2017-09-25T08:15:45","slug":"diamo-una-marcia-in-piu-al-jql-test-addon","status":"publish","type":"post","link":"https:\/\/artigianodelsoftware.it\/blog\/2017\/09\/25\/diamo-una-marcia-in-piu-al-jql-test-addon\/","title":{"rendered":"Diamo una marcia in pi\u00f9 al JQL &#8211; Test Addon"},"content":{"rendered":"<div class=\"pdfprnt-buttons pdfprnt-buttons-post pdfprnt-top-right\"><a href=\"javascript: imageToPdf()\" class=\"pdfprnt-button pdfprnt-button-pdf\" target=\"_self\"><img src=\"https:\/\/artigianodelsoftware.it\/blog\/wp-content\/plugins\/pdf-print\/images\/pdf.png\" alt=\"image_pdf\" title=\"Visualizza PDF\" \/><\/a><a href=\"https:\/\/artigianodelsoftware.it\/blog\/wp-json\/wp\/v2\/posts\/91180?print=print\" class=\"pdfprnt-button pdfprnt-button-print\" target=\"_blank\"><\/a><\/div><blockquote>\n<h1>Diamo una marcia in pi\u00f9<\/h1>\n<\/blockquote>\n<p>In questo post diamo i risultati del test di questo addon, che ci permette di poter estendere le interrogazioni che il JQL standard mette a disposizione, e ci permette di avere delle interrogazioni avanzate.<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter\" src=\"https:\/\/marketplace-cdn.atlassian.com\/files\/images\/99e1ac32-4489-4178-ac32-213c285865b6.png\" width=\"84\" height=\"84\" \/><\/p>\n<blockquote>\n<h1>Installazione<\/h1>\n<\/blockquote>\n<p>Partiamo come sempre dalla installazione. Cerchiamo il nostro addon dalla lista degli addon disponibili<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-91242\" src=\"https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-01.png\" alt=\"\" width=\"1053\" height=\"179\" srcset=\"https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-01.png 1053w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-01-300x51.png 300w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-01-768x131.png 768w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-01-1024x174.png 1024w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-01-619x105.png 619w\" sizes=\"(max-width: 1053px) 100vw, 1053px\" \/><\/p>\n<p>Selezioniamo\u00a0<em><strong>Free trial<\/strong><\/em> per attivare la procedura di installazione &#8230;<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-91243\" src=\"https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-02.png\" alt=\"\" width=\"645\" height=\"321\" srcset=\"https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-02.png 645w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-02-300x149.png 300w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-02-619x308.png 619w\" sizes=\"(max-width: 645px) 100vw, 645px\" \/><\/p>\n<p>&#8230; lasciamo passare qualche minuto &#8230;<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-91244\" src=\"https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-03.png\" alt=\"\" width=\"644\" height=\"285\" srcset=\"https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-03.png 644w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-03-300x133.png 300w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-03-619x274.png 619w\" sizes=\"(max-width: 644px) 100vw, 644px\" \/><\/p>\n<p>&#8230; che si eseguino tutte le informazioni &#8230;.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-91245\" src=\"https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-04.png\" alt=\"\" width=\"1045\" height=\"437\" srcset=\"https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-04.png 1045w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-04-300x125.png 300w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-04-768x321.png 768w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-04-1024x428.png 1024w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-04-619x259.png 619w\" sizes=\"(max-width: 1045px) 100vw, 1045px\" \/><\/p>\n<p>&#8230; una volta completata l&#8217;installazione, attendiamo che si attivi la procedura di generazione della licenza &#8230;<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-91246\" src=\"https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-05.png\" alt=\"\" width=\"439\" height=\"234\" srcset=\"https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-05.png 439w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-05-300x160.png 300w\" sizes=\"(max-width: 439px) 100vw, 439px\" \/><\/p>\n<p>&#8230; selezioniamo Get license per attivare la proceura di generazione della licenza &#8230;.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-91247\" src=\"https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-06.png\" alt=\"\" width=\"427\" height=\"267\" srcset=\"https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-06.png 427w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-06-300x188.png 300w\" sizes=\"(max-width: 427px) 100vw, 427px\" \/><\/p>\n<p>&#8230; quindi applicarla al nostro server selezionando\u00a0<em><strong>Apply License<\/strong><\/em> &#8230;<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-91248\" src=\"https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-07.png\" alt=\"\" width=\"642\" height=\"327\" srcset=\"https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-07.png 642w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-07-300x153.png 300w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-07-619x315.png 619w\" sizes=\"(max-width: 642px) 100vw, 642px\" \/><\/p>\n<p>Fino alla conclusione della procedura. Passiamo alla fase successiva.<\/p>\n<blockquote>\n<h1>Configurazione<\/h1>\n<\/blockquote>\n<p>L&#8217;addon mette a disposizione una sezione di configurazione. Vi possiamo accedere direttamente dalla sezione degli addon installati, selezionando il nostro addon e il tasto\u00a0<em><strong>Configure<\/strong><\/em> , come mostrato in figura:<img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-91249\" src=\"https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-08.png\" alt=\"\" width=\"1055\" height=\"370\" srcset=\"https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-08.png 1055w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-08-300x105.png 300w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-08-768x269.png 768w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-08-1024x359.png 1024w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-08-619x217.png 619w\" sizes=\"(max-width: 1055px) 100vw, 1055px\" \/><\/p>\n<p>Possiamo in alternativa accedere alla configurazione anche da un nuovo men\u00f9, che \u00e8 stato inserito nella barra laterale, come mostrato nella figura successiva:<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-91250\" src=\"https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-09.png\" alt=\"\" width=\"215\" height=\"132\" \/><\/p>\n<p>Da li accediamo alla seguente sezione:<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-91251\" src=\"https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-10.png\" alt=\"\" width=\"1301\" height=\"545\" srcset=\"https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-10.png 1301w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-10-300x126.png 300w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-10-768x322.png 768w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-10-1024x429.png 1024w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-10-619x259.png 619w\" sizes=\"(max-width: 1301px) 100vw, 1301px\" \/><\/p>\n<p>da dove possiamo configurare il nostro addon. Esaminiamo nel dettaglio che cosa possiamo configurare:<\/p>\n<ul>\n<li>Le licenze dell&#8217;addon, opzione che si attiva attraverso il tasto\u00a0<em><strong>Manage license<\/strong><\/em> e che reindirizza sulla pagina di gestione degli addon<\/li>\n<li>La JIRA Local URL &#8211;<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<blockquote>\n<h1>Test<\/h1>\n<\/blockquote>\n<p>Concludiamo con il test. Possiamo accedere ad una <a title=\"\" href=\"https:\/\/kintosoft.atlassian.net\/wiki\/spaces\/SFJ\/pages\/53025390\/Built-in+SQL+console\" target=\"_blank\" rel=\"noopener\">console di gestione del codice SQL<\/a> dal men\u00f9 di EXPORT di gestione dei Filtri, come mostrato in figura:<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-91252\" src=\"https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-11.png\" alt=\"\" width=\"1260\" height=\"554\" srcset=\"https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-11.png 1260w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-11-300x132.png 300w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-11-768x338.png 768w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-11-1024x450.png 1024w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-11-619x272.png 619w\" sizes=\"(max-width: 1260px) 100vw, 1260px\" \/><\/p>\n<p>Questa funzione ci permette due cose:<\/p>\n<ul>\n<li>Di accedere alla console SQL;<\/li>\n<li>Se abbiamo scritto una funzione in JQL, questa viene tradotta in SQL e riportata in console, come mostrato in figura successiva;<\/li>\n<\/ul>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-91253\" src=\"https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-12.png\" alt=\"\" width=\"1310\" height=\"646\" srcset=\"https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-12.png 1310w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-12-300x148.png 300w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-12-768x379.png 768w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-12-1024x505.png 1024w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-12-619x305.png 619w\" sizes=\"(max-width: 1310px) 100vw, 1310px\" \/><\/p>\n<p>Dalla console lanciamo le nostre query SQL e otteniamo i seguenti risultati:<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-91254\" src=\"https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-13.png\" alt=\"\" width=\"1303\" height=\"657\" srcset=\"https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-13.png 1303w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-13-300x151.png 300w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-13-768x387.png 768w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-13-1024x516.png 1024w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-13-619x312.png 619w\" sizes=\"(max-width: 1303px) 100vw, 1303px\" \/><\/p>\n<p>Ma non \u00e8 l&#8217;unica cosa che possiamo fare: Possiamo anche richiamare direttamente il codice SQL nel nostro JQL, come mostrato dalla seguente immagine:<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-91255\" src=\"https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-14.png\" alt=\"\" width=\"1311\" height=\"629\" srcset=\"https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-14.png 1311w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-14-300x144.png 300w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-14-768x368.png 768w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-14-1024x491.png 1024w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-14-619x297.png 619w\" sizes=\"(max-width: 1311px) 100vw, 1311px\" \/><\/p>\n<p>che ci permette di poter eseguire delle query molto molto molto pi\u00f9 interessanti. Questo ovviamente lo possiamo eseguire a tutti i livelli in cui si richiama JQL. Se andiamo ad osservare la seguente figura:<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-91256\" src=\"https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-15.png\" alt=\"\" width=\"1310\" height=\"554\" srcset=\"https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-15.png 1310w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-15-300x127.png 300w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-15-768x325.png 768w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-15-1024x433.png 1024w, https:\/\/artigianodelsoftware.it\/blog\/wp-content\/uploads\/2017\/09\/SQLForJIRA-02-15-619x262.png 619w\" sizes=\"(max-width: 1310px) 100vw, 1310px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<blockquote>\n<h1>Conclusioni<\/h1>\n<\/blockquote>\n<p>Il risultato del test \u00e8 ottimo. Possiamo estendere il JQL in modo da fargli eseguire delle interrogazioni che con lo standard non riusciremo a fargli eseguire, estendendo le nostre possibilit\u00e0.<\/p>\n<p>&nbsp;<\/p>\n<blockquote>\n<h1>Reference<\/h1>\n<\/blockquote>\n<p>Maggiori informazioni sono reperibili alla <a title=\"\" href=\"https:\/\/marketplace.atlassian.com\/plugins\/com.kintosot.jira.jdbc4jql\/server\/overview?_ga=2.18505146.209503554.1504989890-686594062.1494009693\" target=\"_blank\" rel=\"noopener\">pagina del marketplace<\/a>.<\/p>\n<div class=\"clearfix\"><span class='ldc-ul_cont' onclick=\"alter_ul_post_values(this,'91180','like')\" >Likes<img src=\"https:\/\/artigianodelsoftware.it\/blog\/wp-content\/plugins\/like-dislike-counter-for-posts-pages-and-comments\/images\/up.png\" \/>(<span>0<\/span>)<\/span><span class='ldc-ul_cont' onclick=\"alter_ul_post_values(this,'91180','dislike')\" >Dislikes<img src=\"https:\/\/artigianodelsoftware.it\/blog\/wp-content\/plugins\/like-dislike-counter-for-posts-pages-and-comments\/images\/down.png\" \/>(<span>0<\/span>)<\/span><\/div>","protected":false},"excerpt":{"rendered":"<p>Diamo una marcia in pi\u00f9 In questo post diamo i risultati del test di questo addon, che ci permette di poter estendere le interrogazioni che il JQL standard mette a disposizione, e ci permette di avere delle interrogazioni avanzate. &nbsp;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_editorskit_title_hidden":false,"_editorskit_reading_time":0,"_editorskit_is_block_options_detached":false,"_editorskit_block_options_position":"{}","footnotes":""},"categories":[3,14,15,16,17,154,25],"tags":[30,34,70,71,74,75,76,89,98],"_links":{"self":[{"href":"https:\/\/artigianodelsoftware.it\/blog\/wp-json\/wp\/v2\/posts\/91180"}],"collection":[{"href":"https:\/\/artigianodelsoftware.it\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/artigianodelsoftware.it\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/artigianodelsoftware.it\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/artigianodelsoftware.it\/blog\/wp-json\/wp\/v2\/comments?post=91180"}],"version-history":[{"count":2,"href":"https:\/\/artigianodelsoftware.it\/blog\/wp-json\/wp\/v2\/posts\/91180\/revisions"}],"predecessor-version":[{"id":91257,"href":"https:\/\/artigianodelsoftware.it\/blog\/wp-json\/wp\/v2\/posts\/91180\/revisions\/91257"}],"wp:attachment":[{"href":"https:\/\/artigianodelsoftware.it\/blog\/wp-json\/wp\/v2\/media?parent=91180"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/artigianodelsoftware.it\/blog\/wp-json\/wp\/v2\/categories?post=91180"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/artigianodelsoftware.it\/blog\/wp-json\/wp\/v2\/tags?post=91180"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}