Memo field is not working properly | Community
Skip to main content
santhoshsrg
Level 4
Jun 27, 2019 7:45 AM UTC
Solved

Memo field is not working properly

Hi,

I have a memo field "Description" in my custom schema. I wanted to display this field in my delivery.

I added this field in Query activity using "Add data" option.

But the field is not moving to next transition. I didn't get any error too.

Vapsy​, hillaryc26951904​, pierrec70731455​, Jean-Serge Biron​, guillermoL​ Kindly provide your feedback.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    santhoshsrgAccepted solution
    Level 4
    Jul 12, 2019 8:12 AM UTC

    I was trying to store a long text field. So I used memo data type.

    Later i tried String type with length = 2000 for field Description. This worked fine for me.

    View reply

    7 replies

    santhoshsrgAuthorAccepted solution
    Level 4
    Jul 12, 2019 8:12 AM UTC

    I was trying to store a long text field. So I used memo data type.

    Later i tried String type with length = 2000 for field Description. This worked fine for me.

    Translate
    santhoshsrgAuthor
    Level 4
    Jul 11, 2019 12:52 PM UTC

    How do i declare XML type fields?

    Do XML fields have any restriction on the size? (Like String - 255)

    @pierrec70731455 Could you please share examples?

    Translate
    SurabattulaSr
    Level 6
    Jul 1, 2019 6:11 AM UTC

    Hello,

    You cannot access memo field from Query (Additional Data) since it is not a SQL Field. You can fetch it in the Data Extraction activity where you can able to view it in Display Target (or) directly in the Script tab of the Recurring Delivery if your schema is linked to Delivery schema.

    Regards,

    Sri Bhargav

    Translate
      pierrec70731455
      pierrec70731455
      Level 4
      Jun 28, 2019 8:13 AM UTC

      Hi,

      I don't think you can display a memo since it is not an SQL field but an XML one.

      you need to use some method like Substring(MyMemo,0,255)

      Kind regards,

      Pierre

      Translate
        santhoshsrgAuthor
        Level 4
        Jun 28, 2019 6:38 AM UTC

        Is there any workaround for this bug in Adobe Campaign? pierrec70731455​Vapsy​ hillaryc26951904​ Jean-Serge Biron​ florentlb​

        Translate
        santhoshsrgAuthor
        Level 4
        Jun 27, 2019 9:50 AM UTC

        Adding fields Disclaimer and Intro Feature memo fields in Query Activity

        I have selected "Display target" option on the outbound query transition. I got the below result, memo fields are missing.

        Vapsy, hillaryc26951904, pierrec70731455, Jean-Serge Biron, guillermoL Kindly provide your feedback.

        Translate
        pierrec70731455
        pierrec70731455
        Level 4
        Jun 27, 2019 7:55 AM UTC

        Hi,

        can you provide some printscreens plz?

        Kind regards,

        Pierre

        Translate
          Terms & ConditionsAccessibility statement

          Loading footer...