How to write DB search Criteria

HCL Domino Domino Forum
1

Dear All

I have tried with the following DB search criteria

Form=“fResponsible” & Division = “TE” & Company = “ContiTech AG” & Location = “Hannover [VVA]” & Status = “Active” & Type = “LITM”

without error it return 0 document even the document exists

or

Form=“fResponsible” And Division = “TE” And Company = “ContiTech AG” And Location = “Hannover [VVA]” And Status = “Active” And Type = “LITM”

this return Notes error: Formula Error 4005

please any body suggest me what is the right approach to write the search criteria when we are using DB.search method

Thanks

Regards

Ashish

2

Subject: How to write DB search Criteria

Your first search string lloks ok.

You may try:

a) |Form=“fResponsible”| and see if any document is returned now

b) show us the actual contents of your search string (from debugger or msgbox)

3

Subject: RE: How to write DB search Criteria

Just want to note that my R7 system throws Error 4005 “User-defined error” when the search string is malformed.

4

Subject: How to write DB search Criteria

Easy way to test db.Search criteria is to create a temporary view and use it as your Select criteria. In this case, create your view selection as:SELECT Form=“fResponsible” & Division = “TE” & Company = “ContiTech AG” & Location = “Hannover [VVA]” & Status = “Active” & Type = “LITM”

The view should display the same number of documents as the db.Search returns.