This can be used to build metadata to calculate the length of time an item stays in the Draft state for Time in Draft Report.

Used By: -

• System Administrator

• General User

Steps to run the Length of Time in Draft Report: -

1. Login to Arthrex using the URL ...

2. Go to the Reports tab.

3. Go to the Search bar and search for Time in Draft Report.

   
   

   Here, you will find two versions of the report, Project-specific and System-specific reports.

   Project-specific reports can be run for a particular project.

   System-specific reports can be run across all projects in the system.

   1. To run the project-specific report, select the project-specific report.

      
      

      It will open a new window, where you can select the project for which you want to run the report and click Yes.

      
      

   2. You will see the reports open in the new window.

      There will be 3 columns in the report: - Summary, Status, and Time in Draft (hidden field).

      
      

steps to configure the Time in Draft Report: -

1. Go to the Projects tab and Select the Project "Arthrex template 2".

   
   

2. Go to the Trackers tab.

3. Select a tracker under the Trackers tab. Right-click on one of the trackers and select Configure.

   
   

   It will open a new window for that tracker.

4. Go to the Fields tab and check Show hidden fields.

   
   

5. Click on the Draft Entry Time.

   It will open a new window.

6. Draft Entry Time should be a Date field and Shared Field should be Draft Entry Time and Click OK.

   
   

7. Go to the tab State Transitions.

8. For the In Review to Draft transition, click on the three dots and select Edit.

   
   

9. Keep Actions as Update item properties.

10. Click on the Edit button beside Update item properties.

    
    

11. Set the Draft Entry Time as 'Set to' value 'Now' and click OK.

12. Repeat steps 8 to 11 for every row where To columns refer to Draft status. In this case, Draft comes 4 times in the To Column. Therefore, we will have to repeat the same steps 3 more times.

13. Again go to the Fields tab and click on Time in Draft Value.

    
    

14. Write appropriate code in the field Computed as and click OK.

    
    

15. Again go to the Fields tab and click on Time in Draft.

    
    

16. Click on the Show property name text box to show the Property column. Make note of the property name for Time in Draft Value field.

    
    

17. Open the settings for the Time in Draft field and add the property name for Time in Draft Value in the Computed as text box. We are doing this because fields with "Computed as" settings that use any time-based functions will not show properly in the reports tab. We want to pick the property name from the field Time in Draft Value and in this case, the property name for Time in Draft Value is customField[15] (it may be a different property name in any other given tracker) and then click OK.

    
    

18. Repeat steps 3 to 17 for every tracker under the Tracker tab for which you want to see the Time in Draft report.

Steps to take the export of the report: -

1. Once the report is created, click on the Export to Office button.

   
   

2. Select Simple Excel Export and Click Export.

   
   

3. The Excel file will be downloaded to your Downloads folder.