List of functions | Community
Skip to main content
J
jael91407431
Level 3
September 18, 2017
Solved

List of functions

  • September 18, 2017
  • 4 replies
  • 5247 views

Hi,

What language does the Adobe Campaign's "List of Functions" use?

...and where can I go to learn this language? Adobe Campaign documention lists these functions, but they give you scant information on how to learn the language to develop them.

Thank you.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by florentlb

    Hi,

    13 and 6 here mean that the substring function will extract 6 characters from the 13th one in the string passed as 1st parameter of the function.

    Best thing is to try it out and fine tune it over time.

    Hope this helps,

    Florent

    4 replies

    vraghav
    Adobe Employee
    vraghavAdobe Employee
    Adobe Employee
    September 19, 2017

    Hi Jae,

    These functions are just wrappers on top of underlying RDMS functions. Yes, there is let documentation available around it but the best way is trial and error.

    Use these functions and learn what they do exactly in Adobe Campaign.

    Regards,
    Vipul

      Jean-Serge_Biro
      Jean-Serge_Biro
      Level 10
      September 19, 2017

      Hi Jael,

      The only documentation is:

      https://docs.campaign.adobe.com/doc/AC/en/PTF_Creating_queries_Methodology.html


      These SQL functions are written in the database underlying language code, and you can find them all in the Adobe Campaign folder node:

      Administration>Settings>SQL Script.

      Select your own Database system (mySql, Postgres, SQL Server, Oracle, etc) to see how the functions listed are written in the underlying DB engine language (T-SQL for SQL Server, PL/SQL for Oracle, etc).

      And one very efficient way to learn quickly is to display the generated SQL query (SQL query link, at the bottom of the form) when you define the Query through the UI, especially for date manipulation, it is easier.

      Regards.
      Jean-Serge

        brandonkern
        brandonkern
        Level 2
        November 4, 2020
        The page you specified no longer exists. The files you point to do not cover all the functions listed. For example FormatCurrency (<number>, <currency>) What are the values that are valid for <currency>? I have triedn US, us, en-us, C0 etc
        J
        jael91407431Author
        Level 3
        September 19, 2017

        Thank you guys, I will follow your advice and peruse the resources you mentioned.

        To follow up, I had created this function, Substring([contact_history_vw/@mktg_promo_cell_key], 13, 6), for the following formula: Substr(MKTG_PROMO_CELL_KEY, 13,6).

        The expression is expressed in Adobe Campaign as, "sub string of mktg_promo_cell_key for ita_contact_history_vw starting at offst 13 of length 6":

        Not having access to the actual data field, "MKTG_PROMO_CELL_KEY,"  assuming that the values are CHAR, what does, "starting at offset 13 of length 6" mean?

        Is this correct Substring function for the query formula, "Substr(MKTG_PROMO_CELL_KEY, 13,6)"?

        Thank you.

        florentlb
        florentlbAccepted solution
        Level 10
        October 10, 2017

        Hi,

        13 and 6 here mean that the substring function will extract 6 characters from the 13th one in the string passed as 1st parameter of the function.

        Best thing is to try it out and fine tune it over time.

        Hope this helps,

        Florent

        Terms & ConditionsAccessibility statement

        Loading footer...