Search: sort-data-table
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Location
- 243Activities
- 20akaBot Vision
- 10akaBot Center
- 3akaBot Insights
- 2Data Service
- … 4 more
Last author
- 60Tuan Nguyen
- 55Nga Nguyen
- 54admin
- 47VuNH54
- 39Nhan Nguyen
- … 4 more
Creator
- 186admin
- 42Tuan Nguyen
- 26Nga Nguyen
- 19Giang Tran
- 8Nhan Nguyen
- … 2 more
Last modification date
Creation date
Object type
- 2Activities
- 1Overview
- 1aka Bot Vision
Uploaded by
- 106Nga Nguyen
- 78Nhan Nguyen
- 50admin
- 43Tuan Nguyen
- 21Giang Tran
- … 3 more
Upload date
Join Data Tables
Located in
- Rendered document content
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
- Title
Join Data Tables
- Attachment name
join data table.jpg
- Location
Data Table
…Join Data Table
- Raw document content
" %) ((( 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
Filter Data Table
Located in
- Rendered document content
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
- Title
Filter Data Table
- Attachment name
filter data table.jpg
- Location
Data Table
- Raw document content
.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
Insert Data Table
Located in
- Rendered document content
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
- Title
Insert Data Table
- Location
Insert Data Table
- Raw document content
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
[4] Capture Custom Table Data
Located in
- Rendered document content
. Adding a new table In order to create a new table, click [Add Field], select Data Type = “table
…A basic element in the extraction schema is the data field. However, akaBot Vision enables the capture of even more complex structures like tables. Adding a predefined table field If you are missing
- Title
[4] Capture Custom Table Data
- Location
Capturing Custom Table Data in akaBot Vision
…Customizing Data Extract
- Raw document content
, click [Add Field], select Data Type = “table” and then input the value you want to create a new table
…="wikigeneratedid" id="HParagraph1" %) A basic element in the extraction schema is the data field. However, akaBot Vision enables the capture of even more complex structures like tables. == **Adding a predefined table
[4] カスタムテーブルデータのキャプチャ (ja)
Located in
- Rendered document content
抽出スキーマの基本要素はデータフィールドです。ただし、akaBot Visionを使用すると、テーブルなどのさらに複雑なデータ構造をキャプチャできます。 事前定義されたテーブルフィールドの追加 ドキュメントからデータをキャプチャするときに一部のフィールドが欠落している場合は、キュー設定の「Fields to capture」タブに移動します。このタブでは、事前トレーニングされたデータフィールドを管理し、どのフィールドを抽出するかを選択できます。 新しいテーブルの追加 新しいテーブルを作成するには、「Add Field」をクリックし、「Data Type」の「table」を選択して、新しい
- Raw document content
-20220421003652-1.png||data-xwiki-image-style-alignment="center"]] == **新しいテーブルの追加** == 新しいテーブルを作成するには、「Add Field」をクリックし、「Data Type」の「table」を選択して、新しいテーブルの値を入力します。 (% style="text-align:center" %) [[image:image-20220421003652-2.png||data-xwiki-image-style-alignment="center"]] ))) ))) ))) (% class="akb-toc
- Location
Capturing Custom Table Data in akaBot Vision
…Customizing Data Extract
[2] モデルへの新しいフィールドの追加 - akaBot Docs (ja)
Located in
- Rendered document content
で、「Form Field」の行にある「Add Field」ボタンをクリックします。 ステップ2:「Label」にテーブル名を入力し、「Data Type」の「table」を選択します。 ステップ3
…をクリックします。 ステップ2:「Label」にフィールド名を入力し、「Data Type」でフィールドのデータ型を選択します。 ステップ3:(オプション)「Required」ボタンをオン
- Raw document content
||cursorshover="true"]] (% class="box infomessage" %) ((( **ステップ2**:「Label」にテーブル名を入力し、「Data Type」の「table」を選択
…"]] (% class="box infomessage" %) ((( **ステップ2:**「Label」にフィールド名を入力し、「Data Type」でフィールドのデータ型を選択します。 ))) [[image
[6] Query Entity Records
Located in
- Rendered document content
a list of records for the selected Entity from the Data Service, according to specified filters
…supports entities imported from Data Service. Click to add filter, the Query Builder window opens Choose
…entities imported from Data Service Input Record: the ID of the record you want to retrieve from the entity
- Location
Data Service Activities
…Data Service Studio Activities
- Raw document content
Entity from the Data Service, according to specified filters. == **In the body of activity
…imported from Data Service. * Click to add filter, the Query Builder window opens ** Choose the condition
…with the activity. The property only supports entities imported from Data Service * Input Record: the ID
[4] APIレソース (ja)
Located in
- Rendered document content
False リクエストされたページのページ番号 size 整数 False ページのサイズ(上部) sort 文字列 False プロパティ(,asc|desc)形式でのソート基準 例:login
…False ページのサイズ(上部) sort 文字列 False プロパティ(,asc|desc)形式でのソート基準 例:name,asc レスポンス ReturnType: Collection
…リポジトリにアップロードします。サポートされているメソッド:Post パラメータ 名称 パラメータータイプ 形式 コンテンツタイプ package form-data File multipart
- Raw document content
のサイズ(上部) |sort|文字列|False|((( プロパティ(,asc|desc)形式でのソート基準 例:login,asc ))) レスポンス ReturnType:Collection
…) |sort|文字列|False|((( プロパティ(,asc|desc)形式でのソート基準 例:name,asc ))) レスポンス ReturnType: Collection(WorkFlow
…パラメータ |名称|パラメータータイプ|形式|コンテンツタイプ |package|form-data|File|multipart/form-data |environmentIds|form-data
[4] API resources
Located in
- Rendered document content
number of the requested page size Integer False Size of a page(top) sort String False Sorting criteria
…of the requested page size Integer False Size of a page(top) sort String False Sorting criteria in the format
…form-data File multipart/form-data environmentIds form-data Array[long] application/json Response
- Raw document content
|Size of a page(top) |sort|String|False|((( Sorting criteria in the format: property(,asc|desc) Ex
…|size|Integer|False|Size of a page(top) |sort|String|False|((( Sorting criteria in the format: property
…|Parameter Type|Type|Content Type |package|form-data|File|multipart/form-data |environmentIds|form-data|Array
[1.2] API Reference
Located in
- Rendered document content
organization's data and account information. In this document, you will find an introduction to the API usage
…is processed successfully and the user can export data via calling API Export Document with input parameters
…to review documents then change it to "Confirmed" status by API Update Document Status before exporting data
- Raw document content
** == The akaBot Vision API allows you to programmatically access and manage your organization's data and account
…and the user can export data via calling API (%%)[[Export Document>>https://docs.akabot.com/bin/view/akaBot
…%20with%20RPA/API%20Automation/#H4.UpdateDocumentStatus]](% style="color:#000000" %) before exporting data