The SearchSQL type exposes the following members.
Methods
Type | Name | Description |
---|---|---|
![]() | Equals | Determines whether the specified Object is equal to the current Object. (Inherited from Object.) |
![]() | Finalize | Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection. (Inherited from Object.) |
![]() | GetHashCode | Serves as a hash function for a particular type. GetHashCode()()() is suitable for use in hashing algorithms and data structures like a hash table. (Inherited from Object.) |
![]() | GetType | Gets the Type of the current instance. (Inherited from Object.) |
![]() | MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
![]() | SetAll |
Specifies that duplicate rows can be returned in the result set.
|
![]() | SetContainsRestriction |
Restricts the query to return only items where the text in the content element
or elements matches the specified String. This method uses the CONTAINS
function for CBR (Content-Based Retrieval) queries.
The CONTAINS function can perform the search on CBR-enabled properties for the supported content elements in any of the following ways:
|
![]() | SetDistinct |
Restricts the query to return only distinct rows. This setting is valid only
when all properties in the select list are orderable (as specified in the
ORDER BY clause).
|
![]() | SetFolderRestriction |
Restricts the query to return only items from the specified class within
the specified folder.
|
![]() | SetFreetextRestriction | Obsolete.
Restricts the query to return only items where the text in the content elements
matches the specified String. This method uses the FREETEXT function
for CBR (Content-Based Retrieval) queries.
The FREETEXT function searches all content on all CBR-enabled properties on the supported content elements. To search content on a single CBR-enabled property, use SetContainsRestriction. |
![]() | SetFromClauseAdditionalJoin |
Adds another class to the FROM clause used in the SQL statement.
|
![]() | SetFromClauseInitialValue |
Sets the first class to be used in the FROM clause for the statement.
|
![]() | SetMaxRecords |
Sets the maximum number of rows that can be returned in the result set. When unspecified,
all records that satisfy the query will be returned, subject to the limit of the
IServerCacheConfiguration property NonPagedQueryMaxSize.
|
![]() | SetOrderByClause |
Sets the ORDER BY clause to be used for the SQL statement to the
specified String.
|
![]() | SetQueryString |
Specifies the entire SQL statement. This method cannot be used in conjunction with
any of the other Set methods on this class. Doing so will have the following
effect:
No SQL validation is performed on the specified string. |
![]() | SetSelectList |
Sets the SELECT list for SQL statement to the specified String.
This must be called prior to calling SetFromClauseAdditionalJoin.
|
![]() | SetTimeLimit |
Sets the maximum duration the query runs on the server, in seconds. When unspecified,
the value of the ObjectStore property DefaultQueryTimeLimit is used.
Warning: Date/Time values in queries are evaluated with respect to the Content Engine server clock. If the client and server clocks are not in sync, be careful when translating relative time concepts into absolute times. For example, specifying a value that means "within the last 5 minutes" on the client will translate to a comparison to an absolute time in the SQL query, which may not mean "within the last 5 minutes" relative to the server clock. |
![]() | SetWhereClause |
Sets the WHERE clause to be used for SQL statement to the specified String.
|
![]() | ToString |
Returns either the SQL statement constructed using the helper methods (in this case,
SetFromClauseInitialValue must have been called prior to this method), or
the SQL statement specified in its entirety using either SetQueryString
or the SearchSQL(String) constructor.
(Overrides Object..::.ToString()()().) |