Fulltext and number field

Hello,

I have application where each document has an ID field with sequence number in it. It is stored in normal Number field. Customer asked me why it is not possible to find these documents using full-text.

I was surprised that it doesn’t work. If i put just a number into the full-text search area above a view, nothing is found. If I put there [ID]=100, the document is correctly found.

Is there a way how to make the search work also just for 100? I don’t want to explain the syntax using to every user in the organization :slight_smile:

I know that a workaround would be to store the ID as text in another field, but I don’t like to duplicate data.

Thanks for advices

Martin

Subject: FT search for numerics …

has been an issue through every version of Notes that I can remember (goes back to R3). Try this for some more info:http://www-01.ibm.com/support/docview.wss?rs=463&context=SSKTMJ&context=SSKTWP&dc=DB520&dc=DB560&q1=index+and+number&q2=search&q3=full&uid=swg21100793&loc=en_US&cs=utf-8&lang=en

Subject: Thanks

Thank you, strange that I haven’t had this problem before. Just another Notes “feature” :slight_smile:

M