Hi,The problem is not with the update query at all. Its with this
line((res.@content + '').length) which is not calculating length
properly and is outputting zero (0) when I expect 160 or more. Hence,
its not going in "IF" loop.
Thanks Jon for being patient with me so far. Really appreciate your
help.I've tried putting it into array and then slice it afterwards, It
ran all fine this time. However, the iValue column is still not updated
to 1.The trouble here is - This statement " if ((res.@content +
'').length > 160)" is resulting length zero (0), hence the complete if
condition is not getting executed as its checking for > 160. Is it
because of res.@content is not getting stored in query result variable
as its an XML fi...
Thanks very much Jon. Appreciate your help & prompt response.I did try
your suggestion and selected the @id column now and got rid of the other
columns from , but unfortunately it didn't work this time too.
Here is my JS:When I tried to log the length of the content
logInfo('length is : ' + smsLen), it displayed 0 in there and not going
in the "If" condition at all to update the 0's to 1's.Could you please
Hi Jon,Thanks so much for your response. I did try your suggestion, but
unfortunately it's still not working . Here is what I did:Added 2
columns. One with content of the SMS and one with value 0.Here is how my
JS looks like where I'm reading @content & @value from the temp table
and try to logInfo "new value" which should print 1 in the workflow
journal logs. In workflow logs, it successfully prints value 0 which
means it's reading successfully from the temp table. When I run the
Thanks Jon for your prompt response. Really appreciate it.I tried using
this expression for nms:delivery schema. However, it gave me this
error:25/02/2019 12:15:33 QUE-370015 The node of path
'/contentDef/source' is not stored as an independent SQL field (document
of type 'Deliveries (nms:delivery)'). Unable to use it as a filtering
criteria in a query.Here is how I used this expression:Is there
something I missed?Thanks.
Hi,I am looking to look for those SMS deliveries/delivery template
through-out the AC instance where the content of the SMS exceeds 160
characters and I would want a list of all those campaigns exported.I had
a look at the delivery form and figured that while trying to preview any
SMS delivery, it calculates the length and display the message if it
exceeds more than 160 characters.
content for this recipient exceeds the maximum SMS size of 160
characters. How do I get access to