dexie
Is it possible to do a Case Insensitve .between()?
Functionally, I'm trying to execute:
.where([id,lastName])
.startsWithIgnoreCase(value)
However, startsWithIgnoreCase works on strings, not on composite keys. I understood that .startsWith is syntactic suger for:
.where([id,lastName])
.between([5,'smith'],[5,'smith\uffff'])
Is it possible to do something similar, but while ignoring the case?
("id" is a kind of partitioning on the table)
Related to #544
Please explain... :)
Sorry, hit some key by accident, and submitted before finishing the post... 2 minutes please ;-)
I still think it's a valid question, but as a solution I opted to simply convert my search attributes to lowercase, as this also improves read performance (reference: #1203). I'll leave this "issue" open, as this is not really an answer to the original question.