Browse Prior Art Database

Domino Database Status Determination using Web Query Open Event Disclosure Number: IPCOM000015873D
Original Publication Date: 2002-May-27
Included in the Prior Art Database: 2003-Jun-21

Publishing Venue



In the case where a domino web site has to be periodically "closed" from end user input so that end of quarter processing can be performed without further data changes entered from the web. In order to prevent data entry from the web, the default "home" page for the Domino database was being switched by hand to a "we are temporarily closed" home page that did not allow data input. The problem with the "by hand" method was that if the person forgot to switch the home pages, additional data could be entered when the database was supposed to be closed. Or once the back-end processing was completed, if the home pages were not switched back, users were kept from entering data when it was now appropriate to do so. This invention is to utilize the domino web query open event for the site home page to run a LotusScript macro on the server to determine if the web site should be open or closed. The LotusScript macro has an array of dates/times which indicate when the database should be closed and it checks if the current time falls within one of the closed ranges. If the database should be closed, this indication is used to send the user to the "we are closed" page, otherwise the user goes to the regular home page. The actual indication used to indicate the database status can vary based on the database design. One implementation has a domino field on the home page which is the VALUE= value for a JavaScript variable on the page. When the database is supposed to be closed, the LotusScript macro sets that notes variable to the date/time when the database is scheduled to reopen. The JavaScript code checks whether the JavaScript variable is blank or not. If its blank, it means the database is open and the home page continues to render. If the JavaScript variable is non-blank (its the date/time when the database is scheduled to reopen), the JavaScript code changes the URL to redirect the user to the "we are closed" page, passing the reopen date/time as a parameter to be displayed to the user so they know when to expect the database to be open again. This implementation was chosen since the majority of the time the database will be open so the users will stay at the URL they originally connected to. The use of the web query open event solves a number of problems associated with this type of checking: