SqlQuery.FullTextSearchJoin method
namespace: Serenity.Data assembly: Serenity.Net.Data
Creates the required join for full text search in MSSQL.
public SqlQuery FullTextSearchJoin(string searchTable, string searchFields, string searchQuery,
string searchTableAlias, string searchTableKey, string containsAlias)
| parameter | description |
|---|---|
| searchTable | Table name containing the fields to be searched (required). |
| searchFields | Fields to be searched (required). |
| searchQuery | Searched word or phrase (required). Words must be separated by comma. |
| searchTableAlias | Alias assigned to the table to be searched in the FROM part of the query (required, e.g. T0). |
| searchTableKey | Key (ID) field of the table to be searched (required). |
| containsAlias | Alias to be assigned to the joined contains table (required, e.g. CT). |
Return Value
The SqlSelect object itself.
See Also
- class SqlQuery