While If/then/else method is correct, it can lead to unreadibility if lot of tests.So use rather what I mentioned, OR operator or even, switch statement as is:<%switch (targetData.ita_contact_hist_enrich.xcoh_state_enrich) {    case "CT":        action1tobedone        break;    case "VA":        act...

Posts on related subjects:Security audit/logs for AC6.1/7 Double Opt-in for EU GDPR Compliance

Hi Jael,IN operator is for SQL query where clause.For Javascript use either operator || (OR) or switch statement to be more concise than your syntax, repeating the test in case of same action targeted. But of course your  syntax works fine as well...RegardsJ-Serge

Hello Jael,Please might you explain why you intend to use regex for SQL queries instead standard SQL possibilities?Usually regex is used in script languages (Javascript, JSSP for Adobe Campaign).In SQL depending on field type you have these choices:1. [numeric field] between operator in where clause...

Hi Salvatore,Besides of what Amit suggested, filter by context (which is a powerful mean for filtering data) from interactive input flow, even with the standard query you should not have issue to select/filter the records targeted with the method you took.Debugging reports is sometimes tedious task,...

Hi Salvatore & Adhiyan,Actually there are 2 main cases:1. sequence managed by the RDBMS (database) itself2. sequence managed by Adobe Campaign (autopk=true)Of course I used to use both depending on context.But you must take care that you must not alter the sequence value targeted with instruction gi...

Please have also a look on xtkNewId (and GetNewIds):https://docs.campaign.adobe.com/doc/AC/en/browseAC.html https://docs.campaign.adobe.com/doc/AC/en/PRO_Database_maintenance_Application_objects.html

Hi Salvatore,Please may you explain a bit more why you must force the ID values in your import job, instead of letting Adobe Campaign import system increment automatically the primary key value of the targeted standard objects?And will you import the data with Adobe Campaign tools (workflow activity...

Hi Jael,Please don't duplicate entries, see reply there:Substring function RegardsJS

Dear all,Please, may you share your concerns about Adobe Campaign compliance to GDPR law?European Union law that will apply on May 2018 and have impacts on all software editors and customers, all around the world actually (penalty up to 4% of companies worldwide turnover): http://www.eugdpr.org/ I w...