Important Notes regarding this release: 

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.

Database

SP Name

A/M

SQLLIMS/iResults

sp_Rs_request_user

M

SQLLIMS/iResults

Sp_RS_request_user_byInd

M

Exe name

Description

Version   Number

LIMS-plus®.exe

Application

3.7.30

Imaging.exe

Imaging Module

5.6.0.29

TRImaging.exe

Training Module

4.4.0.24

JTimageindx.exe

Indexer

2.1.0.19

Preloginterface.exe

iPrelog Interface

1.0.0.80

MedicalExaminer.exe

ME Module

2.0.0.56

JTEmail.exe

Event Notification Mail Process

1.0.0.4

iPrelog WebUI

iPrelog Application Build

Build 42

iPrelog MailReader

MailReader Application Build

Build 27

iResults

iResults Web Application

Build 47

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:

  
1. Queries        were re-written to create the queue in a more efficient manner;
  
2. Code        was created to handle this, however, the folder polling interval for        iPrelog mailreader should not be set to any less than 10 minutes;
  
3. 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.

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)

Database

SP Name

A/M

iPrelog

SP_GetAgencyRepsForCase

A

TFS

Title/Category

Description

8042

Imaging Module

Unable to add images to   Imaging Module for SQL Authenticated Environments

This has been fixed.  Imaging Executable 5.6.0.29 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. 

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)