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.