Isn’t there a way to set a view’s filter using lotusscript? I have a calendar view with several filter options programmed using formula (i.e. @SetViewInfo([SetViewFilter]; choice; “product”; TRUE)). For a couple of reasons, I want to now do this in lotusscript, but can’t seem to find a good solution. I don’t want to change the view selection formula because several users will be accessing the database at once. I don’t want to use folders because the data is being updated every 15 minutes and users need to always see the most current information.
If there is no great solution in lotusscript, is there a way to filter by date range using @SetViewInfo([SetViewFilter]? (i.e. >=1/1/2009? (That would solve at least one of my issues.)
Thanks in advance.
Subject: Setviewfilter in lotusscript
Not sure about 7, but in 6, I don’t see anything like this in LS.Also, from help: "In Standard Outline views, filters a view to display only documents from a specified category. " so unless you’re categorizing on a date, you can’t use this for date filtering.
What is it you need to do? If you just want users to be able to pull up a subset based on date, teach them how to use the search bar, or build in a query function so they hit a button, answer a question or two, and the view is searced to bring back the stuff they want.
Just curious, why LS?
Doug
Subject: RE: Setviewfilter in lotusscript
When using SetViewFilter in calendar views, the column doesn’t have to be categorized… How would you do the search (formula/lotusscript) and would it display the search results in the current view as opposed to putting them in a folder?
The users want a calender view that only includes documents from the current date/time foward. I couldn’t find a way to do that in formula and thought maybe lotusscript had a way.
Also, one of my view action buttons for filtering has a picklist for the user to select the value that they want to sort on (i.e. product name) and in formula, when a picklist is cancelled, the formula ends and you can’t process anything further. I had hoped I could use lotusscript to gain more control.
Thanks