CoreBOSBB

CoreBOSBB > Support > Administrator Support > Pasting a Query in SQL report HTML encodes characters
Full Version: Pasting a Query in SQL report HTML encodes characters
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

Guido1982

02-01-2019, 09:00 AM
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.

joebordes

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

Guido1982

02-05-2019, 08:40 AM
(02-01-2019, 10:20 PM)joebordes Wrote: [ -> ]see if this helps: https://github.com/tsolucio/corebos/commit/d9a7bfa52802d25e2d60479628e9bd5d121c383f

Did the trick, thanks!
CoreBOSBB > Support > Administrator Support > Pasting a Query in SQL report HTML encodes characters