Wish list table name

[amyschlosser]

Does anyone know the name of the table where Wish List information is stored?  We need to create a notification to trigger a notification to remind users of items in their wish list, but I am not finding a table with "wish" in the name.

[brendanwilson84]

Hi

amyschlosser

sc_wishlist_cart

[IanGlencross]

Hi Amy,

"WishList" is a part of the sc_cart, which have the cart items in the table sc_cart_item

the carts have a special name "saved_items"

To find wish list items :

var gr = new GlideRecord("sc_cart_item");             // open a gliderecord for sc_cart_item

gr.addEncodedQuery("cart.user=c4a426d60f223200e77d943be1050e17^cart.name=saved_items")   // wish lists are actually carts named "saved_items"    

// i have also shown how to filter for a user if required

gr.query();

This will return a list of items in the wishlist(s)

Hope this helps

Ian

[NS16]

Hi @amyschlosser 

Did you get solution for this?

How you sent notification to user? How did you get user from sc_cart_item table

Thanks,

NS