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