Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select ol.TpaId, ol.UserBy, ol.DateTimeUtc,
- ChangeType = case olc.ChangeType
- when 0 then 'Update'
- when 10 then 'Insert'
- when 100 then 'Delete'
- end, olc.EntityPrimaryId,
- ol.[Description]
- from OperationLog ol
- left outer join OperationLogChange olc
- on ol.PrimaryId = olc.OperationLogId
- where 1 = 1
- --and ol.TpaId = 'T02002'
- and ol.Description like '%Update page -%'
- and olc.EntityName = 'PageWidgetBrandVisibilityData'
- and olc.EntityPrimaryId like '%;WCDDEMO1;%'
- order by ol.DateTimeUtc;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement