Hello,im using this native query and it works fine but i want to know how i can do the Something using queryDef.this is my native SQL: var email = NLWS.xtkSession.FormatDataPolicy("lowerCase", email.trim()); var firstName = NLWS.xtkSession.FormatDataPolicy("lowerCase", firstName); var lastNa...
In Adobe Campaign Classic we have the ability to store a 'prefered sending time' of a customer (read: recipient).We have (external) logic to calculate that prefered sending time, which will differ per recipient. Expected behaviour is that the recipient will receive the delivery on the prefered sendi...
I wan to remove out of the box index from my customized schema. When I do that using DROP Index script,the index gets removed but whenever I do a update database structure on that schema, the indexes gets added again. Is there a way to remove the out of the box indexes permanently?
Hi Everyone, I have a high priority situation wherein i need some help from you guys- I have a script which pulls in subject line dynamically and in the delivery subject field (let's say the script is <%=subjectline%>) but when i look into the delivery/emailHeaderParameters/@subject it shows me exac...
Hello, i would like to change the xtk:shared/view.js Javascript Code. Do you know how i can change it? What is the best practice? Change the code or extend it? Best Regards and Thanks
I'm trying to loading data from an external database from MYSQL. I use the external account for sync the data, but it's very slowly for loading the data(it will cost 21 minutes to load 250k rows of data. How could I config the server to make it faster? thank you!
Hi Everyone,I have a use case where I need some help- I want to know all the deliveries which are deployed on a given day and send it to myself in an email as a file attachment.All the deliveries deployed can be found using a query and a temp schema with all required fields can be prepared. But how ...
Hi Everyone, I am trying to write a queryDef code where in I want to filter the records based on the internalName of the previously executed delivery dynamically. Something like below- var query=xtk.queryDef.create(<queryDef schema="nms:delivery" operation="select"/><select><node expr="@id"/></selec...