Share
Report
70I'm trying to get a list of contacts where the Account (Company name) they belong to has a particular dealer brand record (custom) and they don't have a internal id (custom) record with a certain product. I can't figure out how to get it to show those that have an internal id with a different product or they don't have a internal id record at all.
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true" >
<entity name="contact" >
<attribute name="fullname" />
<attribute name="telephone1" />
<attribute name="contactid" />
<order attribute="fullname" descending="false" />
<filter type="and" >
<condition attribute="statecode" operator="eq" value="0" />
<condition attribute="emailaddress1" operator="not-null" />
</filter>
<link-entity name="account" from="accountid" to="parentcustomerid" link-type="inner" alias="aa" >
<link-entity name="lvp_dealerbrand" from="new_dealerid" to="accountid" link-type="inner" alias="ab" intersect="true" >
<filter type="and" >
<condition attribute="lvp_brand" operator="eq" uiname="Brand1" uitype="lvp_brand" value="{22040AB5-6FFF-E611-80EE-C4346BAD8294}" />
</filter>
</link-entity>
<link-entity name="tec_internalid" from="tec_account" to="accountid" link-type="outer" alias="ac" intersect="true" >
<filter type="and" >
<condition attribute="tec_product" operator="ne" uiname="Product1" uitype="product" value="{5836F9B1-341C-E611-80E6-6C3BE5A878BC}" />
</filter>
</link-entity>
</link-entity>
</entity>
</fetch>
Is what i'm trying to do possible?
*This post is locked for comments
All responses (
Answers (
