Get product name and ratings in transformation of Wishlist web part

Iman Emran asked on February 3, 2016 15:11

Hello,

I want to get product name and ratings in transformation of Wishlist web part with Eval("DocumentName") and EvalDouble("DocumentRatings") but both of them return null value!?

How can I get their values in transformation of Wishlist web part?

Thanks.

Recent Answers

Brenden Kehren answered on February 3, 2016 15:33

Are both those columns available in the dataset being returned? Or have you specified those columns in the columns property if there is one? You can check this by going to System>Debug and looking at the SQL queries being run after turning on Debug in Settings.

0 votesVote for this answer Mark as a Correct answer

Iman Emran answered on February 3, 2016 21:29

Hi Brenden,

I checked the Wishlist web part and related SQL Query which is: SELECT * FROM COM_SKU WHERE [SKUID] IN (SELECT [SKUID] FROM COM_Wishlist WHERE [SiteID] = @SiteID AND [UserID] = @UserID)

and the default wishlist web part code behind for binding data is:

if ((currentUser != null) && (currentSite != null))
{
    repeater.DataSource = SKUInfoProvider.GetWishlistProducts(currentUser.UserID,currentSite.SiteID).TypedResult;
    repeater.DataBind();    
}

so both those columns aren't available in the dataset being returned.

Now how can I get DocumentName and DocumentRatings in this transformation?

0 votesVote for this answer Mark as a Correct answer

Iman Emran answered on February 5, 2016 13:55

Nobody can help me anymore?

0 votesVote for this answer Mark as a Correct answer