Search: look-up-data-table

Database Connect Database Disconnect Database Transaction Execute Non Query Execute Query Insert Data Table

/view/Activities/Database/Activities/Execute%20Query/]] * [[Insert Data Table>>url:https

to add a collection of items to a data table to a specific queue. Once it is added to the queue

) - The data table that you want to add the queue into. QueueName (String) - The queue to which the new queue

Output Result (DataTable) - This is the data table that you have added to the queue.

of items to a data table to a specific queue. Once it is added to the queue, the items’ status is changed

. The default value is: AllOrNothing * **Queue Items DataTable (DataTable)** - The data table that you want

**Output** * **Result (DataTable) **- This is the data table that you have added to the queue

the edit option from Action next to the corresponding OU Name S4: After clicking, a pop-up form shows up

: Then a pop-up form will show up for you to fill in S4: Tick in the box to give permission for your new

/ Edit button, the system will show a form for you to fill in. Details in the table below: After

-20230308181201-4.png]] S4: After clicking, a pop-up form shows up for you to fill in the information

-20230308181201-7.png]] S3: Then a pop-up form will show up for you to fill in [[image:image-20230308181201-8

on** Create New/ Edit** button, the system will show a form for you to fill in. Details in the table below

to consider data security requirements before using it. Display Name (String) - The name of this activity. You

. Reference Filter Strategy - You can filter data according to the reference. There are two options: ・Start with: Look for items whose references start with the value indicated in the reference field. ・Equals: looks

filter data according to the reference. There are two options: ・Start with: Look for items whose references start with the value indicated in the reference field. ・Equals: looks for items whose references

if you want to publicize it. Remember to consider data security requirements before using it. * **Display

the file path of the CSV here. String supported only. Data Table (DataTable) - Specifies the DataTable to be written in the CSV file. Properties Input Data Table (DataTable)* - Specifies the DataTable

\clientList.csv” Misc Public (CheckBox) - If you check it, the data of this activity will be shown in the log

** == * **File Path (String)** - You can add the file path of the CSV here. String supported only. * **Data Table (DataTable)** - Specifies the DataTable to be written in the CSV file. == **Properties** == **Input** * **Data Table (DataTable)*** - Specifies the DataTable to be written in the CSV file

, there is a confirmation pop-up. Read the content carefully then tick all checkboxes to confirm that you understand

will be also deleted. Moreover, documents usage data will be deleted from statistics Step 3: Click

" button, there is a confirmation pop-up. Read the content carefully then tick all checkboxes to confirm

data will be deleted from statistics ))) [[image:image-20221019135915-7.png||cursorshover="true

want to publicize it. Remember to consider data security requirements before using it. Display Name

in a QueueItem variable. Reference Filter Strategy - You can filter data according to the reference. There are two options: ・Start with: Look for items whose references start with the value indicated

Strategy** - You can filter data according to the reference. There are two options: ・Start with: Look for items whose references start with the value indicated in the reference field. ・Equals: looks for items

** * **Public (Checkbox) **- Check if you want to publicize it. Remember to consider data security requirements

(DataTable) - Stores the data extracted from the specified Excel range in a data table variable. Only data

” Sheet name (String)* - The sheet you want to read. E.g: "Sheet1" Range - Range of the data. If it isn’t

)- The sheet you want to read. E.g: "Sheet1" Range - Range of the data. If it isn’t specified, the whole

range in a data table variable. Only data table variables are supported ))) {{velocity

: "Sheet1" * **Range** - Range of the data. If it isn’t specified, the whole spreadsheet will be read. E.g

want to read. E.g: "Sheet1" * **Range** - Range of the data. If it isn’t specified, the whole

Step 1: Navigate to the Data tab of the desired entity in Data Service. Step 2: To apply more filters on your results list, click Advanced Filter. The pop-up Advanced Filter will open Step 3: User Advanced Filter Select the operator: AND - to return the entries that match all conditions

[8] Advanced Filter in Data Service

Data Service

[2] How to use Data Service

[8] Advanced Filter in Data Service

(% class="box infomessage" %) ((( **Step 1: ** Navigate to the **Data** tab of the desired entity in Data Service. ))) [[image:image-20230630132517-1.png]] (% class="box infomessage" %) ((( **Step 2**: To apply more filters on your results list, click **Advanced Filter**. The pop-up Advanced Filter will open

RCA.Activities.Excel.GetExcelColumnName Description Based on the column's index, you can look for it and returns the name to String variable. (* for mandatory) Properties Input Column Index: (Int32

the activity. Remember to consider data security requirement before using this property. Display Name (String

RCA.Activities.Excel.GetExcelColumnName == **Description** == Based on the column's index, you can look for it and returns the name to String variable. [[image:image-20230420113044-1.png

to consider data security requirement before using this property. * **Display Name (String) **- The name