Lotus Domino:更改字段的类型后，全文搜索将不适用于该字段 [英] Lotus Domino: After changing TYPE of a field, Full Text Search won't work for this field

问题描述

我的问题: 我无法使用语法[field_name] = text_value来全文搜索视图.不在Lotus Script中，也不在客户端的搜索视图"中. 其他信息: 在搜索/更多/按字段/选择我的字段时，我得到一个组合框，其中等于"，大于" ...表示对于FT索引，我的字段为(实际上)为NUMBER. 但是几年前该字段已更改为文本，将现有数据转换为文本，重新创建了全文本索引，更改了OSD(哼哼，我应该检查一下). =>但是旧类型(数字)仍然写在Iris/Lotus systable(某种systable)中.

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).

我的问题 :如何更新FT引擎，或告诉他现在是文本类型?

My question: How to update the FT engine, or to tell him that the type is text now?

提前谢谢！

多年以来，我已经遇到过相同的问题，但是我无法在google或此处找到解决方案.

I already had the same problem many years but I can't find the solution with google or here.

推荐答案

在notes数据库中，有一个称为UNK表的部分.这将保留对数据库中每个字段和字段类型的引用.您可以在Notespeek中看到这一点.

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.

它仅保留找到的第一个字段的引用.因此，如果您有多个具有相同名称但不同类型的字段，则在您搜索该字段时，FTI会感到困惑.

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.ibm.com/support/docview.wss?uid = swg21261002

这篇关于Lotus Domino:更改字段的类型后，全文搜索将不适用于该字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！