case insensitive search with string.Contains()

[nikotanghe]

We're trying to perform a partial, case-insensitive search on a string property in our Gremlin query.
By default, the .Contains() method is case-sensitive, which doesn't meet our needs.

g.V().Where(s => s.Name.Contains(request.Name));

This works, but only for exact case matches.

We came across TextP.Containing, which seems promising for this use case,
but it's not entirely clear how to apply it for case-insensitive matching.

Has anyone implemented this successfully?
Any guidance or examples would be appreciated!

[danielcweber]

It is possible to use StringComparison.OrdinalIgnoreCase in the query as seen here which may translate to a regex(...) predicate if supported by the provider (given the correct provider packages is used). If it's not (which is definitely the case on CosmosDb), Gremlinq will silently fall back to case-sensitivity (the silent fallback can be configured by the StringComparisonTranslationStrictness option.

Hope it helps.

[nikotanghe]

Thank you for your answer @danielcweber

using the contains method with option StringComparison

.Where(s => s.Name.Contains(request.Name, StringComparison.OrdinalIgnoreCase))

throws ExpressionNotSupportedException (

ExRam.Gremlinq/src/Core/Queries/GremlinQuery.cs

Line 1628 in eb1cce0

throw new ExpressionNotSupportedException();

)

The option StringComparisonTranslationStrictness is set to strict.

We use the lastest gremlinq 12.23.0 package with an azure Cosmos DB

[danielcweber]

Last time I looked there was no support for case insensitive lookups on CosmosDb and I assume things haven't changed.

[nikotanghe]

@danielcweber
They have added support for text case-insentitive search methods
https://devblogs.microsoft.com/cosmosdb/new-string-function-performance-improvements-and-case-insensitive-search/
CONTAINS -> https://docs.azure.cn/en-us/cosmos-db/nosql/query/contains

On my azure cosmos DB data explorer, this query works :

SELECT * FROM c
where CONTAINS(c.label, 'some text', true)

[danielcweber]

If you can find a query for the CosmosDb Gremlin API that does the same, we got a feature. I'm not too optimistic about it though, but you can try.