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. |