{"id":2516,"date":"2020-10-27T08:39:48","date_gmt":"2020-10-27T07:39:48","guid":{"rendered":"https:\/\/www.actonic.de\/?p=2516"},"modified":"2023-03-31T10:47:14","modified_gmt":"2023-03-31T08:47:14","slug":"custom-scripts-with-report-builder-part-one","status":"publish","type":"post","link":"https:\/\/actonic.de\/en\/custom-scripts-with-report-builder-part-one\/","title":{"rendered":"Jira custom reports: custom Jira Scripts with Report Builder | part 1"},"content":{"rendered":"

[vc_row][vc_column][heading title=”Report Builder: What it is & what it does” heading=”h2″ font_weight=”” el_id=”1602830448735-8502bece-3f3f”][vc_column_text]Report Builder<\/strong><\/a> helps organizations with any type of Jira reporting need. The app has built-in personal and time reports templates, which cover most reporting needs. In the section Scripted Reports you will also be able to build reports from scratch,<\/strong> by implementing any type of calculation algorithm, parameter and visualization library. Build your own report with HTML and JavaScript basics.<\/strong>[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][heading title=”Reporting essentials in Report Builder” heading=”h2″ font_weight=”” el_id=”1602830472010-25a9eca5-6b2f”][vc_column_text]<\/p>\n

    \n
  1. You fill in some report parameters, like scope, dates, etc.<\/li>\n
  2. You get raw data based on input parameters: projects, tickets, work logs, etc.<\/li>\n
  3. You apply an algorithm to\u00a0calculate\u00a0your report based on raw data and input parameters<\/li>\n
  4. You format your results to get the\u00a0report in table, chart or any other format<\/li>\n<\/ol>\n

    [\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][heading title=”Let’s build a report” heading=”h2″ font_weight=”” el_id=”1602830495345-0c6e7018-9f6d”][vc_column_text el_class=”subhead”]<\/p>\n

    Our example: Actual time vs. estimation<\/p>\n

    [\/vc_column_text][vc_column_text]The process of report creation with Scripted Report is split into three tabs:<\/p>\n

      \n
    1. General<\/strong><\/li>\n
    2. Template<\/strong><\/li>\n
    3. Script<\/strong><\/li>\n<\/ol>\n

      One more tab called Permissions will be useful if you want to share the report with someone, but we’ll cover this part at the end of this guide.<\/p>\n

      Let’s try to solve the task of getting a time tracking report from Jira based on JQL query and get an understanding of each tab.[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][heading title=”Tab 1: General” heading=”h2″ font_weight=”” el_id=”1602830533968-d57ba618-2a74″][vc_column_text]The tab provides the ability to add input fields and define the category of your report. At the moment there are more than 10 predefined input field types. You can choose any category from the list or skip this step.<\/p>\n

      In our case, we will choose the category “Table”, because it would be a great way to see the estimated time over the spent time in table format.<\/p>\n

      We create two input fields:<\/u><\/p>\n