Hello
I'm running AwareIM 2.2 on Linux using MySQL 5.0.24a.
Everytime I try to search/filter for values containing special characters like äöü (which are quite common in german) AwareIM drops an error.
When doing this via Standard/Search Object/All Objects [BO-Name] / Reduce-Extend Search then I see a Internal System Error and the output from Tomcat is
Filter query is null|null|False|FIND Kunde WHERE Kunde.Firma CONTAINS 'jörg'|10,PLZnyny,KdNrnyny,Firmanyny,Bemerkungnyny,Ortnyny,KHKIDnyny,Landnyny,Anschriftnyny,MatchCodenyny,FirmaZusatznyny,-1,null,1,Editnullnull5false1nullnulltruetrue,null,null,y,y,y|null|null
Redirecting to /runQuery.do?actionMethod=redisplayForm&rangeFormInfo=1%4020%40null%7Cnull%7CFalse%7CFIND+Kunde+WHERE+Kunde.Firma+CONTAINS+%27j%C3%B6rg%27%7C10%2CPLZ%5En%5Ey%5En%5Ey%2CKdNr%5En%5Ey%5En%5Ey%2CFirma%5En%5Ey%5En%5Ey%2CBemerkung%5En%5Ey%5En%5Ey%2COrt%5En%5Ey%5En%5Ey%2CKHKID%5En%5Ey%5En%5Ey%2CLand%5En%5Ey%5En%5Ey%2CAnschrift%5En%5Ey%5En%5Ey%2CMatchCode%5En%5Ey%5En%5Ey%2CFirmaZusatz%5En%5Ey%5En%5Ey%2C-1%2Cnull%2C1%2CEdit%7Enull%7Enull%7E5%7Efalse%7E1%7Enull%7Enull%7Etrue%7Etrue%2Cnull%2Cnull%2Cy%2Cy%2Cy%7Cnull%7Cnull%402%40True%40False%40False%40null%40null%403014%40null%400%400&actionCallStack=&processFrame=-1[null[null[0
ActionErrorException thrown with error key error.assertion
When doing this via a query with "[x] Use Form" then I get a A query with this name does not exist.
In this case Tomcat says:
Query is null|null|False|FIND Kunde WHERE Kunde.MatchCode CONTAINS 'jörg' ORDER BY Kunde.MatchCode|6,MatchCodenyny,Firmanyny,FirmaZusatznyny,Anschriftnyny,PLZnyny,Ortnyny,20,null,2,EditnullMain5false1nullnulltruetrue,Neue BestellungNeueBestellungKunde0false1nullnulltruetrue,null,null,y,y,y|null|null
ActionErrorException thrown with error key error.noquery
Please help ! This error is here since AwareIM 2.0 and very annoying when searching inside 15000 records.
Hubertus