Hi guys,
Im modifying the Advanced search of Domino Document Manager (v.7) and have come across a confusing problem.
im trying to search across Domino.Doc file cabinets using FT search. I have several date values included in my search, one from the _CreationDate field and others from fields in my DocTypes. Problem is that i can search for documents if i provide just one date field (_CreationDate OR (any)DocTypeDateField) but returns error if i use both.
here is an actual query using two date fields in my search:
(FIELD _CreationDate = 09/28/2007) AND FIELD RM_File_Type CONTAINS (Administrative) AND FIELD RM_Subject_File_Code CONTAINS (ADM - ADMINISTRATION AND ORGANIZATION) AND FIELD Segment CONTAINS (00-PROCESSING) AND FIELD RM_Essential_Document CONTAINS (Yes) AND FIELD RM_Access_Level CONTAINS (Public) AND FIELD RM_Disposition_Rule CONTAINS (3 years from the date of PCR) AND FIELD RM_Record_Format CONTAINS (pdf) AND FIELD Type CONTAINS (Channel Financing Agreement) AND (FIELD Agreement_Date = 09/28/2007)
This returns a “Notes error: Query is not understandable” error. While if only one of the date fields are provided as search conditions, it works fine and gives me search results…
i have tried using the brackets as ive seen on some date-related problems in the forum, but still i get errors, only when i use two date fields in my search…
what may be the problem? am i not getting something?
pls help! thanks!