ArxFullTextSearch class · DynamoDB in C#

Definition

Namespace: ARX.SDK.Models
Package: ARX.SDK

public class ArxFullTextSearch

A full-text search, given as a condition's value: query.Criteria.AddCondition("body", ArxConditionOperator.Equal, new ArxFullTextSearch("quick fox")). Each database runs its own full-text search: PostgreSQL to_tsvector('english', column) @@ websearch_to_tsquery('english', text) (English stemming and stop words); SQL Server FREETEXT and MySQL MATCH … AGAINST in natural language mode, which need a full-text index on the column (ARX8001 without one); MongoDB $text, which searches the collection's text index whatever field the condition names. DynamoDB has none (ARX8001); ArxCapability.FullTextSearch says which providers do.

Constructor

ArxFullTextSearch(string searchText)
A full-text search for searchText.
Parameter Type Description
searchText string The words to search for, as the database's full-text search reads them.

Parameter	Type	Description
`searchText`	`string`	The words to search for, as the database's full-text search reads them.

Properties

string SearchText { get; set; }
The words to search for. Empty or whitespace is ARX1001.

Notes

The operator is Equal or Contains (and Like on the SQL providers): all mean "matches the search". The text is a parameter, never part of the statement. The matching rules (stemming, stop words, ranking, the minimum word length) are the database's, so the same search can find different rows on each provider.