Class ListTableRows.CustomSearch
Class representing a custom search against table 'Category'.
Inheritance
Inherited Members
Namespace: SuperOffice.CRM.Lists
Assembly: SoDataBase.dll
Syntax
public sealed class CustomSearch : ListTableRows.TableRowsIdx, ICloneable, ISentryIgnorableConstructors
CustomSearch(TableInfo)
Constructor for class TableRows.CustomSearch. This class represents a custom search against table defined with tableInfo
Declaration
public CustomSearch(TableInfo tableInfo)Parameters
| Type | Name | Description |
|---|---|---|
| TableInfo | tableInfo | TableInfo to create a custom search against |
Remarks
By adding restrictions and order by information,
a custom query can be formatted against the database.
If this is not added, all the rows in the
table are returned.
Properties
InnerJoinRestriction
Implementation of the join-restriction.
Declaration
protected override JoinRestriction InnerJoinRestriction { get; }Property Value
| Type | Description |
|---|---|
| JoinRestriction |
Overrides
InnerOrderBy
Implementation of the OrderBy clause.
Declaration
protected override OrderBy InnerOrderBy { get; }Property Value
| Type | Description |
|---|---|
| OrderBy |
Overrides
InnerRestriction
Restriction (e.g. sql: WHERE) for the select statement.
Declaration
protected override Restriction InnerRestriction { get; }Property Value
| Type | Description |
|---|---|
| Restriction | RestrictionObject holding the restrictions for the select statement. |
Overrides
JoinRestriction
Joinrestriction for the select-statement.
Declaration
public JoinRestriction JoinRestriction { get; }Property Value
| Type | Description |
|---|---|
| JoinRestriction |
OrderBy
Implementation of the OrderBy clause.
Declaration
public OrderBy OrderBy { get; }Property Value
| Type | Description |
|---|---|
| OrderBy |
Restriction
Restriction (e.g. sql: WHERE) for the select statement.
Declaration
public Restriction Restriction { get; set; }Property Value
| Type | Description |
|---|---|
| Restriction | RestrictionObject holding the restrictions for the select statement. |
TableInfo
Get the TableInfo for the custom search.
Declaration
public TableInfo TableInfo { get; }Property Value
| Type | Description |
|---|---|
| TableInfo | Instance of TableInfo |
Methods
RestrictionAnd(Restriction)
Add a restriction to the current one, using the And binding. If there is no current restriction, the incoming one becomes the current restriction.
Declaration
public void RestrictionAnd(Restriction newRestriction)Parameters
| Type | Name | Description |
|---|---|---|
| Restriction | newRestriction | Restriction to add |
RestrictionOr(Restriction)
Add a restriction to the current one, using the Or binding. If there is no current restriction, the incoming one becomes the current restriction.
Declaration
public void RestrictionOr(Restriction newRestriction)Parameters
| Type | Name | Description |
|---|---|---|
| Restriction | newRestriction | Restriction to add |
UpdateRow(TableRowBase)
Update the TableRow with the values from the index.
Declaration
public override void UpdateRow(TableRowBase row)Parameters
| Type | Name | Description |
|---|---|---|
| TableRowBase | row | The row to update. This must be an instance of TableRow. |
Overrides
Remarks
This method does nothing for a the CustomSearch class.