FTSearch results truncated when ORing in $File

HCL Domino Domino Forum
1

When using a ftsearch formula that includes the $file field specifically, the results only appear to include documents which contain attachments.

For example. The query:

[myField]=(value1 or value2)

works just great, returning the expected results

The query:

[myField]=(value1 or value2) OR [$file]=(value1 or value2)

results in only documents which have a $file field appearing.

Is this the proper behavior? Does anyone know a workaround?

Thanks

Rich

2

Subject: FTSearch results truncated when ORing in $File

I would expect that since $File is a system item, it does not return an empty-string value when it does not exist. In order to be tested at all, $File would have to appear in the Note, so only documents with attachments would pass the test (since OR does not short-circuit).

3

Subject: Wrong Issue

It turns out my issue isn’t related to the $File field. Please see this post that more accurately describes the problem

http://www-10.lotus.com/ldd/nd6forum.nsf/0/0440277430c633e185256e70004df392?OpenDocument