Hi supratim320, thanks for the response.
Unfortunately, that is not the answer I was looking for. I'm aware I can specify keys, but they must be exact keys. In the case of the sequence number, that does not work, because the previous sequence number is unknown. Instead, the record should be updated if new sequence number is greater than previous, so the request should look something like this:
xtk.session.WriteCollection(
<recipient-collection xtkschem="nms:recipient">
<recipient key="@customerId" customerId="123" field="aa" sequenceNumber="123">
<where>
<!-- condition to check if new sequence number is greater that old sequence number-->
</where>
</recipeint>
</recipient-collection>
)
Obviously, that is not the right syntax, so I'm looking for a correct one.
No, I understand, I can find current sequence number for each customer using xtk.queryDef, but even then I cannot update it, because if insertOrUpdate statement is used, the keys cannot be changed. They are used to actually find the record, so there is no way to provide new values to them.