I'm new to Adobe Campaign Classic.
Currently, I have a hard time to map the internal table name that running workflow using.
I found some workflow consume a very high transaction log due to some un-experienced users.
There is one INSERT statement that I saw in the database which insert into wkf18471480_381_2 which I need to map back to it's workflow.
Is there any dataschema or SQL query that I can easily map back?
Thank you in advanced. 🙂
I finally found it.
We can find the internal tablename that workflow are using by filter in column 'Visual Status' in dataschema xtk:workflow using contains mapping.
Or you can directly query at the database level by
select * from <schama>.XtkWorkflow where mVisualState like '%wkf12345678%';
Hope this can help you to easily track back from the SQL statement to workflow name.
Thanks to all again.
Thanks for all comments but those are not for my objective.
Currently, I saw the table name at the database server.
I need to map that name back to workflow name.
How can I do?
Click on Workflow Properties - > Execution Tab -> Check "Log SQL queries in journal" .
Then whenever you execute the workflow you can see the exact SQL queries that are running behind the scene .
Hope this helps!
In the workflow, you can log the interim table name by the variable vars.tableName: