Roger, try a case statement up in the select statement to add those as their own columns.
e.g. case
when <whatever condition evaluates to true> then <return this>
end as [whatever you want to name the column]
As for a workflow log that logs structure changes, I would be shocked. That is the equivalent of asking to see the structure changes in a log for the doc type. Not that these couldn't change, but I thought that currently all the logs, just log data changes, not structure changes. If this has changed, someone please point me in the right direction?
