@SetViewInfo not working

HCL Domino Domino Forum
1

Hi,What I really want is to select documents based on a year which the user enters…

But in the meantime, I am just trying to select documents of a certain date, to see if I can get @SetViewInfo to work at a very basic level.

I have the following code in the PostOpen for the view:

@SetViewInfo([SetViewFilter];“14/09/2004”;SubmitDate;1)

I have also tried

@SetViewInfo([SetViewFilter];“14/09/2004”;“SubmitDate”;1)

and

@SetViewInfo([SetViewFilter];14/09/2004;“SubmitDate”;1)

However, when clicking on the view I just get “Category Not Found” down the bottom, instead I want it to display the documents with a submitdate of 14/09/2004 for example. The first column is a categorised one. In it, I simply have the field name “SubmitDate” selected from the list of field names.

The field itself is Date/Time editable…

Any ideas how to make it just select that one document (or ideally just ones for a year which the user selects?

I’m tired of writing specific code for this db every year, what to avoid the task next year, so the user can just select which year they want etc…

Any ideas?

2

Subject: @SetViewInfo not working

Actually it does work, sorry, here is the code:choice:=@Prompt([OkCancelList]; “Select a Database”; “Select a database to open.”; “Schedule”; “2003”:“2004”:“2005”);

@SetViewInfo([SetViewFilter];choice;SubmitDate;1)

However, for some reason, you need to click it twice to work, or press Shift-F9 - any ideas why anyone, or what Shift-F9 is programmitically?

3

Subject: RE: @SetViewInfo not working

Update:This article solved the problem:

http://www-10.lotus.com/ldd/nd6forum.nsf/55c38d716d632d9b8525689b005ba1c0/1365081184f455e185256f9a0058eb79?OpenDocument

4

Subject: RE: @SetViewInfo not working

Another thing that will produce this effect (i.e., “Category not found” or the view appears blank) is if the first categorized column in your view is a date or a portion of a date and you’re using that as the filter.

@SetViewInfo is looking for text and if the column you’re using as your filter is in date format then it won’t match.

Convert the format of that column’s value to text and @SetViewInfo will work, e.g., @Text(@Year(Proj_StartDate)) in the column formula.