JDBC Driver for SuiteCRM

Build 22.0.8462

WorkFlow

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

Table Specific Information

Select

You can query the Workflow table using any criteria in the WHERE clause. The driver will use the SuiteCRM API to filter the results.

SELECT * FROM Workflow WHERE Name='test'

Insert

Create a Workflow by specifying any writable column.

INSERT INTO Workflow (Id, Name) VALUES ('id', 'Energy')

Update

You can update any Workflow column that is writable, by specifying the Id.

UPDATE Workflow SET Name='new name' , Description='Desc' WHERE Id = 'Test123' 

Delete

Remove a Workflow by specifying the Id.

DELETE FROM Workflow WHERE Id = 10003

Columns

Name Type ReadOnly Description
Id [KEY] String False

The unique identifier of the inbound.

Name String False

Name assigned to the workflow

DateEntered Datetime False

The date the record was created.

DateModified Datetime False

The date the record was last modified.

ModifiedUserId String False

The Id of the user who last modified the record.

ModifiedByName String True

The name of the user who last modified the record.

CreatedBy String False

The Id of the user who created the record.

CreatedByName String True

The name of the user who created the record.

Description String False

Description for the worflow

Deleted Bool False

The record deletion indicator.

CreatedByLink String True

Link to the record who created it

ModifiedUserLink String True

Link to the record who modified it.

AssignedUserId String False

The Id of the user assigned to the record.

AssignedUserName String True

AssignedUserLink String True

Link to the user which the record has been assigned to

SecurityGroups String True

The security group associated with the record.

FlowModule String False

FlowRunOn String False

Status String False

The status of the record.

RunWhen String False

MultipleRuns Bool False

ConditionLines String False

ActionLines String False

AowConditions String True

AowActions String True

AowProcessed String True

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462