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
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
No comments:
Post a Comment