Couchbase FTS sorting with keyword analyzer case insensitive

Full Text Search
,
1

I create a FTS in Couchbase 6.5.0
I can sort my query result by the field: name
I create the index with keyword analyzer, but this order is case sensitive, is there any way I can sort it case insensitive?
I tried to create a custom analyzer like this:

image
image1068×802 27.1 KB

But it does not work if I sort by the index filed with this customize analyzer.

This should be easy to config it, but I cannot find it, so crazy!

2

@Fujing ,

The above custom analyzer should work for your case.
Can you please share your sample query, document, and index definition here?

Make sure you are setting the right analyzer in the index definition for the field under focus.

Cheers!

3

Hi
This is the index and analyzer:

image
image1588×370 38.1 KB

image
image1068×802 27.1 KB

4

This looks right, but it’d do good to share your entire index definition in its JSON format.
Would you also share your FTS query along with it.

I see you’re setting the field “Searchable as” - namesortby. Are you using namesortby as the field to search and sort in the query?