Task #802

MSS Duplicate Category Name

Added by Nor Shuhaida Subri over 13 years ago. Updated over 13 years ago.

Status:Work Completed-End life cycleStart date:March 08, 2011
Priority:NormalDue 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.

mss.png (18.9 KB) Nor Shuhaida Subri, March 08, 2011 10:29

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

Also available in: Atom PDF