ArangoDB v3.8 reached End of Life (EOL) and is no longer supported.
This documentation is outdated. Please see the most recent version at docs.arangodb.com
Case-insensitive Search with ArangoSearch
You can normalize values for case-insensitive matching and to ignore diacritics, also in combination with other search techniques
Normalizing a Single Token
Dataset: IMDB movie dataset
Custom Analyzer:
Create a norm
Analyzer in arangosh to normalize case to all lowercase and to
remove diacritics:
//db._useDatabase("your_database"); // Analyzer will be created in current database
var analyzers = require("@arangodb/analyzers");
analyzers.save("norm_en", "norm", { locale: "en.utf-8", accent: false, case: "lower" }, ["frequency", "norm", "position"]);
View definition:
{
"links": {
"imdb_vertices": {
"fields": {
"title": {
"analyzers": [
"norm_en"
]
}
}
}
}
}
AQL queries:
Match movie title, ignoring capitalization and using the base characters instead of accented characters (full string):
FOR doc IN imdb
SEARCH ANALYZER(doc.title == TOKENS("thé mäTRïX", "norm_en")[0], "norm_en")
RETURN doc.title
Result |
---|
The Matrix |
Match a title prefix (case-insensitive):
FOR doc IN imdb
SEARCH ANALYZER(STARTS_WITH(doc.title, "the matr"), "norm_en")
RETURN doc.title
Result |
---|
The Matrix Revisited |
The Matrix |
The Matrix Reloaded |
The Matrix Revolutions |
The Matrix Trilogy |