Name |
Description |
int? Id |
Record ID. |
List Ids |
List of enabled record ID. |
int? IdMin |
Min. record ID (including). |
int? IdMax |
Max. record ID (including). |
int? ArchiveId |
Archived record Id. |
int ParentId |
Id of the class or query from which we want to read the records. |
ClassDefEntityType ParentColumnType |
Type defining, if ParentId is class or query. |
bool Filter_BindOnlyShortDescription |
Indication for fast reading from the database. If you read record with links to reference tables and you need to read only Id and ShortDescription, than enter True. This setting causes that the referred entity will not be read with all the columns, which makes returning results faster. |
bool Filter_Archive |
Indication, wheather archive records shall be read. It is not possible to combine reading from operational and archive table in one object call. |
object GetColumnData(int columnId) |
Function returns value for input column ID. If nothing is input, NULL is returned. |
object GetColumnData(string columnCode) |
Function returns value for input column column. If nothing is input, NULL is returned. |
void SetColumnData(int columnId, object data) |
This method sets the condition for a particular column. Specify the value data in the correct data type in relation to the class type. |
void SetColumnData(string columnCode, object data) |
Method sets a condition for a particular column. Define the value data in the correct data type (according to the column type). Enter the code in form 'code' or 'parent_code.column_code' for columns from the parent class. |
object this[int columnId] |
Function sets or returns value for the defined column. |
object this[string columnCode] |
Function sets or returns value for the defined column. |
bool Filter_LoadFiles |
Indication, wheather information about column of the type File shall be read. If your class or query contains this column type but you do not need to read this information, than set False. |
ConditionBase Condition |
Property for a more complex definition of conditions for search. |
string Filter_Sort |
Specification of sorting of the returned records. |
int? Filter_StartRowIndex |
Order value of the first returned record. All the records are numbered and by this property you can set, which record will be returned as the first one. All the previous records will be removed from the result. |
int? Filter_MaximumRows |
Max. number of returned record. You can use this property together with Filter_StartRowIndex to page the records. |
bool Filter_OnlyActive |
Indication, wheather only records, that are active (not deleted), shall be returned. Column Deleted is null for active records. |
bool Filter_LoadSubEntity |
Indication, wheather also "subentities" shall be returned. Subentities are reference columns with M:N relation. To return the data faster you do not need to read these columns. However, if you need these columns set this property to True. |
bool WriteSqlToLog |
Indication, wheather the resulting SQL command shall be written into the error log. |
void AddAndCon(ConditionBase c) |
Method adds another condition to a condition and associates that with operator AND. |
void AddAndCon(ConditionBase c, bool addEnvelope) |
Method adds another condition to a condition and associates that with operator AND. If set to TRUE, parameter addEnvelope encloses conditions with a bracket. |
void AddAndCon(ConditionBase c1, ConditionBase c2, bool addEnvelope) |
Method adds another condition to a condition and associates that with operator AND. If set to TRUE, parameter addEnvelope encloses conditions with a bracket. |
void AddAndCon(ConditionBase c1, ConditionBase c2, ConditionBase c3, bool addEnvelope) |
Method adds another condition to a condition and associates that with operator AND. If set to TRUE, parameter addEnvelope encloses conditions with a bracket. |
void AddAndCon(ConditionBase c1, ConditionBase c2, ConditionBase c3, ConditionBase c4, bool addEnvelope) |
Method adds another condition to a condition and associates that with operator AND. If set to TRUE, parameter addEnvelope encloses conditions with a bracket. |
void AddOrCon(ConditionBase c) |
Method adds another condition to a condition and associates that with operator OR. If set to TRUE, parameter addEnvelope encloses conditions with a bracket. |
void AddOrCon(ConditionBase c, bool addEnvelope) |
Method adds another condition to a condition and associates that with operator OR. If set to TRUE, parameter addEnvelope encloses conditions with a bracket |
void AddOrCon(ConditionBase c1, ConditionBase c2, bool addEnvelope) |
Method adds another condition to a condition and associates that with operator OR. If set to TRUE, parameter addEnvelope encloses conditions with a bracket |
void AddOrCon(ConditionBase c1, ConditionBase c2, ConditionBase c3, bool addEnvelope) |
Method adds another condition to a condition and associates that with operator OR. If set to TRUE, parameter addEnvelope encloses conditions with a bracket |
void AddOrCon(ConditionBase c1, ConditionBase c2, ConditionBase c3, ConditionBase c4, bool addEnvelope) |
Method adds another condition to a condition and associates that with operator OR. If set to TRUE, parameter addEnvelope encloses conditions with a bracket |