Class

Create, delete, and query Reckon Classes.

Table Specific Information

Select

The following filters support server-side execution. Other filters are executed client-side.

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.