zenit icon indicating copy to clipboard operation
zenit copied to clipboard

Scaping special symbols in HTML format in AuditLog

Open debeando opened this issue 5 years ago • 0 comments

The values stored in the field sqltext in auditlog have query with this special symbols:

  • > Stands for the greater-than sign ( > )
  • &lt; Stands for the less-than sign ( < )
  • &#10; Stands for the NewLine
  • &#9; Stands for the Tab

For example:

select text_value, value from constants&#10; where table_name = 'xxx' and column_name ='status'

debeando avatar Sep 27 '18 12:09 debeando