Match web application url id with two columns
Hello @tejashriw155148 ,
To make this work, Change your where statement to
where: {
condition:[
{boolOperator: "OR",expr: "[@tempCompanyPartId] = " + companyPartId },
{expr: "[@soleProperiterPartId] = " + soleProperiterPartId}
]
},
OR
where: {
condition:[
{boolOperator: "OR",expr: "[recipient/@tempCompanyPartId] = " + companyPartId },
{expr: "[recipient/@soleProperiterPartId] = " + soleProperiterPartId}
]
},
i am not sure about the xpath of these fields in your table. So you might have to change the xpath as per your table structure.
Let me know if that helps.
Thanks
Did you check the xpath. If you are querying the BroadLogRcp and want put a columns from recipient in where condition then the xpath of the where condition will look something like this [recipient/@COLUMN_INTERNAL_NAME]. But you are directly checking the column name without referencing the recipient table.
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.
Related Conversations
