• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • Last Modified:

Microsoft Commerce Server Query Issue

(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?
  • 2
1 Solution
UnionblitzAuthor Commented:
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.
UnionblitzAuthor Commented:
Finding this answer took several hours of aggravation.  I hope it helps the community.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now