Task #802
MSS Duplicate Category Name
Status: | Work Completed-End life cycle | Start date: | March 08, 2011 | |
---|---|---|---|---|
Priority: | Normal | Due date: | March 08, 2011 | |
Assignee: | Nor Shuhaida Subri | % Done: | 100% | |
Category: | - | Spent time: | - | |
Target version: | - |
Description
Mazun reported that in MSS, they can create categories with the same name (attached)
They want MSS to not do this.
History
#1 Updated by Nor Shuhaida Subri over 13 years ago
- Status changed from New - Begin Life Cycle to Internal Testing
- Assignee changed from Nor Shuhaida Subri to Hafizudin MD
Add constraint inside table IB_CONTENT_CATEGORY
ALTER TABLE IB_CONTENT_CATEGORY ADD (
CONSTRAINT IB_CONTENT_CATEGORY_U01
UNIQUE (CONTENT_TYPE_ID, CATEGORY_NAME));
Hi Hafiz,
Clone this project: https://hub.penril.net/hg/maybank/mpi/MSS
Test the MSS Create Content Category with this new database:
Replace the existing inside hibernate.cfg.xml
<property name="hibernate.connection.url">jdbc:oracle:thin:@219.95.244.226:1521:TESTDB</property>
<property name="hibernate.connection.username">SCEMA1</property>
<property name="hibernate.connection.password">password</property>
Replace the existing inside UPassClient.xml
WSDL=http://219.95.244.227:7001/wsUpassTemp/services/WS_UPass?wsdl
Step to test:
1. login to MSS using this username and password penril123/P@ssw0rd5
2. Go to Site Management tab > Choose BANCNET/BANKBRANCH/PRODUCTTYPE/CURRENCYCODE/PAYE/SERVICEINFO
3. Create existing Category
"MPI" and "mpi" is different
So, user can add "MPI" and "mpi" inside the same category.
#2 Updated by Hafizudin MD over 13 years ago
- Status changed from Internal Testing to Development / Work In Progress
- Assignee changed from Hafizudin MD to Nor Shuhaida Subri
Tested by hafiz
Status : failed
bug report
1) need to remove space at the end ("MPI" & "MPI ") when create category.
2) can add special character other than space
#3 Updated by Nor Shuhaida Subri over 13 years ago
- Status changed from Development / Work In Progress to Pending Customer Feedback
- % Done changed from 0 to 100
trim the Category Name.
#4 Updated by Nor Shuhaida Subri over 13 years ago
- Status changed from Pending Customer Feedback to Work Completed-End life cycle