I am new to QuerySpec and SearchCondition. I have an SQL query that uses the LOWER() operator. Is it possible to use that operator in the wt.query.SearchCondition?
I have an array of usernames, but they are all in lowercase. I wish to query the database with the usernames, but in the database, they are stored as mixed case. Thus sometimes I don't get a result.
select name,email from wtuser where lower(name) in ('ben.perry','otheruser1','otheruser2')
(this is a portion of the code in a FOR loop):
<the other users aren't found because userArray contains only lowercase characters>
Go to Solution.
I opened a ticket and Mayur @ PTC helped with this.
From JavaDoc:public SearchCondition(Class targetClass,String anAttribute,String value,boolean caseSensitive) throws QueryException
Therefore, add the false argument to the method at the end.
Upcoming October 2019 Regional User Groups