LIMS-plus v.3.7.30 LIMS-plus v 3.7.30 is now available on our fileshare site. Please review the release notes prior to deploying into production Release Notes v3.7.30.pdf (300 KB) Have more questions? Submit a request 1 Comments Date Votes 0 Melissa Bennett January 06, 2012 22:44 Release Notes v. 3.7.30* *combined 3.7.27, 3.7.29 and 3.7.30 release. 3.7.28 is an Arabic version of the application and is maintained separately from this code base. Important Notes regarding this release: Customers on Oracle Environments should not use this newest release until it is fully audited by our QA testing team. Some enhancements require additional documentation which will be available on ZenDesk within a week of the release date, in order to fully understand the functionality. Customers using custom-built applications to import case/evidence/other data, please be aware that the Offense Code and Description fields have been extended and this could potentially impact your application. If you believe you may be one of these customers, please contact JusticeTrax customer support before upgrading. An email will be sent to each of the customers we have identified as possibly being impacted, but there may be some we are unaware of. Bugs and Enhancements TFS Title/Category Description 9669 Indexer Oracle error when selecting LOCATE CASE Indexer was erroring in the Oracle environment when Locate was selected. The error message presented was that a table or view was missing. This is no longer occurring. 8960 eCaseFile High resolution images are broken up on multiple pages when generating an eCaseFile. eCaseFiles use the Crystal Report engine to first create the file, which is then converted to .pdf. The creation of the Crystal Report file is invisible to the end user. In order to make high resolution images print to one page, the scaling property had to be invoked within the Crystal engine. This has been completed, so high resolution images will always ‘fit to page’. The exception to this is if the user selects “Use Photo Wizard”. Selecting this checkbox tells the application to use the photo print wizard, and the user must then select the preferences for images when prompted. 9895 Indexer Do not allow users to add images from Indexer to a request if Draft Complete, Tech Reviewed or Admin Reviewed (if Lab Option: Lock Images for Draft Complete Requests is ON) Indexer was enhanced to check for the rule of Locking Images related to Draft Complete (and beyond) requests. No images/attachments can be added to a case once it reaches the Draft Complete milestone. 9968 DNA Alternate Dilution Calculation Within the DNA Module, on the DNA Dilution for Amplification form, the application now has the ability to calculate using the formula: DNA Concentration x DNA Vol. for Dilution/Low TE Vol. for Dilution = Targeted Final Conc. The original calculation can still be used also. A more lengthy description of the change made, and its effects on the form will be available in ZenDesk Reference Materials shortly. Anyone using the DNA Module will need to select the calculation option to the preferred method in DNA Module administration before using the module again after the upgrade. 9251 SSO Sign On† Allow Single Sign on using the LDAP Translation Web Service This was created specific to a single customer’s environment and will not be applicable in any other environment. 9406 Foray Integration‡ Allow Integration with Foray’s Latent Case Management within a request This integration allows the LIMS-plus application to invoke the Foray LCM software from within the edit findings of a request. 9405 ADAMS Integration‡ Allow integration with Foray’s ADAMS This integration allows the LIMS-plus application to interact with the Foray ADAMS application. 6566 iResults Agency Restriction¥ Agencies can be restricted from viewing any case in iResults that is not from their agency (ie. Where their agency is not the Requesting Agency). A new option is available within the Agency setup in System Administration that will restrict individual agencies to allow them only to view cases where they are the REQUESTING agency named on the request. Before this enhancement, any agency on the Agency tab in LIMS-plus was able to view any request on that Case (unless the Case was restricted otherwise). E.g. Springfield Police Department and Shelbyville Police Department are both agencies related to case #2011-0001. (They appear in the Agency tab) Request #001 – Screening Analysis was requested by Springfield PD. Without this restriction on, both agencies are able to see the request in iResults because they are both agencies on the case. But if we specify that Shelbyville can always only see requests where they are the requesting agency, they will NOT be able to view, or download the final reports for this request. 8334 Agency Rep Additional Data‡ Ability to record additional Agency Rep details (“Post” details - Bureau, Division, Precinct, Section, Unit, Detail) These details are only available when the Lab Option: Allow Rep Post Records is ON. Each is a picklist that is administered in System Administration under the Picklist | Demographic area in LIMS-plus. A Start Date is also associated with these demographics so it can be utilized in any Crystal Report (e.g. a report that indicates when a specific Agency Rep changed Divisions, or Units, etc). To add this data, there is a button on the Agency Rep form to Access Post Records. 6565 Agency Administration – Related Agencies¥ Ability to administer Additional Case Agencies for each Agency in Agency Administration Within System Administration | Agency, there is a button for Additional Case Agencies. This allows the administrator to select specific other agencies, so that when an agency is added to a case, all additional case agencies are added automatically. (e.g. Springfield Police Department has Additional Agencies of Springfield DA’s Office and Shelbyville DA’s Office. Whenever Springfield PD is selected as a Case Agency, all three agencies are automatically added to that case) 9442 Edit Chain of Custody The Edit Chain of Custody feature was inadvertently broken in a previous release, and would not allow editing of the parent evidence item. This has been fixed. †For Metro Nashville PD only ‡ For Metro Nashville PD but can be used by other agencies wishing to gain the same functionality ¥ For Louisiana State Police, but can be used by other agencies wishing to gain the same functionality Database Changes Table Field A/M Type Size Allow Nulls? Default Value Lab_Reps_Post Rep/ID A Char 14 N (GETDATE()) Lab_Reps_Post StartDate A DATETIME N (SPACE(1)) Lab_Reps_Post Bureau A VARCHAR 75 N (SPACE(1)) Lab_Reps_Post Division A VARCHAR 75 N (SPACE(1)) Lab_Reps_Post Precinct A VARCHAR 75 N (SPACE(1)) Lab_Reps_Post Section A VARCHAR 75 N (SPACE(1)) Lab_Reps_Post Unit A VARCHAR 75 N (SPACE(1)) Lab_Reps_Post Detail A VARCHAR 75 N (SPACE(1)) Lab_Reps_Post RowGUId A UNIQUEIDENTIFIER N Agency_Reps_Post Rep/ID A Char 14 N (GETDATE()) Agency_Reps_Post StartDate A DATETIME N (SPACE(1)) Agency_Reps_Post Bureau A VARCHAR 75 N (SPACE(1)) Agency_Reps_Post Division A VARCHAR 75 N (SPACE(1)) Agency_Reps_Post Precinct A VARCHAR 75 N (SPACE(1)) Agency_Reps_Post Section A VARCHAR 75 N (SPACE(1)) Agency_Reps_Post Unit A VARCHAR 75 N (SPACE(1)) Agency_Reps_Post Detail A VARCHAR 75 N (SPACE(1)) Agency_Reps_Post RowGUId A UNIQUEIDENTIFIER N Lab ADAMSServer A VARCHAR 50 N (SPACE(1)) Lab ADAMSAgcId A VARCHAR 50 N (SPACE(1)) Lab ADAMSFolderType A VARCHAR 50 N (SPACE(1)) Lab ADAMSProtocol A CHAR 5 N space(1) Agency LimitedAccess A INT 0 Agency_Rel Agc_ID A CHAR 14 Agency_Rel RelAgc_id A CHAR 14 dnaDilutAdm DILUTCALC A Integer Y A/M (field Added or Modified) Stored Procedures Database SP Name A/M SQLLIMS/iResults sp_Rs_request_user M SQLLIMS/iResults Sp_RS_request_user_byInd M Executable mapping Exe name Description Version Number LIMS-plus®.exe Application 3.7.30 Imaging.exe Imaging Module 18.104.22.168 TRImaging.exe Training Module 22.214.171.124 JTimageindx.exe Indexer 126.96.36.199 Preloginterface.exe iPrelog Interface 188.8.131.52 MedicalExaminer.exe ME Module 184.108.40.206 JTEmail.exe Event Notification Mail Process 220.127.116.11 iPrelog WebUI iPrelog Application Build Build 42 iPrelog MailReader MailReader Application Build Build 27 iResults iResults Web Application Build 47 Release Notes v. 3.7.29 Bugs and Enhancements TFS Title/Category Description 9689 DNA Module Missing Function Error in DNA module CE Export When clicking the export button on the CE Module, Oracle database users were receiving an error message indicating that a Function Name was missing. This is no longer occurring and was restricted to Oracle environments. 9473 Controlled Substances Module Controlled Substances Module Data Extension form – Error returned that it would not save data In the Oracle environment, the Controlled Substances module Data Extension form would error when there were no Data Extension fields. This is no longer occurring and was restricted to Oracle environments. 9491 Image Review Required Dialog Missing image reviews dialog box is too small to read the full text of the message When Image Reviews are required in a Request for Analysis but not completed by the analyst rolling the milestone, the returned dialog indicating the image name and/or page number(s) requiring review was too small to read all image names/page numbers. This form has been resized appropriately. 9732 Toxicology Module – Global Update Dates Assigned on date can't be greater than Completed on date In the Toxicology Module, the new feature allowing users to indicate a global Assigned On date and Completed On date was performing an incorrect date validation. It was not set to take into account the year in which the dates indicated were taking place. Therefore, if a user had an Assigned On date of 12/21/2010 and a Completed On date of 1/2/2011, they were incorrectly receiving a message that the Assigned On date was prior to the Completed On date. The validation has been corrected to take the year into account. 7601 Blood Alcohol Module Blood Alcohol Module Enhancement: Allow entry of results in mg (Analytical Module Administration Option) Customer requested enhancement to allow the users to enter results in mg (add results with integers >1). The previous versions only allowed result entry of numbers <1. A new analytical module administration option was added to the Blood Alcohol module. Checked = results that are entered are <1 (e.g. 0.080) Unchecked = results that are entered may be >1, and the user must indicate where the decimal is placed. (e.g. 80.0) 7254 Imaging Module Unable to copy/view images with annotations to a folder or directory Using the option within the Imaging Module to Copy Image with Permanent Annotation successfully burns the annotation to the copied image. The annotation is not permanently burned to the original image in the Imaging Module. Note that during the copy process the annotations burned onto the image may not have the same resolution as the original. A decrease in quality of the image/annotation is apparent. 8967 iPrelog LIMS Interface (Accept Evidence) Accept Evidence Interface (iPrelog-LIMS form) Queue is slow to load, has duplicate entries and in rare circumstances, the data are not present. To address these issues, the following actions were taken: Queries were re-written to create the queue in a more efficient manner; Code was created to handle this, however, the folder polling interval for iPrelog mailreader should not be set to any less than 10 minutes; Special Characters that are HTML un-friendly are now handled in the code so that they do not result in an error when submitting the case in LIMS-plus. 7861 Create Worklists Worklist Enhancement: Allow ALL analysts as a filter for creating worklists Previously, the application required the user to select either one analyst, or *unassigned* when returning a list of requests from which to create an analytical worklist (Analysis | Create Worklist menu option). An enhancement was made to this functionality to filter worklists by searching for requests assigned to any analyst (ie. ALL analysts). The caveat to using this functionality is that in the creation of the worklist, if ALL is selected, then the individual requests assignments are not changed. If an analyst name is selected, then all analytical requests are re-assigned to that analyst. More detail will be given in an upcoming ZenDesk article. 8342 General Analytical Module General Analytical Module tree-view is frozen after using Data Extension form, Image form or Itemizing Evidence from within the result. When accessing Imaging, Data Extensions or Itemize Evidence in the Edit Findings window, users were finding that for the General Analytical Module, they were unable to select another node on the tree-view in Edit Findings without exiting Edit Findings and re-entering it. This has been fixed. 8622 Activities Activity entry: Allow using Enter or Tab key on start/complete date When adding an Activity to a case, users reported that the [Tab] key allowed them to move from date field to date field, but using the [Enter] key applied the form and closed it. This has been fixed. 8625 DNA Module DNA Module CE Form: Instrument field not refreshing when moving between records. In circumstances where a new record was added to the DNA Module CE Form, and the user attempted to move between these records, the Instrument selected was not refreshing. This has been fixed. 8685 Imaging Module Changing Imaging Repository loses subfolders and images The Imaging Repository set up in System Administration | System Defaults | Default Directory Settings | Imaging Root Directory can be changed (with appropriate permissions). In changing the directory, administrators reported that the images in the previous directory were now inaccessible. This has been fixed. 5816 Assigning Technical and Administrative Reviews Assign Technical and Administrative Review window is not showing accurate data A previous modification to the Milestone functionality in the LIMS-plus required making changes to data storage in the database. The Assign Technical and Administrative Review functions were not updated to query the newly added data fields in the database. Therefore, the current assignments of Administrative and Technical reviews were not reflective of the actual cases assigned. All queries have now been modified to use the new data fields in the database. 8494 ME Module Allow Users to resize ME Module Forms ME Module users requested the ability to re-size forms as they are able to in the LIMS-plus application. This modification was made to the ME Module as well. 9165 Indexer Allow SQL Authentication to be used in Indexer Indexer can now be used in SQL Authenticated environments. Database Changes Table Field A/M Type Size Allow Nulls? Default Value Lab Dec_auto A Int 4 N (1) IntegrationProxyURL A Varchar 100 Y (1) BARejVal M Increased to numeric (7,4) BARejThr M Increased to numeric (7,4) BAToxLev M Increased to numeric (7,4) BACutoff M Increased to numeric (7,4) Alcohol Result1 M Increased to numeric (7,4) Result2 M Increased to numeric (7,4) Deviation1 M Increased to numeric (7,4) Deviation2 M Increased to numeric (7,4) A/M (field Added or Modified) Stored Procedures Database SP Name A/M iPrelog SP_GetAgencyRepsForCase A Release Notes v. 3.7.27 Bugs and Enhancements TFS Title/Category Description 8042 Imaging Module Unable to add images to Imaging Module for SQL Authenticated Environments This has been fixed. Imaging Executable 18.104.22.168 and greater will now work for SQL Authenticated environments. 6761 iResults Security iResults: Prevent SQL Injection A security concern regarding the iResults application was discovered by a customer. Previously, the iResults application was vulnerable to SQL injection by modifying the URL to bypass security requirements in the application to access data. They have since been identified and fixed by replacing all inline SQL commands for returning data to Stored Procedures to return the data. 7330 iPrelog Security iPrelog: Prevent SQL Injection Same changes as made for iResults. All inline SQL commands changed to Stored Procedures. 7762 Offenses Increase Offense Description and Offense Code field lengths Request from a customer involved changing the Offense Code field length to 50 characters, and the Offense Description to 500. Please contact JusticeTrax Technical Support if you are upgrading to a version 3.7.30 or greater and use a custom application to import case data. Customers that have custom triggers/procs that say the input is char(15), this will need to be changed there as well. Please contact JusticeTrax Technical Support if you believe you may be one of these customers! DB Changes Table Field A/M Type Size Allow Nulls? Default Value Lab LanguageDisplayFont A CHAR 50 N Space(1) Offense Offcode M Increase to char (50) Offense Description M Change to varchar (from char), increase to (500) Case_off Offcode M Increase to char (50) Pl_Offense Offcoce M Increase to char (50) A/M (field Added or Modified) Please sign in to leave a comment.