- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hello @tejashriw155148
Can you try with this code?
var companyPartId = ctx.recipient.@partyPartId;//ctx.recipient.@partyPartId;
var sppId = ctx.recipient.@soleProprietorPartId;
var query=xtk.queryDef.create(
<queryDef schema="nms:broadLogRcp" operation="select" >
<where>
<condition boolOperator="OR" expr="[recipient/@soleProprietorPartId] = '" + sppId + "'" />
<condition expr="[recipient/@partyPartId] = '" + companyPartId + "'"/>
</where>
<select>
<node expr="[delivery/@messageType]"/>
<node expr="@address" />
<node expr="@status"/>
<node expr="[delivery/@label]"/>
<node expr="[recipient/@soleProprietorPartId]"/>
<node expr="[delivery/content/sms/@source]" />
<node expr="[delivery/@deleteStatus]"/>
<node expr="[delivery/@lastModified]" />
<node expr="[delivery/@id]" />
<node expr="@eventDate" />
<node expr="[@recipient-id]"/>
</select>
</queryDef>
).ExecuteQuery();
Let me know if that works.
Views
Replies
0 Likes
Total Likes