Wish list in WCS

Websphere commerce wish lists are stored in IITEMLIST table.
Items in the wish list are in IITEM table.

Query to list all wishlists by registered users

select IITM.STOREENT_ID, count(distinct ITMLST.IITEMLIST_ID) as NoOfWishLists from IITEMLIST ITMLST, IITEM IITM,USERS USR, STOREENT ST where IITM.IITEMLIST_ID = ITMLST.IITEMLIST_ID and IITM.MEMBER_ID=USR.USERS_ID and USR.REGISTERTYPE = 'R' group by IITM.STOREENT_ID

Maven Projects in Rational application developer.

To work or import maven projects in rational application developer. We need to first activate some apache features and then install maven plugin. Here are steps..

1. Add http://q4e.googlecode.com/svn/trunk/updatesite-iam/ site and Select only Enabling Features option to install.

2. After successful installation restart RAD

3. Add http://m2eclipse.sonatype.org/sites/m2e-e34/ site. it might not show plugin in first go. Just say refresh.

4. Select maven eclipse integration plugin and install.

5. Restart RAD and you ready to import maven projects in RAD.