WorkFlowActions

Create, update, delete, and query the wokflow actions in SuiteCRM.

テーブル固有の情報

WHERE 句で任意の条件を使用して、Workflow Actions テーブルをクエリできます。本製品はSuiteCRM API を使用して結果をフィルタリングします。

SELECT * FROM [Workflow Actions] WHERE Action = 'Create Record' AND [Date Created] < '2017-10-09'

書き込み可能なカラムを指定して、Workflow Action を作成します。

INSERT INTO [Workflow Actions] (Name, Action, LBL_WORKFLOW_ID) VALUES ('First action', 'Modify Record', 'exampleWFId')

Id を指定して、書き込み可能なWorkflow Action カラムを更新できます。

UPDATE [Workflow Actions] SET [Parameters] = 'name:test;status:complete;' WHERE Id = 'Test123'

Id を指定して、Workflow Action を削除します。

DELETE FROM [Workflow Actions] WHERE Id = 10003


Name	Type	ReadOnly	Description
ID [KEY]	String	False	The unique identifier of the workflow.
Action	String	False	The Specific action to be taken during the worklow
CreatedById	String	True	The Id of the user who created the record.
CreatedByName	String	True	The name of the user who created the record.
DateCreated	Datetime	True	The date the record was created.
DateModified	Datetime	True	The date the record was last modified.
Deleted	Bool	False	The record deletion indicator.
Description	String	False	Description for the workflow
LBL_ORDER	Int	False	The order of the worflow's action
LBL_WORKFLOW_ID	String	False	The wokflow the action is linked to
ModifiedById	String	True	The Id of the user who last modified the record.
ModifiedByName	String	True	The name of the user who last modified the record.
Name	String	False	Name assigned to the action
Parameters	String	False	List of parameters for the action

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
Rows@Next	String	Identifier for the next page of results. Do not set this value manually.