Search field for exact value?

HCL Domino Domino Forum
1

Want to find all documents which field ‘myField’ has the value ‘myValue’

A view search:

[myField] = “myValue”

will find these document but also more,

for example will also find documents which ‘myField’ contains “myValue second”, “myValue third” o “myWord myValue”

How to search exactly that the value IS “myValue”?

Thanks a lot,

J R

2

Subject: search field for exact value?

I think it’s not possible to search for exact match for text fields. Maybe try to combine

[Field]=“My Value” and (not([Field]=“My Value*”)) or something like that …don’t know…

3

Subject: RE: search field for exact value?

This search would not find any document since no field can contain “My value” and not contain “My value*” at the same time.

Because the first search is a subset of the second one…

I highly appreciate the idea,

J R

4

Subject: search field for exact value?

Click on the ‘More’ button (bottom right hand side of the search bar) and uncheck the “Use word variants” and “Fuzzy search” options.

If you want case to matter then you need to full-text index the database with the appropriate options.

Stephen Lister
5

Subject: RE: search field for exact value?

Both checkboxes were unchecked.It doens’t help.

I tried with both Domino 6.0.1CF1 (server & client)

and Domino 5.0.10 (server & client) with the same behaviour.

Thanks anyway,

another suggestion any somebody?

J R