Hello @fgtrrt,   No the list id montioned in script above is really the list identifier (@id attribut of nms:group schema). Please find bellow an adaptation of the script if you want to use it with internal name of the list:   var nameList = 'changeThisToInternalNameOfYourList'; var list = xtk.query...

Hi @god_prophet,   The xxx part in instance.vars.xxx isn't at all a collumn of xtk:workflow. You should declare it before using it on the workflow. Exemple of declaring it on a js code activity :    After executing the workflow you can see the variables on the Properties on the workflow here  :   ...

Hello @fgtrrt,   Please find bellow an example on how to do it (i've also added how to have the count of the list content). Let's say the id of your list is 123456 :     var idList = 123456; var list = xtk.queryDef.create(<queryDef schema="nms:group" operation="get"> ...

Hello @god_prophet,   You can force the colomn sql name to the old sql name so that Adobe does not try to drop and recreate it like this :   <attribute label="Email 2.Informativo" name="EMAILINFORMATIVO" sqlname="semailrelacionalalertas" type="string"/>     Br,  

Hello @o_X, i've had the same need in the past, here is how i did it :    //Get lastLog Date from NmsTracking_Pointer option var trackingOption = getOption('NmsTracking_Pointer'); var trackingOptionXML = new XML (trackingOption.replace("<?xml version='1.0'?>","")); var dateLastLog = parseTimeStamp(t...

Hello @JieunKi1    Could you share your Google BigQuery external accout config?   Br,

Hello @JieunKi1   You have to create a custom named right and give to non-amin users who need access to remote database. Please follow this instructions to do so.   Br,  

Hello @rvnth,   it's feasible via a query activity, bellow an exemple.   Content of the expression is : Iif(AddDays(DateOnly(@created) , 11) > AddDays(DateOnly(@lastModified) , 21) , AddDays(DateOnly(@created) , 11) , AddDays(DateOnly(@lastModified) , 21)) I took @creates as your column1 and @lastM...

Hello @A_B_SE,   By creating sub folders under /Profiles and Targets/Predefined filters/  you can orginize your filters as you wish. Exemple :  Result :      it is even working on form view :    Br,    

Hello @LukasPe1,   The nlserver sql can be used to execute sql object from adobe campaign. Bellow an exemple : I've created a sql object in the console to insert a row in a table :   i can execute this script using nlserver sql as bellow : result the row is inserted in my table : You can also use...