SEURAT Version 5.6 February 2nd, 2010

Improvement

• [SEURAT-339] - Allow wildcard searches in Assay Selection Dialog and Add Data dialogs. Very, very useful if doable!
• [SEURAT-340] - Display the doc name and the URL instead of just URL
• [SEURAT-341] - Select and delete multiple columns at a time
• [SEURAT-342] - *Multiple scientists and lots very important as ISIS supports this well* Ability to search for multiple lots and lot scientists via a wizard like the assay selection dialog, with wild cards
• [SEURAT-343] - In Assay Lot Amount and Lot number Query, should be able to do a < or >, not just =
• [SEURAT-344] - Query for and return Lot amount remaining as default column for Lot info in addition to (or instead of) Lot amount registered.
• [SEURAT-349] - Forms Hidden Columns - Allow hidden columns in forms tables (example PK-ID, the Seurat primary key, is taking up a lot of real estate and it is meaningless to the user).
• [SEURAT-378] - Handle removal of a sub mapping from a primary mapping so that saved jobs still run if possible
• [SEURAT-381] - Modify Debug Template Job dialog so that the split pane can resize to the right
• [SEURAT-382] - Move setting dbs_to_search to Options dialog from the "Preferences" dialog
• [SEURAT-383] - Xtal Structure Information missing if Server fails to connect to any of its configured DBS during startup.
• [SEURAT-385] - Refactor assay_url_rules to use MatchOperator code.
• [SEURAT-392] - Protocol Selection list should support wildcard searching
• [SEURAT-393] - SDF File Import Into Report/Job - make importing SDF Header optional
• [SEURAT-396] - Upon SDFile import, the column ordering in Seurat should be the same as the order of the original SD tags. Currently, the columns get reordered alphabetically
• [SEURAT-397] - Search on Assay Protocol to support "like" with wildcard
• [SEURAT-398] - Provide way to generate image overlays to show in Assay Display
• [SEURAT-399] - When importing an SDF file, make the importing of the SDF Record Header optional.
• [SEURAT-411] - Enhance forms to be able to express assay constraints such as "not like xxx%"
• [SEURAT-419] - Allow launch SEURAT from web page button without page transition

Refactor

• [SEURAT-400] - Refactor Excel Export to Use POI

Configuration

• [SEURAT-345] - Assay Protocol is not hooked up? Returns 1 or 2 only. Please Gray out or fix

Bug

• [SEURAT-331] - PK data forms and attachments - no common ID prevents attachments from being displayed
• [SEURAT-332] - Forms - Submappings preventing single sets of raw data from being displayed and plotted (all raw results get displayed and plotted, even if they are from different experiments).
• [SEURAT-333] - Lot amount remaining and prepared columns (and other Libra data?) return duplicated data (expanded view) if multiple endpoint assays have been added as columns.
• [SEURAT-334] - When an Corporate ID row is added all hidden rows become visible, all sorting is lost...
• [SEURAT-336] - Project Name "like" searches fail
• [SEURAT-337] - If change a "Specified at Runtime" structure constraint and then save job when re-run reverts to original structure
• [SEURAT-380] - Export to PDF and Excel (MHT) fails if NaN in Expt Result Desc for one or more rows where majority have a valid quantitative value in Expt Result Value
• [SEURAT-395] - Sorting needs to be reapplied after adding data from the "Add Data" dialog.
• [SEURAT-407] - Search Portal Compound Id search does not use "like" operator with % and _
• [SEURAT-422] - NPE shown when clicking Runtime checkboxes in Advanced Search

SEURAT Version 5.5.2 November 22nd, 2009

Improvement

• [SEURAT-87] - Matches between properties entry table name and table names in syn_tables are case sensitive
• [SEURAT-318] - jdbc_connection_url parameter added for specifying the fully qualified JDBC connection string.
• [SEURAT-326] - Upgrade to latest JChem version - adds support for Markush Structure Storage, Search and Enumeration
• [SEURAT-351] - Improve speed of structure searches when search is general (returns many compounds) and is combined with other criteria
• [SEURAT-358] - Add the ability to set the tab labels for Template Form.
• [SEURAT-359] - SDF File Import Into Report/Job - Now create a column for the value in the SDF header of each record
• [SEURAT-360] - SDF File Load Into Database - No longer interpret a duplicate compound in a single SDF file as another lot of that compound, reject duplicate instead
• [SEURAT-367] - Add job.id.user property to be used with job.id.password property to specify the server username and password.
• [SEURAT-368] - Enable the automatic execution of an initialization SQL statement
• [SEURAT-372] - Add Support for older ISIS Direct cartridges that dont support smiles or smarts for query structure definition

New Feature

• [SEURAT-362] - Support Markush Structure Storage and Retrieval in Compound Whiteboard

Refactor

• [SEURAT-353] - Change db.constants.refresh.interval to be set as a property in the primary mapping file

Bug

• [SEURAT-319] - Local Substructure Search columns do not remain deleted when job re-executed from scratch.
• [SEURAT-320] - Assay Data by Chemical Lot - Export to CSV sometimes throws a NPE.
• [SEURAT-327] - Organize Table Bug: Coulmns in beginning do not always have the most data - bug with duplication of data? (see SUPPORT-563)
• [SEURAT-328] - Renaming column headers then adding addtitional columns results in duplicated added column entries in saved jobs.
• [SEURAT-329] - Hide row(s), add row(s) -- hidden row(s) reappear even though the status shows hidden rows, unhide hidden row(s) via View > Hidden Rows, result is that you get duplicates of the row(s) that were hidden
• [SEURAT-330] - Add Corporate ID rows results in duplicated data entries in added columns
• [SEURAT-335] - Queries combining Assay Name and Project Name give Null Pointer Exception (see SUPPORT-624)
• [SEURAT-338] - Exports to CSV and SD files choke when there are negative endpoints
• [SEURAT-356] - syn_assay_protocol_info_query has revealed improper handling of CLOB data in SYN_DBConstants
• [SEURAT-357] - Add column after load csv file into job fails due to Databases To Search not being set to a default val. Prop calcs also fail even if db set
• [SEURAT-361] - Assay Display Redraw Issue - Median calc throws exception if mix of qualitative and quantitative values in same column.
• [SEURAT-363] - The QuickSearch dbs_to_search combobox can list a database that does not exist in the text area
• [SEURAT-364] - Export to Excel - Micro character converted to character 5 when export to excel
• [SEURAT-365] - Assay Display (and possibly ResultDisplay) does not popup column header menu on Macintosh
• [SEURAT-366] - NullPointerException when trying to hide Corporate ID or Compound Structure columns.
• [SEURAT-369] - StringIndexOutOfBoundsException in DatabaseForm
• [SEURAT-371] - syn_auth_advanced_file xs:schemaLocation references URLs that cannot be accessed at some sites. Use location classpath instead.
• [SEURAT-373] - Add Property with throw an ArrayIndexOutOfBoundsException if there is no structure record for a compound.
• [SEURAT-375] - NullPointerException when running cached jobs with substructure searches using JChem 5.2.4

Previous Versions