Hi @ogonzalesdiaz ,As your data type is string, you need to give 's' in prefix of the attribute name while running the SQL code.Please try the below SQL code and execute it - it will work!SELECT COUNT(DISTINCT sDESCORREOAF) AS DESCORREOAF FROM NmsRecipients;Thanks,Sanchari

Hi @ParthaSarathy ,I've tried answering to one of the questions in community. Please have a look at it.Below is the link: https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/import-in-delta-mode/td-p/621918Regards,Sanchari

Hello @Frankie_d,You can create a recurring import workflow to import your delta file.Create a workflow as below and modify the workflow based on your business requirement.For full configuration of this workflow, follow the setup guidelines from the link below:https://experienceleague.adobe.com/docs...

Thanks @ParthaSarathy , looking forward to explore more on this topic.

Hi Akshaaga, Thanks for your help.I had tried running the script in different instances. But had received the same error "Unable to load the document of identifier 'xtk:workflowExecutionContext'".And we are Hosted system. So we don't have access to server to check the file in the mentioned directory...

Thank you again for your reply. Created a query on broadLogRcp as targeting dimension and filtered on address. No additional data added. In JavaScript, I've copy pasted the script provided by you, and edited on only by replacing instance URL. Error Log received: XFR-180000 The file '/usr/local/neola...

Thanks for your patience and clear explanation! Workflow: Query: (internal name: query) Javascript: Copy pasted the same in JS   Error received, JST-310000 Error while compiling script 'WKF2807/js242' line 2: ctx is not defined.   Tried using queryDef on temp:query, and used same script in...

Thanks for Your response Akshaaga.I am trying to generate Mirror page URL in JS activity in a Workflow.       Attribute 'id = currentInstance' unknown (see definition of schema 'Delivery logs (Recipients) (nms:broadLogRcp)').XTK-170036 Unable to parse expression '[@id = currentInstance/@deliveryRcp...

Thanks for your response. Yes this works for new deliveries. But is there any way to fetch mirror page for all existing deliveries which have been already sent, irrespective of mirror page configured in Delivery.

Hi @akshaaga , Yes We had tried the same.   Created 2 deliveries, one with mirror page configured and one with no mirror page. After sending delivery, had Queried my email id using JS to fetch those 2 records using queryDef. But by using the syntax provided, Mirror page URL generated in JS is not wo...