Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Disctinct in advanced find ??

0 views
Skip to first unread message

CRM master

unread,
Nov 23, 2009, 3:17:22 AM11/23/09
to
Hi

I have a solution in which an advanced find query gives distinct true and in
another where I do the same query it's discinct false, how can this be ?

Here is the results from the fetch in the advanced find

---------------------------
Message from webpage
---------------------------
<fetch version="1.0" output-format="xml-platform" mapping="logical"
distinct="false"><entity name="account"><attribute name="name"/><attribute
name="address1_city"/><attribute name="primarycontactid"/><attribute
name="telephone1"/><attribute name="accountid"/><order attribute="name"
descending="false"/><link-entity name="contact" from="parentcustomerid"
to="accountid" alias="aa"><filter type="and"><condition
attribute="createdon"
operator="not-null"/></filter></link-entity></entity></fetch>
---------------------------
OK
---------------------------


---------------------------
Windows Internet Explorer
---------------------------
<fetch version="1.0" output-format="xml-platform" mapping="logical"
distinct="true"><entity name="account"><attribute name="name"/><attribute
name="address1_city"/><attribute name="primarycontactid"/><attribute
name="telephone1"/><attribute name="accountid"/><order attribute="name"
descending="false"/><link-entity name="contact" from="parentcustomerid"
to="accountid" alias="aa"><filter type="and"><condition
attribute="createdon"
operator="not-null"/></filter></link-entity></entity></fetch>
---------------------------
OK
---------------------------

CRM master

unread,
Nov 23, 2009, 5:48:25 AM11/23/09
to
Hi

The problem was that accountid was not set to searchable on the attribute, a
tricky one :)

/Jack

"CRM master" <ja...@jackd.dk> skrev i meddelelsen
news:ECF53C80-A5D5-494C...@microsoft.com...

0 new messages