• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 295
  • 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?
0
Unionblitz
Asked:
Unionblitz
  • 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.
0
 
UnionblitzAuthor Commented:
Finding this answer took several hours of aggravation.  I hope it helps the community.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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