Microsoft Commerce Server Query Issue

Posted on 2011-10-11
Last Modified: 2012-05-12
(For Microsoft Commerce Server 2009)

I have a User Profile with a property called, "Pets", which is mapped to a Pets Profile.  

When I query the User Profile, it is only returning one Pets object, when it should be returning 3 Pets objects.  

Can you think of what could be causing the query to only return one object back?
Question by:Unionblitz

    Accepted Solution

    I figured it out...

    In Commerce Server, When you create a custom profile, you need to create a custom processor.  The custom processor inherits RelatedProfileProcessorBase, which has an abstract string property called "CommercePreferredIdKeyName".  This property is used in the underpinnings of the commerce server.  If the property is set to a property in the parent profile (e.g. "GeneralInfo.pet_list"), it will limit the results to the first record in the list.

    I ended up returning a blank string in the override property, which in turn returned back the complete set.

    Author Closing Comment

    Finding this answer took several hours of aggravation.  I hope it helps the community.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Are you using email marketing software? If not, you're missing out on effortless marketing and the reaching of desired conversion rates through email marketing software.
    Every business owner understands the significance of online customer reviews and the impact it can have on sales and revenues. With technology advancing at such a rapid pace, getting online reviews has never been easier, especially when many regions…
    Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now