ProcessAudit

Create, update, delete, and query information on process audits

テーブル固有の情報

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

SELECT * FROM [Process Audit] WHERE Module = 'Opportunities'

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

INSERT INTO [Process Audit] (Name, Record, Module) VALUES ('Final Audit', 'recordId', 'Leads')

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

UPDATE [Process Audit] SET Status = 'Completed' WHERE Id = 'Test123'

Id を指定して、Process Audit を削除します。

DELETE FROM [Process Audit] WHERE Id = '10003'


Name	Type	ReadOnly	Description
ID [KEY]	String	False	The unique identifier of the inbound.
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 process audit
LBL_AOW_WORKFLOW_ID	String	False	Id of the workflow the audit is following
Workflow	String	True	Name of the workflow the audit is following
LBL_BEAN_ID	String	False	The Id of the audit's parent record
Record	String	True	Name of the audit's parent record
ParentType	String	False	Module the audit's parent belongs 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 process audit
Status	String	False	Status of the audit

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


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