GetTransactionCount

This activity helps the user to fetch the “Transaction” count against the
specified status from the Project in the Interact.

Technical Reference

 

INPUT

FromDate: Indicates the starting date from which transactions need to be retrieved based on the respective 'Status' provided.

 

This parameter accepts the values in “String” datatype.

 

You can either hardcode the values in “String” datatype or can enter the values in “String”.

 

When left empty, all transactions corresponding to the provided status will be fetched.

 

Status: Indicates to provide the “Status” of the transaction in the “Interact” to fetch the count against it. The status are supported by the activity are as follows,

New: Fetches the count of transactions from the “New” state of the transactions.

Locked: Fetches the count of transactions from the “Locked” state of the transactions.

NewLocked: Fetches the count of transactions from the “New Locked” state of the transactions.

Both: Fetches the count of transactions from the “New and Locked” state of the transactions.

 

You can either hardcode the values in “String” datatype or can enter the values in “String”.

 

This parameter accepts values in “String” datatype.

 

ToDate: Indicates the ending date until which transactions should be retrieved based on the respective 'Status' provided.

 

This parameter accepts the values in “String” datatype.

You can either hardcode the values in “String” datatype or can enter the values in “String”.

 

When left empty, all transactions corresponding to the provided status will be fetched.

MISC

DisplayName: Displays the name of the activity. The activity name can be customized, which aids in troubleshooting.

SkipOnError: Specify the "Boolean" value as "True" or "False."

True: Continue executing the workflow regardless of any errors thrown.

False: Halt the workflow if it encounters any errors.

None: If the option is left blank, the activity will, by default, behave as if "False" were chosen.

Version: It indicates the version of the feature being used.

OUTPUT

ResponseDatatable: It helps to view the output of the activity as total count of the transactions available in the project with the respective “Queue name” and “Queue type”.

 

It returns in the values in “Datatable” datatype.(Refer the below documentation to declare the variable).

Result: It provides the ability to view the execution status of the activity. It returns values in "Boolean."

 

True: Indicates that the activity has been executed successfully without any errors.

False: Indicates that the activity has been unsuccessful due to an unexpected error being thrown.

Represents mandatory fields to execute the workflow

Here’s an example of how the “Get Transaction Count” activity works –

In the following example, I am continuing from the “GetTransaction” activity. To get
a detailed understanding, click here. Here I am using the “Get Transaction count”
activity to extract the transaction count from the “New” status available in the
“Interact” configured.

Steps to execute a bot

1.       Create a solution for building a workflow or open an existing solution.

2.       Drag and drop the "Get Transaction Count" activity onto the designer pane
and set it as start node.

a.       It helps to extract the transactions count available in the “Interact” page
against the project.

3.       Double click on the activity.

a.       Here I am providing the status as “New” to fetch the count.

4.       Next, moving to the “FromDate” in the properties to provide the date from
when the transaction’s count needs to be fetched.

a.       Here, I am providing the value as “2024/04/16” in the field.

5.       Then, providing the “ToDate” until when the transactions should be
fetched. In this case, I am providing the value as “2024/04/17”.

6.       Navigating to the “ResponseDatatable” property in the output field of
“Get Transaction count” activity to declare a variable to view the output
of the activity.

i.       There are two ways to declare a variable,

ii.      Method 1 – Click on the "ResponseDatatable" property within the
"Get Transaction Count" activity and enter the variable name. In this case,
we are using " DT." Then, press "Ctrl+Q," which is a shortcut key to create
a variable.

iii.      Method 2 - Click on the Variables pane and enter the name "ResponseDT".
Then, in the "Variable Types" column, select "Browse for Types" from the
dropdown menu.

iv.      The .Net window for data types will appear on the screen, enter the
type name as “System.Data.Datatable” and then click on “OK” button.

5.       You can add the “Tableviewer” activity to view the output of the “Search
Transaction” activity. Below is the sample of the output of the activity.

The bot will fetch the count from the “New” status from all the queue
available in the “Interact”.