Advertisement
Guest User

Untitled

a guest
Nov 18th, 2019
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.50 KB | None | 0 0
  1. select ol.TpaId, ol.UserBy, ol.DateTimeUtc,
  2. ChangeType = case olc.ChangeType
  3. when 0 then 'Update'
  4. when 10 then 'Insert'
  5. when 100 then 'Delete'
  6. end, olc.EntityPrimaryId,
  7. ol.[Description]
  8. from OperationLog ol
  9. left outer join OperationLogChange olc
  10. on ol.PrimaryId = olc.OperationLogId
  11. where 1 = 1
  12. --and ol.TpaId = 'T02002'
  13. and ol.Description like '%Update page -%'
  14. and olc.EntityName = 'PageWidgetBrandVisibilityData'
  15. and olc.EntityPrimaryId like '%;WCDDEMO1;%'
  16. order by ol.DateTimeUtc;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement