FTSearch string and checking number field is NOT empty

HCL Domino Domino Forum
1

Hi there,

I am building a search string in lotus script to perform an FTIndex. If I have a number field and want to check it is NOT empty how would i go about it? Using does not contain “” doesn’t work :frowning:

2

Subject: FTSearch string and checking number field is NOT empty

You can use [FieldName] is present

http://www.alanlepofsky.net/alepofsky/alanblog.nsf/dx/searching-for-blank-fields

3

Subject: RE: FTSearch string and checking number field is NOT empty

Thanks for your rapid response!

This doesn’t work when i use it in the lotus script formula though…

searchstring = |NOT [ProposalLoanRequest] is present|

set collection = db.ftsearch(searchstring,0)

It gives me formula error on the last line :frowning:

4

Subject: RE: FTSearch string and checking number field is NOT empty

Hi there guys!Harkpabst - first of all - thanks for pointing this out! Very useful in building search strings!

Stephen - I did a quick test - this works fine for me in LS - returns exactly the same number of documents as when I get if do the search manually.

5

Subject: RE: FTSearch string and checking number field is NOT empty

Hi there,

If i use a different field name, a text field name this works fine. With my number field though i get ‘query is not understandable’ even when typing it in the search bar

NOT [ProposalLoanRequested] is present. Is there some sort of field length limit?

6

Subject: RE: FTSearch string and checking number field is NOT empty

Could you please post that part of your LotusScript code literaly, using copy/paste from Designer?

7

Subject: By default

Numbers are not full text indexed in Domino, maybe this is the issue?