Power Platform Community Forum Thread Details

Hi all,

I'm working on a project where I need all the accounts from the table account that match the follow selection:

- Lastvisitdate > older then 320 days AND has the same month number as the current month number

- Servicelevel = Email

This works fine with this FetchXML action, except the red part. I don't know how to achieve this. I want this all in one action and not set an extra condition or something like that.

Does anyone knows how to achieve that?

My current FetchXML:

<fetch version="1.0" output-format="xml-platform" mapping="logical" no-lock="false" distinct="true">
<entity name="account">
<attribute name="entityimage_url"/>
<attribute name="parentaccountid"/>
<attribute name="name"/>
<attribute name="address1_city"/>
<order attribute="name" descending="false"/>
<attribute name="primarycontactid"/>
<attribute name="telephone1"/>
<attribute name="accountid"/>
<filter type="and">
<condition attribute="statecode" operator="eq" value="0"/>
<condition attribute="xxx_servicelevel" operator="eq" value="115670000"/>
<condition attribute="xxx_lastvisitdate" operator="olderthan-x-days" value="320"/>
</filter>
<link-entity alias="accountprimarycontactidcontactcontactid" name="contact" from="contactid" to="primarycontactid" link-type="outer" visible="false">
<attribute name="emailaddress1"/>
</link-entity>
<attribute name="xxx_servicelevel"/>
<attribute name="xxx_lastvisitdate"/>
</entity>
</fetch>

Categories:

General topics