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

04-03-2019

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.

1704372_pastedImage_0.png

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.

1704373_pastedImage_1.png

In workflow logs, it successfully prints value 0 which means it's reading successfully from the temp table.

1704374_pastedImage_2.png

When I run the workflow again, I expect the value 1 in the logs to be printed for all the records, but it doesn't do anything and fails with this error:

05/03/2019 17:38:03                Automatically resuming workflow (number of consecutive times: 2).

05/03/2019 17:37:03                Automatically resuming workflow (number of consecutive times: 1).

Could you please let me know if Anything I missed here?

Thanks