Search: set-web-attribute-1
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Location
- 120Activities
- 29akaBot Center
- 15akaBot Vision
- 6akaBot Agent
- 6akaBot Insights
- … 9 more
Last author
- 79admin
- 48Nga Nguyen
- 18VuNH54
- 15DatPT
- 15Tuan Nguyen
- … 5 more
Creator
- 129admin
- 21Nga Nguyen
- 21Tuan Nguyen
- 13Giang Tran
- 7DatPT
- … 3 more
Last modification date
Creation date
Object type
File type
Uploaded by
- 58admin
- 48Nga Nguyen
- 29Nhan Nguyen
- 21Tuan Nguyen
- 12Giang Tran
- … 3 more
Upload date
Write Range
Located in
- Rendered document content
. By default, this check box is selected (set to True).
- Raw document content
-20220505135914-1.jpeg]] (* for mandatory) == **In the body of activity** == * **Workbook Path** - The path
…are also extracted. By default, this check box is selected (set to True). ))) {{velocity
Excel Application Scope
Located in
- Rendered document content
of InterOp.Excel._Application's properties to be set and their values Macro setting (DropDownList) - Specifies
…Excel Macro settings Read Only (Checkbox): Opens the specified workbook in Read-Only mode. Selecting
- Raw document content
for Excel Activities. [[image:image-20220505111836-1.jpeg]] (* for mandatory) == **In the body
…of InterOp.Excel._Application's properties to be set and their values * **Macro setting (DropDownList
…the current Excel Macro settings * **Read Only (Checkbox)**: Opens the specified workbook in Read-Only mode
Insert Data Table
Located in
- Rendered document content
) In the body of activity Configure Connection - Set connection string, data source, data provider. Data
…is set, the others can no longer be set. Provider Name* - The name of the database provider used
- Raw document content
, the activity will fail and all the written rows will be saved. [[image:image-20220506105511-1.png]] (* for Mandatory) == **In the body of activity** == * **Configure Connection **- Set connection string, data
…/Database%20Connect/WebHome/image-20230419153435-1.png?rev=1.1||alt="image-20230419153435-1.png"]] * **Data
Execute Query
Located in
- Rendered document content
Configure Connection - Set connection string, data source, data provider. Edit Query - SQL command
…and the ConnectionString and ProviderName properties are mutually exclusive; if this property is set, the others can no longer be set. Provider Name* - The name of the database provider used to access the database. E.g
- Raw document content
-20220506105340-1.png]] (* for Mandatory) == **In the body of activity** == * **Configure Connection **- Set
…/Database/Activities/Database%20Connect/WebHome/image-20230419153435-1.png?rev=1.1||alt="image-20230419153435-1.png"]] * **Edit Query** - SQL command to be executed. This field must be completed according
Execute Non Query
Located in
- Rendered document content
affected by the command. For all other types of statements, the return value is -1. (* for Mandatory) In the body of activity Configure Connection - Set connection string, data source, data provider. Edit
…exclusive; if this property is set, the others can no longer be set. Provider Name*- The name
- Raw document content
. For all other types of statements, the return value is -1. [[image:image-20220506105309-1.png]] (* for Mandatory) == **In the body of activity** == * **Configure Connection **- Set connection string, data
…/Database%20Connect/WebHome/image-20230419153435-1.png?rev=1.1||alt="image-20230419153435-1.png"]] * **Edit
Database Transaction
Located in
- Rendered document content
. If UseTransaction is set to true, the contained operations are executed in a single transaction and applied at the end if none of them failed. If UseTransaction is set false, all operations are committed individually
…a DatabaseConnection variable. (* for Mandatory) In the body of activity Configure Connection - Set connection
- Raw document content
that can perform multiple transactions with the database. If UseTransaction is set to true, the contained
…. If UseTransaction is set false, all operations are committed individually. When this activity ends, the connection to the database is closed. This activity returns a DatabaseConnection variable. [[image:image-20220506105232-1
Database Connect
Located in
- Rendered document content
RCA.Activities.Core.DatabaseConnect Description This activity allows you to connect to a database by using a standard connection string. (* for Mandatory) In the body of activity Configure Connection - Set connection string, data source, data provider. Properties Connection Configuration
- Raw document content
of activity** == **Configure Connection **- Set connection string, data source, data provider. [[image:image-20230419153435-1.png]] == **Properties** == **Connection Configuration** * **Connection String (String
Join Data Tables
Located in
- Rendered document content
RCA.Activities.Core.JoinDataTables Description This activity allows you to add different data from different tables using common values with each other. (* is mandatory) In the body of activity Join Table Wizard - set join condition and join type Properties Input Data Table1 (DataTable
- Raw document content
"]]>>attach:join data table.jpg]] (* is mandatory) == **In the body of activity** == **Join Table Wizard - **set join condition and join type** ** [[image:image-20230419151628-1.png]] == **Properties** == **Input
Filter Data Table
Located in
- Rendered document content
contains a Filter Wizard button so that you can access the wizard and customize your settings at any time. (* is mandatory) In the body of activity Filter Wizard - Set filter for rows, set output columns Properties
- Raw document content
of activity** == **Filter Wizard **- Set filter for rows, set output columns [[image:image-20230419143358-1
…button so that you can access the wizard and customize your settings at any time. [[[[image:filter data
Build Data Table
Located in
- Rendered document content
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, update column name/ column type Properties Misc Public (Checkbox) - Check if you want to publicize
- Raw document content
settings. [[[[image:build data table.jpg||class="img-thumbnail"]]>>attach:build data table.jpg
…[[image:image-20230419142900-1.png||height="299" width="422"]] == **Properties** == **Misc** * **Public