LABCAL_GENONCEADAY Facility Setting instructs Lab Cal to generate new Samples only once per day. Setting should be used in situations where users have a large number of samples which causes the calendar to take a long time to display.
With this setting on, the first user to start Lab Cal (i.e. go to Data Manager, Lab Cal) on a day will generate any samples that need to be placed on the calendar. Subsequent users that start Lab Cal on that day will not generate samples (greatly reduces load time).
To set Lab Cal to only generate samples once per day:
Use SQL Console and execute the following statement to add the flag to the Facility's Settings table.
- SQL Server: INSERT INTO Settings Values ('SUPER',GETDATE(),'LABCAL_GENONCEADAY','12312014')
- Oracle: INSERT INTO Settings Values ('SUPER',SYSDATE,'LABCAL_GENONCEADAY','12312014')
- Users should also check the number of off calendar open samples. Lab Cal anayzes all open samples when loading the calendar (whether they fall in the date range of the calendar or not) to update the Sample Status (Pending, Received, Analyzed...). Old Samples should be closed. On the Lab Cal Calendar check the Old Samples button for a count.
- The date of the last Sample Generation is stored as a string in the SETTINGS table. The format of the date must be mmddyyyy and optionally can contain the hh:mm:ss. Example: