Hi,Here is an alternative solution with analyze="true" and the variable @<my_enum_var>Label :// vars.targetSchema = default variable generated by the previous Query activity in a workflow temp:queryExportDriveStatusvar schemaName = vars.targetSchema.substr(vars.targetSchema.indexOf(":")+1);logInfo(s...
Hi,I don't think you can display a memo since it is not an SQL field but an XML one.you need to use some method like Substring(MyMemo,0,255)Kind regards,Pierre
Hi,Here are some suggestion, including using a google api :https://stackoverflow.com/questions/42432107/line-chart-generated-image-that-will-be-sent-through-email/42521640 Kind regards,Pierre
Hi Erik,you could create mutilple sequences in SQL scripts like this :And by defining an SQL function to get the next value of your sequences (Adding additional SQL functions):<?xml version="1.0" encoding='ISO-8859-1' ?><!-- ===========================================================================...
Hi,if you want to use the variable in 1 workflow only use an instance variable :instance.vars.myVariable = "blablabla";you can find more details here : JavaScript scripts and templates https://helpx.adobe.com/campaign/kb/instance-variable-in-workflow.htmlon the other hand, if what you are looking fo...
Hi,you can store the status of the workflow in an instance variable called running in an advanced Javascript Code activity and a Wait activity like this (don't forget to set your variable running to false at the end of the workflow) : Kind regards,Pierre
Hi,your table name is weird. just keep it simple and use alphanumerical characters and if you want to separate words just use camelcase or underscores.Kind regards,Pierre