We have a custom table to provision to an specific database. We've implemented a custom proccess to provision that database. We have 2 problems
If one colum changes the process only updates the change in that column and ignore others. To not introduce in the generating condition all columns that a change should run the provision process. Is there anyway to act like AD conector that detects changes on columns affected in a mapping? We only want the proccess to launch if the columns are associated to the mapping as that table has other columns that should not lauch the proccess and thats why we could not use event update alone for that tables.
Is there anyway that even if one column change and the proccess launches, sync proccess compare all other columns with the database and not ignore other those?
We are using adhocprojection single for the step in the process