EBMS Tickets

Issue Number 171
Summary [Literature] Screening & Prevention Reviewed Packets Not Sorting Correctly
Created 2014-03-20 10:28:19
Issue Type Bug
Submitted By Juthe, Robin (NIH/NCI) [E]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2014-06-24 15:56:12
Resolution Fixed
Path /home/bkline/backups/jira/oceebms/issue.120174
Description

Val's packets are not sorting correctly in alphabetical order. We noticed that the names of her summary topics were all in a old format (e.g., Prevention of Breast Cancer as opposed to Breast Cancer Prevention) so this may contribute to the problem. I renamed all of her topics to list the cancer name first, but I'm not sure if that helped at all. For example, Breast Cancer Prevention is still showing up at the top of her list of reviewed packets and about half way down when she sorts on the packet name.

Each of the other Boards' topics are sorting correctly.

Comment entered 2014-03-20 10:30:54 by Juthe, Robin (NIH/NCI) [E]

Adding Val to this issue.

Comment entered 2014-05-27 09:20:32 by Kline, Bob (NIH/NCI) [C]

The Reviewed Packets list defaults to sorting by the "Updated" column - most recent updates first, with options to switch the sort to reviewer or packet name.

Comment entered 2014-05-29 11:08:28 by Juthe, Robin (NIH/NCI) [E]

This behavior is happening when Val sorts on Packet name.

Comment entered 2014-06-04 14:04:14 by Kline, Bob (NIH/NCI) [C]

The first 23 of the packets on her "Reviewed Packets" page have a leading space in the packet name. All of these sort in front of everything else.

Comment entered 2014-06-04 14:07:29 by Kline, Bob (NIH/NCI) [C]

Here are the packets with leading spaces.

Comment entered 2014-06-24 11:48:35 by mcauliffehl

Per our conversation, please look into trimming the leading & trailing spaces to prevent this from happening in the future.

Comment entered 2014-06-24 14:40:23 by Kline, Bob (NIH/NCI) [C]

Looks like we're already doing that, as of last September. I created an SQL script to clean up the data and gave it to the DBA team.

Comment entered 2014-06-24 15:34:44 by Juthe, Robin (NIH/NCI) [E]

Val removed the leading spaces from each of the packets listed in the attachment and that corrected the sorting problem.

Comment entered 2014-06-24 15:55:10 by Kline, Bob (NIH/NCI) [C]

My script fixed the other 44 with leading and/or trailing whitespace.

Comment entered 2014-06-24 15:56:12 by Kline, Bob (NIH/NCI) [C]

Fixed after all.

Attachments
File Name Posted User
2014-06-04 14_05_54-Source of_ https___ebms-dev.nci.nih.gov_review_reviews_sort=asc&order=Packet%20N.jpg 2014-06-04 14:07:29

Elapsed: 0:00:00.000306