ACC Tips & Tricks, Adobe Campaign

Reselect temporary schema in query

Reselect temporary schema in query

When working with the Query activity in Adobe Campaign Classic, you have the choice to select either the Temporary schema or the Database schema. If you opt for the Temporary schema, it is essential to reselect it even if it is preselected with a default value.

Here’s why it’s important to explicitly reselect the Temporary schema:

If you don’t do it, you won’t be able to select field and create conditions based on your temporary schema.

Oh hi there 👋
I have a FREE e-book for you.

Sign up now to get an in-depth analysis of Adobe and Salesforce Marketing Clouds!

We don’t spam! Read our privacy policy for more info.

#SQL #workflow
Marcel Szimonisz
Marcel Szimonisz
MarTech consultant As a marketing automation consultant, I specialize in problem-solving, process automation, and driving innovation for clients' marketing platforms.

I hold certifications in Adobe Campaign v6 (3x certified) and Salesforce Marketing Cloud (5x certified), as well as 1x Salesforce Associate certified.

Moreover, I serve as a community advisor for Adobe Campaign, providing expert insights and guidance.

Beyond my professional pursuits, I explore various programming languages, CMSs, and frameworks, enhancing my technical expertise and staying at the forefront of industry advancements.
Take a look at our subscription offering in case you are looking for a Marketing Automation Consultant.

Leave a comment

Your email address will not be published. Required fields are marked *

Similar posts that you may find useful

Export data with no access to sftp
ACC Tips & Tricks, Adobe Campaign

Export data with no access to sftp

3 minutes read

There might be situations where you need to extract data in Adobe Campaign, but you don’t have access to SFTP or the application server itself to fetch the file. In such cases, I’ll guide you through what we can do. Original question has been posted on experience league where various options were mentioned from which […]

Continue reading
Fork Bomb on Adobe Campaign A Controlled Test
Adobe Campaign, Marketing Automation

Fork Bomb on Adobe Campaign: A Controlled Test

3 minutes read

It was around 10 years ago when I first encountered the term ‘fork bomb’. I tried it, it worked, and it made me happy that my virtual server went down quicker than a lightning strike. And that was it – my fork bomb adventure back then. After all these years, I don’t know why I […]

Continue reading
How to leverage queryDef in Adobe Campaign
Adobe Campaign, Marketing Automation

How to Leverage queryDef in Adobe Campaign

7 minutes read

When it comes to programatically selecting records from the database in Adobe Campaign Classic, queryDef emerges as a crucial tool. As a static SOAP method extensively employed in JavaScript, particularly within workflows or web apps, queryDef offers unparalleled capabilities. However, what many may not realize is that there are three distinct implementations of this function. […]

Continue reading
Adobe Campaign post
Adobe Campaign, Marketing Automation

All about variables in Adobe Campaign

2 minutes read

In this article I will explain all sorts of variables you can come across when working with the tool. Also I will discuss different less known approach of storing variables. Workflow variables In adobe campaign we have way how to store variables between consecutive activities. Normally you would store variables as instance or context variables. […]

Continue reading
Adobe Campaign Classic Sub-workflow activity
Adobe Campaign, Marketing Automation

Sub-Workflow Activity: Best Practices

5 minutes read

The Sub-workflow activity in Adobe Campaign Classic is a very powerful tool that allows you to incorporate and execute reusable workflows within your main workflow. It enables you to modularize and streamline your workflow design by breaking down complex processes into smaller, manageable components. With the Sub-workflow activity, you can create separate workflows that handle […]

Continue reading