Compute SMS content length

Avatar

Avatar

AC31271896

Avatar

AC31271896

AC31271896

21-02-2019

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.

  <container colcount="2" colspan="2" type="visibleGroup" visibleIf="[/tmp/sms/preview/@length] &gt; 160">

                  <static/>

                  <static img="xtk:logwarn.png" label=" " nolabel="true">The content for this recipient exceeds the maximum SMS size of 160 characters.</static>

    </container>

How do I get access to [/tmp/sms/preview/@length] field via query activity so I can get the list of all SMS deliveries which has more than 160 chars??

Thanks.

View Entire Topic

Avatar

Avatar

AC31271896

Avatar

AC31271896

AC31271896

24-02-2019

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:

1698263_pastedImage_1.png

Is there something I missed?

Thanks.