DataObject for Notification:
<WritableDataObject>
<Tables>
[AaaUser, NotificationContent] </Tables>
SelectQuery Object:
Select columnNames=[NotificationContent.NOTIFICATIONCONTENTID, NotificationContent.NOTIFICATIONTYPE, NotificationContent.SUBJECT, NotificationContent.CONTENT, NotificationContent.ISENABLED, NotificationContent.ESCALATETOID, NotificationContent.MODULE, NotificationContent.DISPLAYNAME]
Criteria=(NotificationContent.NOTIFICATIONTYPE = 'BusinessRule_EMail_1505')
Number of Objects=0
Starting row=1
Order by columnNames=[]
Table List=[NotificationContent AS NotificationContent]
Joins=
SetLock= false
<JoinsInDO>
Join := AaaUser AS AaaUser INNER JOIN EscalateToN AS EscalateToN ON AaaUser.USER_ID=EscalateToN.USERID
</JoinsInDO>
<Operations>
</Operations>
<Rows>
<AaaUser USER_ID="133201" FIRST_NAME="Jeroen" MIDDLE_NAME="null" LAST_NAME="null" CREATEDTIME="1446041213322" DESCRIPTION="" />
<NotificationContent NOTIFICATIONCONTENTID="7509" NOTIFICATIONTYPE="BusinessRule_EMail_1505" SUBJECT="Business rule $BusinessRuleName applied on request $Title" CONTENT="Dear Technician<br /><br />Business rule $BusinessRuleName has been applied on request $Title. The request attributes are updated as specified in the Business rule actions.<br /><br />Thanks<br />$ProductName" ISENABLED="true" ESCALATETOID="6609" MODULE="Request" DISPLAYNAME="null" />
</Rows>
</WritableDataObject>