Is there something quirkly with using NOT IS PRESENT in a search?
This appears to work as expected:
(NOT ([closed] IS PRESENT)) AND ([state] IN (“LA”))
But, this ignores the ‘[state] IN’ criteria and returns all documents where closed is null:
(NOT ([closed] IS PRESENT)) AND ([state] IN (“LA”,“KS”))
Thanks
Subject: is present combined with other clauses
I’m trying searches in this forum, e.g. (NOT ([remote_host] IS PRESENT)) AND ([status] in “closed”, “figs”) and that seems to work OK. For instance, the main topic of this thread was not in the results.
Subject: is present combined with other clauses
And this works, but could make my search strings too long to go that route:
(NOT ([closed] IS PRESENT)) AND ([state] IN “KS” OR [state] IN “LA”)
Thanks
Subject: is present combined with other clauses
I thought maybe it was something with the data, so I tried other databases with the same result. All are full-text indexed and updated. The fields I’m searching are on the documents. I was initially trying the search in Lotusscript with FTSearch and then I also tried it right on the Search bar in the client.