検索：clear-data-table

RCA.Activities.Core.BuildDataTable Description This activity allows you to create a new Data Table with different settings. In the body of activity Data Table - Click to add/ remove columns

Table Output Data Table (DataTable) - The Data Table variable that contains the generated table.

Build Data Table

build data table.jpg

Data Table

Build Data Table

" %) ((( RCA.Activities.Core.BuildDataTable == **Description** == This activity allows you to create a new Data Table with different

]] == **In the body of activity** == **Data Table **- Click to add/ remove columns, update column name/ column type

to organize and structure your code better. **Eg**: Build Data Table **Output** * **Data Table (DataTable

Join Table Wizard - set join condition and join type Properties Input Data Table1 (DataTable

supports only DataTable variables. Data Table2 (DataTable)* - The second table that you want to use

to organize and structure your code better. Eg: Join Data Table\ Option Join Type (JoinType) - INNER/LEFT

Join Data Tables

join data table.jpg

Data Table

Join Data Table

" %) ((( RCA.Activities.Core.JoinDataTables == **Description** == This activity allows you to add different data from different tables

"]]>>attach:join data table.jpg]] (* is mandatory) == **In the body of activity** == **Join Table Wizard - **set

** * **Data Table1 (DataTable)*** - The first table that you want to use in the Join operation, is stored

Input Data Table (DataTable)* - The DataTable variable that you want to filter. This field supports

. Output Data table (DataTable) - the filtered Data table as an output of the activity, stored

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

Filter Data Table

filter data table.jpg

Data Table

.png||height="341" width="482"]] == **Properties** == **Input** * **Data Table (DataTable

. **Output** * **Data table (DataTable)** - the filtered Data table as an output of the activity, stored

button so that you can access the wizard and customize your settings at any time. [[[[image:filter data

and descriptions must match the ones from the database table. Table Name - The SQL table in which the data

to access the database. E.g: “System.Data.SqlClient” Input Data Table (DataTable)* - The DataTable

the ones from the database table. Table Name (String)*- The SQL table in which the data is to be inserted

Insert Data Table

Insert Data Table

and descriptions must match the ones from the database table. * **Table Name **- The SQL table in which the data

” **Input** * **Data Table (DataTable)*** - The DataTable variable that will be inserted into the Table

(String)***- The SQL table in which the data is to be inserted. E.g: “TargetedTable” **Misc** * **Public

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

a conditions, click the corresponding Delete icon or if you want to clear all filter, click Clear all

[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 clear all filter, click **Clear all conditions** button ))) 1. Click **Filter** to rerun the search

Table Tabs Well Data Include components used to collect data Hidden Container Data map Data grid Edit

the ability to collect user data UI components are divided into 5 main groups, based on their functions

to fill in. Then click Save when you are done. The below table describes frequently used configure

|((( * HTML element * Content * Columns * Field set * Panel * Table * Tabs * Well ))) |Data|Include components used to collect data|((( * Hidden * Container * Data map * Data grid * Edit grid * Tree ))) |Premium

provide users the ability to collect user data [[image:1695034818758-663.png||height="379" width="1014

and choose data type is "Table". Step 3: (This step is optional) Turn on button "Required" to set require

and data type for each column Step 6: Click "Save" button Table of Content

and Table Field 1. Add Form Field Step 1: On Add Learning Instance screen, click "Add Field" button

the table name on "Label" field and choose data type is "Table". ))) [[image:image-20221028164141-11.png

types of fields: Form Field and Table Field == **1. Add Form Field** == (% class="box infomessage

the field name on "Label" field and choose data type for field on "Data Type" field ))) [[image:image

of the activity to organize and structure your code better. E.g: Get the data table Public (Checkbox) - If you

using it. Output Data Table (DataTable)- The Table is extracted from the Word Document and stored

RCA.Activities.Word.GetTable Description This activity allows you to retrieve a table from

Get Table

Get Table

the data table * **Public (Checkbox) **- If you check it, the data of this activity will be shown in the log. Be careful, consider data security before using it. **Output** * **Data Table (DataTable

== **Description** == This activity allows you to retrieve a table from a Word Document and return

based upon the value entered in the ROI data set table, as well as the days until your defined goal

the Manual Time value entered in the ROI data set table. Goal Input Static display of your defined

to date, based upon the Manual Time value entered in the ROI data set table. Displays the Top 10

 value entered in the **ROI data set table**. ))) |((( **Goal ** )))|((( Input )))|((( Static display

in the **ROI data set table**. ))) |((( **Cumulative Time Saved** )))|((( Column Chart )))|((( Total time saved

** )))|((( Input )))|((( Displays the current total of money saved based upon the value entered in the **ROI data

to public it. Remember to consider data security requirement before using it. Display Name (String

(CheckBox) - Specifies whether to mark retrieved messages as read. By default, this check box is cleared

data security requirement before using it. * **Display Name (String)** - The name of this activity

is cleared. * **Only Unread Messages (CheckBox)** - Specifies whether to retrieve only unread messages

') (% class="akb-toc" %) ((( (% class="akb-toc-title" %) ((( Table of Content ))) {{toc depth="4" start