@Haricharan, if you look at the error it says that the column you are trying to update "mmemodescription" in the temp table does not exist.Make sure that you add this column in your workflow additional data in order to manipulate using the sqlExec statement. BR,Ishan

Hi @bcollado,I understand that a recipient can place multiple orders and an order can possibly have multiple products in it. For this, you will need to implement enrichment activity in your workflow to get the last order or product ID placed by the customer, and then you can use in the email for per...

Hi @Haricharan, You are getting an error in your select queryDef itself, and that is happening because you are trying to query from the temp:query schema, whereas the schema changes to something like temp:changeDataSource when you change the data source. Please check your js inbound transition to kn...

Hi @DishaSharma,Once the workflow activity picks up a file for processing, it will delete the original file right then from the external SFTP directory. It does not wait for the workflow to complete.ACC implicitly copies the file into its specified archive directory, from where it uses the file for ...

Hi @DishaSharma,The file transfer activity has a setting in the advanced parameters to delete the source files after transfer.Select this option and your original files will be deleted from the location and not be processed the 2nd time. BR,Ishan

Hi @Haricharan, To update temp table data in ACC v8 using the above script, you must use the "change data source" activity, and select "default data source" in the activity. Then your script should work fine if there are no other syntax errors. Let me know if that helped. BR,Ishan

Hi @Haricharan,This error seems to be related to the Snowflake sql rights. Can you share the workflow activity settings and your exact code? BR,Ishan

Hi @Sanjana12, Check that both the fields you are comparing are of the date or datetime data type. If not, the function might not give you correct results or no results at all. BR,Ishan

Hi @vani97,If you want to carry these values from one page to another, e.g. for data capturing, etc., then you need to use document.controller to transfer the values.So in the script on the page where these values are being entered by the user, you need to use document.controller.setValue('/ctx/vars...

Hi @Kumar_27,To update temp table data in ACC v8 using the above script, you must use the "change data source" activity, and select "default data source" in the activity. Then your script should work fine..Let me know if that helped. BR,Ishan