SSIS Components for Reckon

Build 24.0.9060

Class

Create, delete, and query Reckon Classes.

Table Specific Information

Select

By default, SupportEnhancedSQL is set to true, and the following will be honored if present. Other filters will be executed client side. If SupportEnhancedSQL is set to false, only the following filters will be honored.

Reckon allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can typically be used with only the equals or = comparison. The available columns for the Class table are Id, Name, and IsActive. Name may be used with the = or LIKE conditions to establish a starts-with, ends-with, or contains syntax.

Insert

To insert a Class, specify the Name field.

Columns

Name Type ReadOnly References Description
ID [KEY] String True

The unique identifier of the class.

Name String False

The name of the class.

FullName String True

The full name of the class in the form ParentName|ClassName.

IsActive Boolean False

Boolean determining if the class is active.

ParentRef_FullName String False

Class.FullName

Full name of the parent for the class. You may specify only ParentRef_FullName or ParentRef_ListId on INSERT/UPDATE statements and not both.

ParentRef_ListId String False

Class.ID

Id for the parent of the class. You may specify only ParentRef_FullName or ParentRef_ListId on INSERT/UPDATE statements and not both.

Sublevel Integer True

How many parents the class has.

EditSequence String True

A string indicating the revision of the class.

TimeCreated Datetime True

The time the class was created.

TimeModified Datetime True

The last time the class was modified.

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
StartModifiedDate String

This pseudo column is deprecated and should no longer be used. Earliest modified date to search for (in yyyy-MM-dd, MM-dd-yy, MM-dd-yyyy, MM/dd/yy, or MM/dd/yyyy format)

EndModifiedDate String

This pseudo column is deprecated and should no longer be used. Latest modified date to search for (in yyyy-MM-dd, MM-dd-yy, MM-dd-yyyy, MM/dd/yy, or MM/dd/yyyy format).

NameMatch String

This pseudo column is deprecated and should no longer be used. The type of match to use if specifying the name.

The allowed values are CONTAINS, EXACT, STARTSWITH, ENDSWITH.

ActiveStatus String

This pseudo column is deprecated and should no longer be used. Limits the search to active or inactive records only or all records.

The allowed values are ACTIVE, INACTIVE, ALL, NA.

The default value is ALL.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060