Follow

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

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

1 Comments

  • 0
    Avatar
    Melissa Bennett

    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

    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

     

     

     

     

    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:

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

     

    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.
Powered by Zendesk