SSIS Components for SuiteCRM

Build 22.0.8509

ReportConditions

Create, update, delete, and query report conditions.

Table Specific Information

Select

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

SELECT * FROM [Report Conditions] WHERE [Logic] = 'Less than'

Insert

Create a Report Condition entry by specifying any writable column.

INSERT INTO [Report Conditions] (Name,Logic,Operator,Value,[Report Id]) VALUES ('Comparison','Greater Than','>',410,'reportIdR2')

Update

You can update any Report Condition entry column that is writable, by specifying the Id.

UPDATE [Report Conditions] SET Order = 1 WHERE Id = 'Test123' 

Delete

Remove a Report Condition entry by specifying the Id.

DELETE FROM [Report Conditions] WHERE Id = 10003

Columns

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 report condition

Field String False

Module field to select for the condition

LBL_PARENTHESIS String False

The id of the report condition to enclose in the parenthesis

Logic String False

The logic operator to link to the next condition

The allowed values are AND, OR.

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.

Module String False

Which module to query in the condition

Name String False

Name assigned to the condition

Operator String False

The operator to test against the value, such as 'Equal to', 'Less than'

Order Int False

Defines the order in which the condition will be resolved

Parameter Bool False

Whether to treat the condition as a parameter

ReportId String False

The report Id that the condition will apply to

Type String False

What type of value to compare against

Value String False

Value to use for comparison

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Rows@Next String

Identifier for the next page of results. Do not set this value manually.

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