When searching a view, there is no query that will find a document by the value of a date field if the field has multiple date values.
a query like:
[mydatefield]=01/01/04
will work as long as mydatefield has only one value. But if it contains multiple date values, the query returns no results.
This is a pretty big bug!
Is there any word on if/when this is begin addressed/fixed?
Subject: Please help! Search fails on multi-value date field **second posting!!
if it is a multivalue field then
[mydatefield]=01/01/04 will be false even if one of the entries is 01/01/04 but [mydtefield] contains 01/01/04 should be true.
Subject: RE: Please help! Search fails on multi-value date field **second posting!!
As far as I can tell, you can’t use “Contains” for a date field. I get ‘query is not understandable’.
At any rate, that won’t help because I need to search by a date range, not a specific date.
I don’t see why Domino can’t index multiple dates in a field and have them behave the same as a single date in a field when it comes to searching, similar to how multiple text values in a text field can be searched the same as single text values.
Subject: RE: Please help! Search fails on multi-value date field **second posting!!
One might argue that this is not a bug. Where do you find anything that says that it should work the way you’re assuming?
What’s the problem you’re trying to solve? Maybe someone can suggest an alternative method.
Subject: RE: Please help! Search fails on multi-value date field **second posting!!
Have a document that contains a number of dates in a single field. I would like to do a search by date range that returns all documents that have a date from that field inside the range.
For example: Mydatefield contains 1/1/04,1/2/04,1/3/04
I search for the following [Mydatefield]>5/5/01 and [Mydatefield]<5/5/05
Since at least one (in this case all) of the dates in my document are within that range, I would like that document returned in the search results.
I can do something similar with text values in a list (search for a document that contains one or more of the values), but with date values in a list, there is no way to search for a date range and have documents be returned if one or more of the dates is inside the range.
You can’t use ‘Field contains’ on the date field.
Basically, as soon as you put multiple dates in a field, you can’t search on that field and find that document.
I’d call that a bug.
Subject: RE: Please help! Search fails on multi-value date field **second posting!!
You could do the same thing with Search instead of FTSearch, though it might be a bit slow.
The other way to do it is, create a view that lists all documents sorted by date with the column option enabled to display multiple values on separate rows. Then you can use a NotesViewNavigator to binary-search the view for the first and last entries that fall within your range. That would be more efficient for most searches.