FTSearch in notesview

HCL Domino Domino Forum
1

Hi All,

I am creating a weeks graph. no of tasks assigned in a week and completed tasks in that week.

Code:

Set viewCreated = db.GetView("TasksByCreatedDate")

Set viewCompleted = db.GetView("TasksByCompletedDate")

	

Call viewCreated.Clear

strQuery = {([CreatedOn] > } & (fromDate.DateOnly)  & {) and  ([CreatedOn] < } & (toDate.DateOnly)& { )}

docCount  = viewCreated.FTSearch(strQuery,0)

Call viewCreated.Refresh





If  docCount = 0 Then

	Msgbox "No documents found in this range",,"Message"

	Gosub Terminate 

Else

I am not getting any error but it gives all documents in that view not basing on daterange

Database is indexed. what is the wrong i did? can anyone help me in this.

Thanks in advance

2

Subject: FTSearch in notesview

If you open the view in the Notes client and show the search bar and actually type in the search (using an example from and to date) do you get any results then?

If FT searches are not working as I think they should I often find this a useful way to check my query syntax is correct

3

Subject: RE: FTSearch in notesview

Thankq for the response.

Today I have tried with that but i didn’t get any documents in that range in the view. but actually i had the documents in that daterange.

I have searched in forums and build that query can any one have lookinto that syntax please

4

Subject: RE: FTSearch in notesview

OK so that means that there is a problem with your query and not with your code.

In the help file in Notes 8 is the full text search syntax guide

http://publib.boulder.ibm.com/infocenter/domhelp/v8r0/index.jsp?topic=/com.ibm.notes.help.doc/DOC/H_SEARCH_TIPS_STEPS.html

Also read this:

http://www-01.ibm.com/support/docview.wss?uid=swg21093319

Keep trying in the view until you get the query to work and then your code should be fine

You may need to add 2 more fields to all your documents containing the text values of the dates.

5

Subject: FTSearch in notesview

Have youm tried without the “Call viewCreated.Clear” line?

6

Subject: RE: FTSearch in notesview

Thanks for your response.

I have tried with out clear method also but i didn’t get any results.