Support #4211
[Request ID :##2183##] : BII-RIB: SKN/RTGS: To Properly Sort The Bank List
Status: | Closed - End of life cycle | Start date: | March 16, 2014 | |
---|---|---|---|---|
Priority: | Normal | Due date: | March 16, 2014 | |
Assignee: | Rayvandy Gabbytian | % Done: | 100% | |
Category: | - | Spent time: | 3.50 hours | |
Target version: | - |
Description
Reported by Pak Thomas/Bu Made that the bank list is not sorted properly. Report as attached.
History
#1 Updated by Rayvandy Gabbytian over 10 years ago
- Status changed from New - Begin Life Cycle to System Integration Test
#2 Updated by Rayvandy Gabbytian over 10 years ago
- Due date set to March 13, 2014
#3 Updated by Rayvandy Gabbytian over 10 years ago
- Due date changed from March 13, 2014 to March 16, 2014
- Status changed from System Integration Test to Development / Work In Progress
- Start date changed from March 13, 2014 to March 16, 2014
- % Done changed from 0 to 100
Case re-opened based on report by Pak Wahyu via phone today:
Problem:
Bank list still not "naturally" sorted
Root cause:
System stores the sorting number based on varchar (string) not numeric (decimal)
Solution:
Change the sknTopTen inside DBO.IB_BANCNET_LIST to decimal with 3 digit length.
This changes affect:
- ibsscore
- bii-rib
- bii-admin
#4 Updated by Rayvandy Gabbytian over 10 years ago
- Status changed from Development / Work In Progress to System Integration Test
- % Done changed from 100 to 0
#5 Updated by Rayvandy Gabbytian over 10 years ago
This change also affect database. SQL script is as per attached.
#6 Updated by Ahmad Hazri over 10 years ago
- Subject changed from BII-RIB: SKN/RTGS: To Properly Sort The Bank List to [Request ID :##2183##] : BII-RIB: SKN/RTGS: To Properly Sort The Bank List
#7 Updated by Ahmad Hazri over 10 years ago
- Tracker changed from Task to Support
#8 Updated by Zahir Abd Latif about 10 years ago
Dear Gabbytian,
Any updates on this case? please help to follow up with to see we closed this case or update the status.
Thanks.
#9 Updated by Zahir Abd Latif almost 10 years ago
- Status changed from System Integration Test to Closed - End of life cycle
- % Done changed from 0 to 100