Notes Error Relational Operators Are Not Supported In Text Fields
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 Lotus Domino: After changing TYPE of a field, Full Text Search won't work for this field up vote 3 down vote favorite My problem: I can't Full text search a view with the syntax [field_name] = text_value. Not in lotus Script nor in the "search the view" in the client. Additional information: When searching/More/By field / selecting my field, I get a combo box with "is equal to", "is greater than" ... meaning that for the FT index my field is (was in fact) NUMBER. But The field has been change to text years ago, existing data converted to text, full text index re created, OSD changed (hum I should check this). => But the old type (number) is still written somewhere in Iris/Lotus systable (sort of systable). My question: How to update the FT engine, or to tell him that the type is text now? thanks in advance! I already had the same problem many years but I can't find the solution with google or here. lotus-domino share|improve this question edited Feb 5 '12 at 18:27 Declan Lynch 3,164934 asked Feb 5 '12 at 17:43 Emmanuel Gleizer 1,256721 add a comment| 1 Answer 1 active oldest votes up vote 8 down vote accepted In the notes database you have a section called the UNK table. This keeps a reference of every field in the database and field type. you can see this in Notespeek. It only keeps a reference of the first field it finds. So if you have multiple fields with the same name but different types the FTI will get confused when you search on the field. More details and solution to resolve is in this tech note. https://www-304.i
Training Support Forums & community Events Rational Tivoli WebSphere Java technology Linux Open source SOA and Web services Web development XML My developerWorks About dW Submit content Feedback developerWorks>Lotus>Forums & community>Notes/Domino 4 and 5 Forum Notes/Domino 4 and 5 Forum RE: Notes error relational operators are not supported in text fields RE: Notes error relational operators are not supported in text fieldsPosted by Luke Kolin on 19.Dec.01 http://stackoverflow.com/questions/9151448/lotus-domino-after-changing-type-of-a-field-full-text-search-wont-work-for-th at 11:38 AM using a Web browserCategory: Domino Designer -- AgentsRelease: 5.0.8Platform: iSeries The field is marked in the UNK table (which is what the FT search uses to determine the data type) as TEXT. Create a new replica of the database, and this'll rebuild the UNK table and fix the problem. Cheers! http://www-10.lotus.com/ldd/46dom.nsf/869c7412fe5d56b7852569fa007826e3/39ea531630a8861085256b27005b6cbb?OpenDocument Luke Return to top Notes error relational operators ar... (Contin Beatrice... 19.Dec.01) . . RE: Notes error relational operator... (Luke Kolin 19.Dec.01) Document options Print this page Search this forum Forum views and search Date (threaded) Date (flat) With excerpt Author Category Platform Release Advanced search RSS feeds All forum posts RSSAll main topics RSSMore Lotus RSS feeds Resources Forum use and etiquette Native Notes Access Web site Feedback Lotus Support Lotus Support Product support pages index Search knowledge base (Technotes) Search support downloads Lotus Support RSS Wikis IBM Composite Applications IBM Mashup Center IBM Connections IBM Docs IBM Forms IBM Mobile Connect IBM Sametime IBM SmartCloud for Social Business IBM Web Experience Factory Lotus Domino Lotus Domino Designer Lotus Expeditor Lotus Foundations Lotus iNotes Lotus Instructor Community Courseware Lotus Notes Lotus Notes & Domino Application Development Lotus Notes Traveler Lotus Protector Lotus Quickr Lotus Symphony IBM Web Content Manager WebSphere Portal Lotus
Subscribe You can track all active APARs for this component. APAR status Closed as fixed if next. Error description UNK Table http://www-01.ibm.com/support/docview.wss?uid=swg1LO76962 is not updated even if user changes field type by designer. For this problem, the customer cannot full text search by field correctly. Steps: 1. Create New Notes Database 2. Add a form and add a field as below Field Name: ComposedDate Field Type : Text , Editable Default Value: @Today 3. Create a document by the above form and save it. notes error 4. Change a field type to Date/Time from Text as below Field Name: ComposedDate Field Type : Date/Time , Editable Default Value: @Today 5. Create a document and save it. 6. Create full text index to the database 7. From menu, [View - Search This View] 8. Click [More] 9. Push Field button and choose "ComposedDate" field. 10. [Problem] search conditions are "contains" notes error relational and "does not contains" only. These are for Text field. If user input the following search query by manually, it fails with the error "Relational operators are not supported in text fields" (FIELD ComposedDate >=2013/07/29) Local fix At First, Delete Full Text Index. And then perform copy compact (Load Compact -C) from server console. It can fix UNK Table correctly. Problem summary This APAR is closed as FIN. We have deferred the fix to a future release. Problem conclusion Temporary fix Comments This APAR is associated with SPR# CSAO9BFB84. APAR Information APAR numberLO76962 Reported component nameDOMINO SERVER Reported component ID5724E6200 Reported release853 StatusCLOSED FIN PENoPE HIPERNoHIPER Special AttentionNoSpecatt Submitted date2013-09-11 Closed date2015-11-19 Last modified date2015-11-19 APAR is sysrouted FROM one or more of the following: APAR is sysrouted TO one or more of the following: Fix information Applicable component levels R853 PSNUP Document information More support for: IBM Domino Software version: 8.5.3 Reference #: LO76962 Modified date: 19 November 2015 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