The steps below detail the process of creating a data export to show all current running workflows related to absences e.g Absence requests, absence entry workflows.
This query will show all tasks that are currently active in employee task lists.
In the Admin Tool, click Import/Export Data.
Click Create an export definition.
Click Select the data to export.
Change the database to SelectSystem.
Log in.
Copy the below SQL:
Select Top 100 Percent Workflow.[User Task List].[Instance Number], Users1.[User Name] As [Initiated By], Workflow.Instances.Created As [Initiated Date], Workflow.[User Task List].Description As [Task Description], Workflow.[User Task List].Action As [Action Required], Security.Users.[User Name] As [Currently Assigned User], Workflow.[User Task List].[Workflow Name] As [Workflow Name] From Workflow.[User Task List] Inner Join Security.Users On Workflow.[User Task List].[User Number] = Security.Users.[User Number] Inner Join Workflow.Instances On Workflow.[User Task List].[Instance Number] = Workflow.Instances.[Instance Number] Inner Join Security.Users Users1 On Workflow.Instances.Initiator = Users1.[User Number] Where Workflow.[User Task List].[Workflow Name] Like '%absence%' Order By Workflow.Instances.Created
In the top left of the data export window, click Options, Paste SQL from clipboard.
Click Data.
Once the data export is created, a Primary Key must be selected. Click the Key Field icon and select the appropriate Key. The Key Field must be represented by a number (i.e. Person Number, Absence Number etc.). When the export is finished it can be saved for future use.
Click OK to continue the export. The Data Export Wizard windows appears.
In the Definition name field, enter a full name. This will be the name of the report saved in the Admin Tool, which can be edited in the future, if needed. There is more information available about how to edit an existing report.
Click Browse to choose a location for the report exported to Excel.
In the File name field, enter a name. This will be the name of the Excel document once exported on the local machine.
Use the File Format drop-down and select Microsoft Excel 97-2003.
Click Next. A preview of the data appears.
In the Column section under the columns preview, click a column header to select a column and set export options.
Click Next.
Click the Open file after export check box. The document will then open once the export is completed.
Click Finish. The Export will now appear in the External Data Transfers list and can be run again.