<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: JavaScript Functions in Expression Editor in Adobe Campaign Classic Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/javascript-functions-in-expression-editor/m-p/424494#M13106</link>
    <description>&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="6532776"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;File path : &lt;STRONG&gt;&amp;lt;Campaign_Installed_location&amp;gt;\datakit\xtk\eng&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;File Name:&amp;nbsp;&lt;STRONG&gt;funcList.xml&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;- Malarrajan Sundarraj&lt;/P&gt;</description>
    <pubDate>Wed, 22 Sep 2021 17:18:06 GMT</pubDate>
    <dc:creator>Malarrajan_Sundarraj</dc:creator>
    <dc:date>2021-09-22T17:18:06Z</dc:date>
    <item>
      <title>JavaScript Functions in Expression Editor</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/javascript-functions-in-expression-editor/m-p/424248#M13090</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;I would like to know where the js functions present in expression editor in workflows are defined. Need to look into some OOTB functions.&lt;/P&gt;&lt;P&gt;I could find some sql functions in Admin-&amp;gt;Config-&amp;gt;SQL that corresponds to the js functions, but couldn't locate the js function definition.&lt;/P&gt;&lt;P&gt;Any help/hint is appreciated.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks,&lt;/P&gt;&lt;P&gt;Deb&lt;/P&gt;</description>
      <pubDate>Tue, 21 Sep 2021 13:04:10 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/javascript-functions-in-expression-editor/m-p/424248#M13090</guid>
      <dc:creator>Deb_Tripathy</dc:creator>
      <dc:date>2021-09-21T13:04:10Z</dc:date>
    </item>
    <item>
      <title>Re: JavaScript Functions in Expression Editor</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/javascript-functions-in-expression-editor/m-p/424285#M13093</link>
      <description>&lt;P&gt;Hello&amp;nbsp;&lt;LI-USER uid="6532776"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;You can find them under Admin&amp;gt;config&amp;gt;javascript codes&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 21 Sep 2021 16:00:40 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/javascript-functions-in-expression-editor/m-p/424285#M13093</guid>
      <dc:creator>Manoj_Kumar_</dc:creator>
      <dc:date>2021-09-21T16:00:40Z</dc:date>
    </item>
    <item>
      <title>Re: JavaScript Functions in Expression Editor</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/javascript-functions-in-expression-editor/m-p/424388#M13095</link>
      <description>&lt;P&gt;By any chance you know the js file name?&lt;/P&gt;&lt;P&gt;I had no luck finding the one.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks,&lt;/P&gt;&lt;P&gt;Deb&lt;/P&gt;</description>
      <pubDate>Wed, 22 Sep 2021 08:05:56 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/javascript-functions-in-expression-editor/m-p/424388#M13095</guid>
      <dc:creator>Deb_Tripathy</dc:creator>
      <dc:date>2021-09-22T08:05:56Z</dc:date>
    </item>
    <item>
      <title>Re: JavaScript Functions in Expression Editor</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/javascript-functions-in-expression-editor/m-p/424392#M13096</link>
      <description>&lt;P&gt;Hi Dev,&lt;/P&gt;&lt;P&gt;which OOB function you are looking for ? Functions definitions are present in database specific files .&lt;/P&gt;&lt;P&gt;For example all postgres related functions are defined inside&amp;nbsp;xtk:postgresql-functions.sql&lt;/P&gt;</description>
      <pubDate>Wed, 22 Sep 2021 08:12:56 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/javascript-functions-in-expression-editor/m-p/424392#M13096</guid>
      <dc:creator>ShrawanSaxena</dc:creator>
      <dc:date>2021-09-22T08:12:56Z</dc:date>
    </item>
    <item>
      <title>Re: JavaScript Functions in Expression Editor</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/javascript-functions-in-expression-editor/m-p/424400#M13097</link>
      <description>&lt;P&gt;I am looking for definition of WeekDay() function.&lt;/P&gt;&lt;P&gt;I couldn't locate that in&amp;nbsp;&lt;SPAN&gt;xtk:postgresql-functions.sql.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;Cheers,&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;Deb&lt;/SPAN&gt;&lt;/P&gt;</description>
      <pubDate>Wed, 22 Sep 2021 08:34:59 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/javascript-functions-in-expression-editor/m-p/424400#M13097</guid>
      <dc:creator>Deb_Tripathy</dc:creator>
      <dc:date>2021-09-22T08:34:59Z</dc:date>
    </item>
    <item>
      <title>Re: JavaScript Functions in Expression Editor</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/javascript-functions-in-expression-editor/m-p/424419#M13099</link>
      <description>&lt;P&gt;Hi Dev,&lt;/P&gt;&lt;P&gt;Let me check on this function definition code .&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Please find below how weekday works:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;WeekDay(date/datetime)&lt;/P&gt;&lt;P&gt;Returns the number of day in the week following the rule: 0=Monday ...&lt;BR /&gt;6=Sunday.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;In case argument is of type datetime - day of the week is calculated from time in client's timezone (timezone is passed to server in query).&amp;nbsp;Otherwise, if argument is of type date, day of the week is calculated in timezone agnostic manner.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Example&lt;/P&gt;&lt;P&gt;WeekDay(#2021-09-22 00:34:56Z#)=2&lt;/P&gt;</description>
      <pubDate>Wed, 22 Sep 2021 09:45:33 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/javascript-functions-in-expression-editor/m-p/424419#M13099</guid>
      <dc:creator>ShrawanSaxena</dc:creator>
      <dc:date>2021-09-22T09:45:33Z</dc:date>
    </item>
    <item>
      <title>Re: JavaScript Functions in Expression Editor</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/javascript-functions-in-expression-editor/m-p/424452#M13103</link>
      <description>&lt;P&gt;Thanks&amp;nbsp;&lt;LI-USER uid="17375764"&gt;&lt;/LI-USER&gt;&amp;nbsp; for your hep.&lt;/P&gt;&lt;P&gt;But did you get this function definition any where in Adobe Campaign, like in any JS or SQL?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Cheers,&lt;/P&gt;&lt;P&gt;Deb&lt;/P&gt;</description>
      <pubDate>Wed, 22 Sep 2021 12:24:22 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/javascript-functions-in-expression-editor/m-p/424452#M13103</guid>
      <dc:creator>Deb_Tripathy</dc:creator>
      <dc:date>2021-09-22T12:24:22Z</dc:date>
    </item>
    <item>
      <title>Re: JavaScript Functions in Expression Editor</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/javascript-functions-in-expression-editor/m-p/424464#M13104</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="6532776"&gt;&lt;/LI-USER&gt;&amp;nbsp;,&lt;/P&gt;&lt;P&gt;The fucntion defination in the back end file. It wont be available in the Client console.&lt;/P&gt;&lt;P&gt;For&amp;nbsp;PostgreSQL:&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;mod(cast(Extract(dow FROM $tz1) as integer)+6, 7) // $tz1 -&amp;gt; Data with timestamp&lt;/PRE&gt;&lt;P&gt;&lt;STRONG&gt;&amp;nbsp;&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;- Malarrajan Sundarraj&lt;/P&gt;</description>
      <pubDate>Wed, 22 Sep 2021 14:35:43 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/javascript-functions-in-expression-editor/m-p/424464#M13104</guid>
      <dc:creator>Malarrajan_Sundarraj</dc:creator>
      <dc:date>2021-09-22T14:35:43Z</dc:date>
    </item>
    <item>
      <title>Re: JavaScript Functions in Expression Editor</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/javascript-functions-in-expression-editor/m-p/424476#M13105</link>
      <description>&lt;P&gt;Thanks&amp;nbsp;&lt;LI-USER uid="17401442"&gt;&lt;/LI-USER&gt;&amp;nbsp;.&lt;/P&gt;&lt;P&gt;At least, It is clear that cant be accessed from console.&lt;/P&gt;&lt;P&gt;May I know the server file name and location?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Cheers,&lt;/P&gt;&lt;P&gt;Deb&lt;/P&gt;</description>
      <pubDate>Wed, 22 Sep 2021 15:43:23 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/javascript-functions-in-expression-editor/m-p/424476#M13105</guid>
      <dc:creator>Deb_Tripathy</dc:creator>
      <dc:date>2021-09-22T15:43:23Z</dc:date>
    </item>
    <item>
      <title>Re: JavaScript Functions in Expression Editor</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/javascript-functions-in-expression-editor/m-p/424494#M13106</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="6532776"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;File path : &lt;STRONG&gt;&amp;lt;Campaign_Installed_location&amp;gt;\datakit\xtk\eng&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;File Name:&amp;nbsp;&lt;STRONG&gt;funcList.xml&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;- Malarrajan Sundarraj&lt;/P&gt;</description>
      <pubDate>Wed, 22 Sep 2021 17:18:06 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/javascript-functions-in-expression-editor/m-p/424494#M13106</guid>
      <dc:creator>Malarrajan_Sundarraj</dc:creator>
      <dc:date>2021-09-22T17:18:06Z</dc:date>
    </item>
    <item>
      <title>Re: JavaScript Functions in Expression Editor</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/javascript-functions-in-expression-editor/m-p/425034#M13137</link>
      <description>&lt;P&gt;It's &lt;STRONG&gt;impossible&lt;/STRONG&gt;: expressions from workflows (and that appears in the nlClient UI) are only pure SQL translation expressions... You will never find any JS dedicated expression in it:&lt;BR /&gt;low level expression are ran directly on the DB layer. higher level expression (from JSAPI) are ran on the JS engine layer (on top of the DB layer)&lt;BR /&gt;&lt;BR /&gt;If you need to add new SQL expression, you can use this documentation:&lt;BR /&gt;&lt;A href="https://experienceleague.adobe.com/docs/campaign-classic/using/configuring-campaign-classic/api/adding-additional-sql-functions.html?lang=fr-FR" target="_blank"&gt;Ajout d'autres fonctions SQL | Adobe Campaign&lt;/A&gt;&lt;/P&gt;</description>
      <pubDate>Sun, 26 Sep 2021 20:00:48 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/javascript-functions-in-expression-editor/m-p/425034#M13137</guid>
      <dc:creator>LaurentLam</dc:creator>
      <dc:date>2021-09-26T20:00:48Z</dc:date>
    </item>
  </channel>
</rss>

