Hi there,
we are trying to make some quality checks for a huge number of systems and I cannot find a reliable relationship between Workflow Steps and its Processing configuration.
This is what I have done:
DPRShell -- Sync Project
INNER JOIN
DPRProjectionConfig -- Workflows
ON DPRShell.UID_DPRShell = DPRProjectionConfig.UID_DPRShell
INNER JOIN
DPRProjectionConfigStep -- 'Workflow' Workflow Steps
ON DPRProjectionConfig.UID_DPRProjectionConfig = DPRProjectionConfigStep.UID_DPRProjectionConfig
At this point, what I see in SQL is the same as SyncEditor. Then I looked for DPRSchemaMethod to get the "Processing" information
--INNER JOIN
--DPRSchema
-- ON DPRShell.UID_DPRShell = DPRSchema.UID_DPRShell -- Relationship to target System
--INNER JOIN
--DPRSchemaType
-- ON DPRSchema.UID_DPRSchema = DPRSchemaType.UID_DPRSchema -- Column relationship to target System (f.e. UNSAccountB & EXTENDEDSIM.WIKI_USERS)
--INNER JOIN
--DPRSchemaMethod -- Workflow -> Edit synchronization step... -> Processing
-- ON DPRSchemaType.UID_DPRSchemaType = DPRSchemaMethod.UID_DPRSchemaType -- Actions to be executed for each table (DPRSchemaType)
Adding this tables, for a particular Workflow Step that contains for example only an update in target system in A2 several rows in DPRSchemaMethod (Delete object, Insert object, Mark objects as outstanding). After researching the meaning of this rows and their relation to other tables, this result does not make any sense for me.
Could you please help me to understand this tables and reconstruct the processing configuration in SQL?
Thank you very much in advance.
Kind regards,
Jose