Notes Error Query Is Not Understandable
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up “Query is not understandable” - Full text searching where field types have changed up vote 0 down vote favorite A client have a long lived IBM Notes application where someone along the line changed the type of a field from number to text. So, now when we're trying to do an FT search like: [myField] = "1234" receive the error message: "Query is not understandable". If I do: [myField] = 1234 it works but won't return any hits. Even though there's a document where myField = "1234". The field is of type text in the design. I've created a new view for testing, only allowing documents from one form. Deleted the full text index (even on the file system) updall -X Fixup -r Created full text index In my test view I've got one column that shows if the field content being searched is of type text @IsText(myField) and all rows shows: 1 (so it's field content must be text) None of the above worked so I created a new database copy locally. Same problem. Created an entirely new database (for testing only), form, view and full text index and that works. Feels like the existing database design somewhere stores the old field type... Any ideas appreciated. Thanks! /J full-text-search lotus-notes ibm lotus-domino full-text-indexing share|improve this question asked Jun 13 '13 at 12:38 jBoive 339218 add a comment| 2 Answers 2 active oldest votes up vote 4 down vote accepted Datatypes and field names are stored in
in numeric fields QNU; db.ftsearch Technote (FAQ) Question Notes 6.x searches involving negative values in numeric fields return the error: "Query is not understandable". This occurs whether you manually enter in searches, using search builder, or use programmatic searches with, for example, the LotusScript FTSearch method (of the NotesDatabase class). For example, in a database with a numeric field, such as NUM, the following search strings (individually) return the above error: FIELD num = -1 FIELD num < -2 Also, the following http://stackoverflow.com/questions/17087281/query-is-not-understandable-full-text-searching-where-field-types-have-chang search builder entries cause the above error: field NUM is equal to -1 field NUM is greater than -1 If the relevant field is not numeric, the error does not occur. NOTE: With search builder this is not relevant as the numeric operands are not available. Steps to reproduce: 1. Create a form with a numeric field called NUM. 2. http://www-01.ibm.com/support/docview.wss?uid=swg21144490 Create a few documents based on this form, and populate one document with 0 and another with -1. 3. Full text index the database 4. Search on the following: FIELD num = -1. The error is returned. 5. Change the -1 in the search to a positive 1; the search works fine. Answer This issue was reported to Quality Engineering and has been fixed in the Notes client releases 6.0.4 and 6.5.2. Excerpt from the Lotus Notes and Domino Release 6.0.4 / 6.5.2 MR fix list (available at http://www.ibm.com/developerworks/lotus): SPR# MGAN5SZQ98 - Search relative to negative values in numeric fields no longer returns the error "Query is not understandable". This regression was introduced in 6.0. Related information Search Conditions for a Date Field Indicate "Contains" Document information More support for: Lotus End of Support Products Lotus Notes Software version: 6.0, 6.5 Operating system(s): Windows, iOS Reference #: 1144490 Modified date: 12 September 2004 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
LDAP server query element sequence error; http://www.ibm.com/support/docview.wss?uid=swg21243029 query is not understandable; ?; ldap fulltext; fulltext ldap; APAR LO14893; PMR 11497 999 678; searches; search; searching; searched; LDAP server; ldap; full http://www.helpinfo.com/index.jsp?k2dockey=1021024163097333807&formwassubmitted=true text; errors; error Technote (troubleshooting) Problem In Lotus Domino, you issue the following searches on an LDAP server with "full-text" enabled for notes error names.nsf, ldapsearch -s sub "street=How are you??" ldapsearch -s sub "street=?ISO-8859-2?Q?Clue-ObiWan@starwars.com" ldapsearch -s sub "street= ú ?" but receive the following error messages: "Quotation usage error:Query is not understandable." "Query element sequence error: Query is not understandable. " Cause This situation occurs because of notes error query the question mark ("?") in the LDAP search filter. Although "?" is a valid character in a full-text search and represents a substitute for a single character, passing it to the LDAP search filter causes the errors. Resolving the problem This issue was reported to Quality Engineering as SPR# ATHN6QKC33 and does not occur in the Notes/Domino 7.0.2 or 8.0 releases. If you haven't yet updated, do not use "?" in an LDAP search. Document information More support for: Lotus End of Support Products Lotus Domino Software version: 5.0, 6.0, 6.5, 7.0 Operating system(s): AIX, Linux, Solaris, Windows Reference #: 1243029 Modified date: 23 August 2007 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
Visio Microsoft Word Microsoft Works Novell GroupWise WinZip Media Creation and Backup Modems Monitors Mouse and Keyboards Networking Devices Printers Scanners Storage Devices Web Cams Adobe Acrobat Adobe FrameMaker Adobe Photoshop Adobe Reader Applie iLife CorelDraw Macromedia Dreamweaver Windows Media Player Instant Messaging Internet RSS News Readers Microsoft Internet Explorer Mozilla Firefox Netscape Blackberry HP iPAQ Palm Treo 650 Mac OS X Microsoft Windows 2000 Microsoft Windows 2003 Microsoft Windows XP McAfee Norton Symantec Ad-Aware Spybot Search and Destroy SpyWare Prevention Caldera GNOME KDE Linux (General) Red Hat Linux Star Office ©2006 HelpInfo About HelpInfoContact UsRegister for Email AlertsTerms of Service