- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Something like this??
Query the Recipient tracking logs (nms) nms trackingLogRcp
Here is the XML configuration of the activity
<query collision="0" distinct="true" img="nms:activities/query.png" keepAllExtraData="false"
label="undefined" mask="0" name="queryCountURL" noAutoPk="true" noAutoPkFilter="0"
onError="0" recipientLink="" runOnSimulation="true" schema="nms:trackingLogRcp"
timezone="_inherit_" useSource="0" x="520" y="80">
<transitions>
<result enabled="true" label="Result" name="result" x="670" y="104"/>
</transitions>
<select>
<node alias="@recipient" analyze="false" expr="[@recipient-id]" groupBy="1"
label="recipient"/>
<node alias="@count" analyze="false" expr="count([url/@type])" groupBy="0"
label="Count"/>
<node alias="@urlType" analyze="false" expr="[url/@type]" groupBy="1" label="Type (Url)"/>
</select>
<where displayFilter="undefined" filterName="backGroundFilterFrm" id="1663107605"/>
<outputFilter displayFilter="count greater than 2 and type (Url) equal to Open">
<condition boolOperator="AND" compositeKey="" dependkey="" enabledIf="" expr="@count > 2"
internalId="1733493285"/>
<condition compositeKey="" dependkey="" enabledIf="" expr="@urlType = 2"
internalId="1742864937"/>
</outputFilter>
<humanCond>Query: undefined</humanCond>
</query>