[WebERP-developers] weberp AuditTrail.php display misleading information

[gilberto d. s. a. <gs...@gm...>]

[1]
https://sourceforge.net/p/web-erp/code/HEAD/tree/branches/working/AuditTrail.php#l122

​[2]
https://sourceforge.net/p/web-erp/code/HEAD/tree/branches/working/AuditTrail.php#l139

Hi. after make some retrieval for audit on weberp current version, i could
find that in some cases when
column contains SET, WHERE, AND, DELETE, FROM these contents is replaced
with blanks on AuditTrail functions at  [1] and/or [2].

these fragment of query should explain content of table audittrail columns
and contents (json format)

{"transactiondate":"2016-08-30
16:16:04","userid":"gsavix","querystring":"UPDATE
stockmaster\n\t\t\t\t\t\tSET longdescription='CAMISETA POLO FEM VERMELHA
P',\n\t\t\t\t\t\t\tdescription='CAMISETA POLO FEM VERMELHA
P',\n\t\t\t\t\t\t\tdiscontinued='0',\n\t\t\t\t\t\t\tcontrolled='0',\n\t\t\t\t\t\t\tserialised='0',\n\t\t\t\t\t\t\tperishable='0',\n\t\t\t\t\t\t\tcategoryid='PETA',\n\t\t\t\t\t\t\tunits='UN',\n\t\t\t\t\t\t\tmbflag='B',\n\t\t\t\t\t\t\teoq='0',\n\t\t\t\t\t\t\tvolume='0.0000',\n\t\t\t\t\t\t\tgrossweight='0.0000',\n\t\t\t\t\t\t\tnetweight='0.0000',\n\t\t\t\t\t\t\tbarcode='',\n\t\t\t\t\t\t\tdiscountcategory='',\n\t\t\t\t\t\t\ttaxcatid='6',\n\t\t\t\t\t\t\tdecimalplaces='2',\n\t\t\t\t\t\t\tshrinkfactor='0',\n\t\t\t\t\t\t\tpansize='0',\n\t\t\t\t\t\t\tnextserialno='0'\n\t\t\t\t\tWHERE
stockid='CPFE0314'"}

AuditTrail.php shows column description like ='CAMIA POLO FEM VERMELHA P'
cause
is
...
function UpdateQueryInfo [1] that replace

'CAMISETA' by 'CAMIA'

that is clearly not intended.

Please should I open one ticket or someone could change this.

thanks!