Bug with @SetViewInfo?

Hi all,

I am using @SetViewInfo in a calendar view, so according to the Notes Help the syntax should be as follows:

@SetViewInfo( [SETVIEWFILTER] ; filterString ; columnName ; exactMatch )

In my form I have a button with the following formula:

@SetEnvironment(“CSMClient”;ClientRefNo);

@Command([OpenFrameset];“fstClientDiary”)

Which opens a frameset with a calendar view. In the view PostOpen event I have the formula:

filter:=@Environment(“CSMClient”);

filterstring:=@Text(@If(@IsError(filter);“”;filter));

@SetViewInfo([SetViewFilter];filterstring;“ClientRefNo”;0)

ClientRefNo is the fifth column in the view and is hidden.

The problem I have is that the view is displaying the correct documents, but is also displaying other documents with different ClientRefNo values also. This only happens with documents that span more than one day. For example, StartDateTime is 18/04/2005 22:00:00 and EndDateTime is 19/04/2005 08:00:00. The first column in the view is StartDateTime and the second is:

(EndDateTime-StartDateTime)/60

Which works as it should, except they are not being filtered out of the view when they should.

Another thing I noticed was that only the second part of the document showed up, i.e. from 00:00:00 to 08:00:00 on the 19/04/2005. If I navigate to the previous day, the first portion of the document does not appear, i.e. 18/04/2005 22:00:00 to 18/04/2005 23:59:59.

So I changed the “ExactMatch” parameter to 1, but when I do this, ALL documents that match the view selection formula are displayed, not just the ones that match the ClientRefNo filter.

My view selection formula is:

SELECT Form = “frmClientShift”

Am I doing something wrong??

I have seen several posts on here about problems with this function that may provide some ideas, but these don’t work either. One of note being that the formula should be:

@SetViewInfo([SetViewFilter];filter;columnname; FALSE;1)

(Found at: http://www-10.lotus.com/ldd/nd6forum.nsf/55c38d716d632d9b8525689b005ba1c0/b8171cf2eebdab1485256df8003b1ecc?OpenDocument&Highlight=0,setviewinfo,calendar)

But this is not documented like this and seems to make no difference anyway!

(Another ref to this: http://www-10.lotus.com/ldd/nd6forum.nsf/55c38d716d632d9b8525689b005ba1c0/7c4d44ad2e6c1bb485256df80052c11b?OpenDocument)

Another being that the QueryClose event should contain a formula to clear the filter.

I added the following to the QueryClose event:

@SetViewInfo([SetViewFilter];“”;“ClientRefNo”;0)

Which also made no difference either.

(Found at: http://www-10.lotus.com/ldd/nd6forum.nsf/7ce2df3740ae1d1e85256d66005aa3cb/3ed9a6754d4953da85256e9b003c0f0e?OpenDocument)

As mentioned the only difference was made by changing “ExactMatch” to 1 and that produced the complete opposite effect of what you would expect (ALL documents displayed!).

Any help would be greatly appreciated, or if it is a bug, when will it be fixed???

The only idea I can think of just now would be to split the “overnight” documents into two documents, one til midnight and one after midnight or even have StartDateTime and EndDateTime as multivalues, but both of these options would take a hell of a lot of re-coding as the documents can be created in several different places using several different methods, so I am not even thinking about doing that (yet), just to find it doesn’t solve my problem!!!

TIA

Charlie