Pasting a Query in SQL report HTML encodes characters

Pasting a Query in SQL report HTML encodes characters - Printable Version

+- CoreBOSBB (https://discussions.corebos.org)
+-- Forum: Support (https://discussions.corebos.org/forumdisplay.php?fid=17)
+--- Forum: Administrator Support (https://discussions.corebos.org/forumdisplay.php?fid=8)
+--- Thread: Pasting a Query in SQL report HTML encodes characters (/showthread.php?tid=1391)

Pasting a Query in SQL report HTML encodes characters - Guido1982 - 02-01-2019

When I create an SQL report and include a condition like:

PHP Code:

crment_so.createdtime > '2016-01-01 00:00:00' 

It gets saved to the database as

PHP Code:

crment_so.createdtime > '2016-01-01 00:00:00' 

Is this a bug or do I need to change a setting?

EDIT
Ironically, the character of course get decoded here so you will see a right arrow in both code examples and I don't know how to correct that, but trust me, it gets HTML encoded in the database.

RE: Pasting a Query in SQL report HTML encodes characters - joebordes - 02-01-2019

see if this helps: https://github.com/tsolucio/corebos/commit/d9a7bfa52802d25e2d60479628e9bd5d121c383f

RE: Pasting a Query in SQL report HTML encodes characters - Guido1982 - 02-05-2019

(02-01-2019, 10:20 PM)joebordes Wrote: see if this helps: https://github.com/tsolucio/corebos/commit/d9a7bfa52802d25e2d60479628e9bd5d121c383f

Did the trick, thanks!