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 Accounts Hosted 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

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