Case Sensitive Query api

---

@BrianKrieger wrote:

Hey, gurus!

 

I feel like I have been able to look this up before....

Can a QuerySpec be case insensitive?  E.g.

 

qs = new QuerySpec(WTGroup.class);

qs.appendWhere(new SearchCondition(WTGroup.class, WTGroup.NAME, SearchCondition.LIKE, "%"+searchValue), new int[]{0});

 

Would like to find

myString

by using "string" or "String" or "STRING" for searchValue above.

 

I am so sure I've read this somewhere........

 

Looked through the manuals, will go through again.....

---

Take a look at this:

https://www.ptc.com/en/support/article?n=CS189245

Change your:

qs.appendWhere(new SearchCondition(WTGroup.class, WTGroup.NAME, SearchCondition.LIKE, "%"+searchValue), new int[]{0});

to this:

qs.appendWhere(new SearchCondition(WTGroup.class, WTGroup.NAME, SearchCondition.LIKE, "%"+searchValue, false), new int[]{0});