Information required in the By processes filter:

From the current date / Until

Required information:

Date
Start and end dates establishing a period within which the requests are considered in the query.to query requests.

From the request / UntilStatus
Status of the requests to be considered in the queryqueried requests. Available options are::

Status
Select the type of request to query.

• Finished: when it is checked, finished or canceled requests are considered in the query;
• Open: when it is selectedchecked, the requests that are in progress are considered in the query.

• Canceled: when checked, canceled requests are considered in the query.

Request
Request code to be queried separated by semicolon (;) or start and end codes establishing a range of request numbers to be considered in the query. You can only enter a range if the Search by range option is checked.

• Requests I started

• : When

• checked, all requests started by the authenticated user are considered in the query.
• Requests I participated in

• : When

• checked,

• requests in which the authenticated user participated are

• queried.
• Requests I participated in as manager/

• alternate: When checked, all requests in which the authenticated user participated as a manager or

• alternate are queried.
• Requests under my management

• : When

• checked, all process requests

• in which the authenticated user

• is the manager are queried.
• All requests

• : When

• checked, all process requests are

• queried. Only an Administrator user has permission to view all process requests. The processes defined as public can be viewed by all users

Version
Version of the selected process to be considered in the query requests. When the All processes option is selected, you cannot select a version, unless a specific process has been selected. To consider the requests of all versions of the process, select the All versions option.

• .

Search by description
Enter the searched process description in the blank field next to “By processes”. Alternatively, click the blank field to list the processes below.

Open the request to view details such as the process diagram, forms and attachments, among others. Refer to View request details for more information..

The query export will run in the background. When it is finished, the platform posts the file in the user’s private folder, which must be enabled, and notifies you by e-mail when the process is complete. This exported file necessarily must contain the following columns:

• Request: number of the request;
• Description: description of the process;
• Status:  status of the request;
• Requester registration: registration of the requester;
• Requester: name of the user that is the requester;
• Location: activity in which the request is;
• Person in charge: name of the person responsible for the activity in which the request is;
• Start: date on which the request was initiated;
• End: date on which the request was completed (if completed).

The columns above are default and always appear at the beginning of the exported file. Data related to the activities and forms can also be added to this file. However, the order in which these columns are displayed can be changed, depending on the amount of requests, activities moved and form fields defined in the query parameters.

When the Add activity data option is checked for the ongoing activity, the person currently responsible for it is displayed, and the completion date column is left blank. Only the activities through which some query request went through will be listed. The other activities of the process will not be displayed. The exported file will include data for the movement of activities of the processes selected for the query. Only moved activities will be included. Therefore, the movement of the request can generate a greater number of columns. Each activity is represented by two columns:

• Activity - [Name of the activity] - Person in charge: Person in charge name.
• Activity - [Name of the activity] - Completion: Date of movement.

When the Add form data option is checked, the file adds the fields of the forms related to the processes selected for query. The form fields are included in the exported file for each process found, forming a cascade of information, and the order of the columns for each form depends on its storage model.

• If the form is stored in a single table: fields are displayed in alphabetical order in the file columns;

If the form is stored in multiple tables: the fields are displayed in the same order that they were added to the form. In the first version, they will be displayed in the same order they were added when the form was created. In subsequent versions, each new field added to the form will be included at the end of the file.

Available options:

• Add activity data

• When checked, it displays the name of the person in charge and the completion date of all finished process activities. If you check this option, you will not be able to view the query results on the screen, only their export will remain enabled. For the ongoing activity, the person currently responsible for it will be displayed, and the completion date column will be left blank. Only the activities through which some query request went through will be listed. The other activities of the process will not be displayed.

• Enter request deadline information:

• Add form data

• : When

• checked, the data entered in the form fields of each request are included in the query results. If you check this option, you will not be able to view the query results on the screen, only their export will remain enabled.

• Add multiple records

• : When

• checked, data from the form child fields are also added. This option is only enabled if the Add form data option is checked.

• Group multiple records

• : When

• checked, the data from the form child fields are grouped into a single cell in the

• worksheet. This option is only enabled if the Add multiple records option is checked

If a request query is exported and the platform notification is not delivered, the completion notification e-mail is not received, and the file is not generated, the user probably does not have the My Documents folder where the file must be saved. In this case, open the Control Panel, General - Parameters tab, and check the option “Enable my documents”.

If the folder does not appear after completing this procedure, a database Insert must be performed. Open a ticket for the support team informing the database type and version, and inform whether it was converted from ECM to TOTVS Fluig Platform.