This forum is closed to new posts and
responses. The content has been migrated to the Digital Solutions Community. Please join us there for new content as well as this content. For customer support, please visit the official HCL customer support channels below:
Well, that's one thing you can't really do when you're not working with a relational database. The view is not to be confused with a SQL statement. It's a fixed selection of data, which is not done in real time, but is done in the background, and cached, ready to be presented to a user. You can not open a view with a parameter from the Notes client.
If you want to create a view, don't ever use @Today, @Now, or any variation on those formulas. The server will never stop reindexing the view. You can, if you want to, create an agent that updates the view selection formula nightly, if you want a view with only "current" documents.
Make sure to also search the older forums for versions 4 & 5, and 6 & 7, for more information on this topic.
/Peter
Feedback response number WEBB928JGW created by ~Sigmund Cisfreegenakoi on 11/20/2012
Not SQL
Return to top
. . Not SQL (~Sigmund Cisfre... 20.Nov.12) 
