New format for UR 1.6

Discussion created by sachinsharma on Apr 27, 2011

FYI This took me by surprise last week when I tried to open up the existing UR reports on a NMS 5.1 / UMP 2.1 / UR 1.6 fresh install, but the format for the data we collect in reports isn't in just plain SQL anymore. It's in a new format called JSON. Here's more details I got from support:


Since UR 1.6 has multi-platform/database support, there are subtle SQL dialect differences between the database systems, so development had to abstract that out using JSON for it to work with MySQL and Oracle.