- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
<where filterName="backGroundFilterFrm" filteringSchema="nms:recipient" id="13601463290">
<condition boolOperator="OR" expr="subscription" internalId="1360146501" setOperator="NOT EXISTS">
<condition boolOperator="AND" expr="@yrOptinTypeID = 2" internalId="1360146504"/>
<condition boolOperator="AND" expr="[@service-id] IN (1127232 , 1127236)" internalId="1360146507"/>
<condition expr="@yrConsentTypeID = 2" internalId="1360146510"/>
</condition>
<condition boolOperator="OR" expr="subHisto" internalId="1360146573" setOperator="EXISTS">
<condition boolOperator="AND" setOperator = "IN" expr="@created" internalId="1360146628">
<subQuery schema="nms:subHisto">
<select>
<node expr="Max([@date])" />
</select>
<where>
<condition expr="[@service-id]=1127236"/>
</where>
<groupBy>
<node expr="[@recipient-id]"/>
</groupBy>
</subQuery>
</condition>
<condition boolOperator="AND" expr="@action = 0" internalId="1360146796"/>
<condition boolOperator="AND" expr="[@service-id]=1127236" internalId="1360146883"/>
<condition expr="@yrConsentTypeID = 1" internalId="1360146898"/>
</condition>
</where>
it should work.