Hi I want FTS search with case insensitive.
Example: Forewood Vs FIREWOOD
i found a match for FIREWOOD but no match found for Firewood
Note: if there is no FTS case insensitive support then is there any way i can achive this? In my document we have stored everything in CAPITAL LETTERS
hi @kumas16,
Without the index definition and the query tried, its difficult to say whats going on in your case.
The default standard analyser would have lower cased your field contents and query would also go through the same analyser if you had tried a field scoped query.
Please read a bit about the index creation and analysers here:
ref: Create a Search Index | Couchbase Docs
ref: https://docs.couchbase.com/server/current/fts/fts-using-analyzers.html#pre-constructed-analyzers
@sreeks,
In document i have stored every field in capital case. i want to search even if the input is in small case, i am not sure is there any analyzer that can do this task or any regex to allow case insensitive search.
Here is my index defination 
{
“name”: “US_Postal_Index”,
“type”: “fulltext-index”,
“params”: {
“doc_config”: {
“docid_prefix_delim”: “”,
“docid_regexp”: “”,
“mode”: “type_field”,
“type_field”: “docType”
},
“mapping”: {
“default_analyzer”: “keyword”,
“default_datetime_parser”: “dateTimeOptional”,
“default_field”: “_all”,
“default_mapping”: {
“dynamic”: true,
“enabled”: false
},
“default_type”: “_default”,
“docvalues_dynamic”: true,
“index_dynamic”: true,
“store_dynamic”: false,
“type_field”: “_type”,
“types”: {
“”: {
“dynamic”: true,
“enabled”: false
},
“US_Postal”: {
“default_analyzer”: “keyword”,
“dynamic”: false,
“enabled”: true,
“properties”: {
“adP2DNa”: {
“enabled”: true,
“dynamic”: false,
“fields”: [
{
“include_in_all”: true,
“include_term_vectors”: true,
“index”: true,
“name”: “adP2DNa”,
“store”: true,
“type”: “text”
}
]
},
“adPriOddEvnCd”: {
“enabled”: true,
“dynamic”: false,
“fields”: [
{
“include_in_all”: true,
“include_term_vectors”: true,
“index”: true,
“name”: “adPriOddEvnCd”,
“store”: true,
“type”: “text”
}
]
},
“adPriPslCd”: {
“enabled”: true,
“dynamic”: false,
“fields”: [
{
“include_in_all”: true,
“include_term_vectors”: true,
“index”: true,
“name”: “adPriPslCd”,
“store”: true,
“type”: “text”
}
]
},
“adSecOddEvnCd”: {
“enabled”: true,
“dynamic”: false,
“fields”: [
{
“include_in_all”: true,
“include_term_vectors”: true,
“index”: true,
“name”: “adSecOddEvnCd”,
“store”: true,
“type”: “text”
}
]
},
“adSecUntTe”: {
“enabled”: true,
“dynamic”: false,
“fields”: [
{
“include_in_all”: true,
“include_term_vectors”: true,
“index”: true,
“name”: “adSecUntTe”,
“store”: true,
“type”: “text”
}
]
},
“adStrNa”: {
“enabled”: true,
“dynamic”: false,
“fields”: [
{
“analyzer”: “keyword”,
“include_in_all”: true,
“include_term_vectors”: true,
“index”: true,
“name”: “adStrNa”,
“store”: true,
“type”: “text”
}
]
},
“adStrRngHiNr”: {
“enabled”: true,
“dynamic”: false,
“fields”: [
{
“include_in_all”: true,
“include_term_vectors”: true,
“index”: true,
“name”: “adStrRngHiNr”,
“store”: true,
“type”: “text”
}
]
},
“adStrRngLowNr”: {
“enabled”: true,
“dynamic”: false,
“fields”: [
{
“include_in_all”: true,
“include_term_vectors”: true,
“index”: true,
“name”: “adStrRngLowNr”,
“store”: true,
“type”: “text”
}
]
},
“adStrTypCd”: {
“enabled”: true,
“dynamic”: false,
“fields”: [
{
“include_in_all”: true,
“include_term_vectors”: true,
“index”: true,
“name”: “adStrTypCd”,
“store”: true,
“type”: “text”
}
]
},
“aladStrNa”: {
“enabled”: true,
“dynamic”: false,
“fields”: [
{
“analyzer”: “keyword”,
“include_in_all”: true,
“include_term_vectors”: true,
“index”: true,
“name”: “aladStrNa”,
“store”: true,
“type”: “text”
}
]
},
“p1DNa”: {
“enabled”: true,
“dynamic”: false,
“fields”: [
{
“include_in_all”: true,
“include_term_vectors”: true,
“index”: true,
“name”: “p1DNa”,
“store”: true,
“type”: “text”
}
]
},
“secAdRngHiNr”: {
“enabled”: true,
“dynamic”: false,
“fields”: [
{
“include_in_all”: true,
“include_term_vectors”: true,
“index”: true,
“name”: “secAdRngHiNr”,
“store”: true,
“type”: “text”
}
]
},
“secAdRngLowNr”: {
“enabled”: true,
“dynamic”: false,
“fields”: [
{
“include_in_all”: true,
“include_term_vectors”: true,
“index”: true,
“name”: “secAdRngLowNr”,
“store”: true,
“type”: “text”
}
]
},
“strPfxNa”: {
“enabled”: true,
“dynamic”: false,
“fields”: [
{
“include_in_all”: true,
“include_term_vectors”: true,
“index”: true,
“name”: “strPfxNa”,
“store”: true,
“type”: “text”
}
]
},
“strSufNa”: {
“enabled”: true,
“dynamic”: false,
“fields”: [
{
“include_in_all”: true,
“include_term_vectors”: true,
“index”: true,
“name”: “strSufNa”,
“store”: true,
“type”: “text”
}
]
}
}
}
}
},
“store”: {
“indexType”: “scorch”,
“kvStoreName”: “”
}
},
“sourceType”: “couchbase”,
“sourceName”: “B234AMS”,
“sourceUUID”: “73d6e5981c29686c67db14cfe64dfe4f”,
“sourceParams”: {},
“planParams”: {
“maxPartitionsPerPIndex”: 171,
“numReplicas”: 0
},
“uuid”: “7df8c599099fc9b1”
}
Hi @kumas16,
You are using the keyword analyser and hence the content of the field is preserved as it is. So when you have CAPITALISED texts in document, it will be preserved as that is in the index as well. So only exact CAPITALISED query text will work.
Was here a reason for you to choose the keyword analyser here?
If you wish preserve the whole field contents as it is, and enable the lower case searching you may try the attached index definition.
Note: Please do refer the analyser links shared earlier, without certain minimum prerequisite knowledge it would be difficult to deal with search as you progress further.
"type": "fulltext-index",
"name": "FTS",
"uuid": "35995023efc6ac9f",
"sourceType": "couchbase",
"sourceName": "sample",
"sourceUUID": "9285e7368ecee856522b89876b08f9e0",
"planParams": {
"maxPartitionsPerPIndex": 171,
"indexPartitions": 6
},
"params": {
"doc_config": {
"docid_prefix_delim": "",
"docid_regexp": "",
"mode": "type_field",
"type_field": "docType"
},
"mapping": {
"analysis": {
"analyzers": {
"custom": {
"token_filters": [
"to_lower"
],
"tokenizer": "single",
"type": "custom"
}
}
},
"default_analyzer": "keyword",
"default_datetime_parser": "dateTimeOptional",
"default_field": "_all",
"default_mapping": {
"dynamic": true,
"enabled": false
},
"default_type": "_default",
"docvalues_dynamic": true,
"index_dynamic": true,
"store_dynamic": false,
"type_field": "_type",
"types": {
"": {
"dynamic": true,
"enabled": false
},
"US_Postal": {
"default_analyzer": "custom",
"dynamic": false,
"enabled": true,
"properties": {
"adP2DNa": {
"dynamic": false,
"enabled": true,
"fields": [
{
"include_in_all": true,
"include_term_vectors": true,
"index": true,
"name": "adP2DNa",
"store": true,
"type": "text"
}
]
},
"adPriOddEvnCd": {
"dynamic": false,
"enabled": true,
"fields": [
{
"include_in_all": true,
"include_term_vectors": true,
"index": true,
"name": "adPriOddEvnCd",
"store": true,
"type": "text"
}
]
},
"adPriPslCd": {
"dynamic": false,
"enabled": true,
"fields": [
{
"include_in_all": true,
"include_term_vectors": true,
"index": true,
"name": "adPriPslCd",
"store": true,
"type": "text"
}
]
},
"adSecOddEvnCd": {
"dynamic": false,
"enabled": true,
"fields": [
{
"include_in_all": true,
"include_term_vectors": true,
"index": true,
"name": "adSecOddEvnCd",
"store": true,
"type": "text"
}
]
},
"adSecUntTe": {
"dynamic": false,
"enabled": true,
"fields": [
{
"include_in_all": true,
"include_term_vectors": true,
"index": true,
"name": "adSecUntTe",
"store": true,
"type": "text"
}
]
},
"adStrNa": {
"dynamic": false,
"enabled": true,
"fields": [
{
"analyzer": "keyword",
"include_in_all": true,
"include_term_vectors": true,
"index": true,
"name": "adStrNa",
"store": true,
"type": "text"
}
]
},
"adStrRngHiNr": {
"dynamic": false,
"enabled": true,
"fields": [
{
"include_in_all": true,
"include_term_vectors": true,
"index": true,
"name": "adStrRngHiNr",
"store": true,
"type": "text"
}
]
},
"adStrRngLowNr": {
"dynamic": false,
"enabled": true,
"fields": [
{
"include_in_all": true,
"include_term_vectors": true,
"index": true,
"name": "adStrRngLowNr",
"store": true,
"type": "text"
}
]
},
"adStrTypCd": {
"dynamic": false,
"enabled": true,
"fields": [
{
"include_in_all": true,
"include_term_vectors": true,
"index": true,
"name": "adStrTypCd",
"store": true,
"type": "text"
}
]
},
"aladStrNa": {
"dynamic": false,
"enabled": true,
"fields": [
{
"analyzer": "keyword",
"include_in_all": true,
"include_term_vectors": true,
"index": true,
"name": "aladStrNa",
"store": true,
"type": "text"
}
]
},
"p1DNa": {
"dynamic": false,
"enabled": true,
"fields": [
{
"include_in_all": true,
"include_term_vectors": true,
"index": true,
"name": "p1DNa",
"store": true,
"type": "text"
}
]
},
"secAdRngHiNr": {
"dynamic": false,
"enabled": true,
"fields": [
{
"include_in_all": true,
"include_term_vectors": true,
"index": true,
"name": "secAdRngHiNr",
"store": true,
"type": "text"
}
]
},
"secAdRngLowNr": {
"dynamic": false,
"enabled": true,
"fields": [
{
"include_in_all": true,
"include_term_vectors": true,
"index": true,
"name": "secAdRngLowNr",
"store": true,
"type": "text"
}
]
},
"strPfxNa": {
"dynamic": false,
"enabled": true,
"fields": [
{
"include_in_all": true,
"include_term_vectors": true,
"index": true,
"name": "strPfxNa",
"store": true,
"type": "text"
}
]
},
"strSufNa": {
"dynamic": false,
"enabled": true,
"fields": [
{
"include_in_all": true,
"include_term_vectors": true,
"index": true,
"name": "strSufNa",
"store": true,
"type": "text"
}
]
}
}
}
}
},
"store": {
"indexType": "scorch"
}
},
"sourceParams": {}
}